Tells Me I have the Wrong Password

lonebyrd

I got an error in my script as follows:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'lonebyrd'@'localhost' (using password: YES) in C:\Program Files\xampp\htdocs\login.php on line 2
Access denied for user 'lonebyrd'@'localhost' (using password: YES)

My password in my Config.php file is not yes. I don't know why it is saying it is.

bpat1434

No... it says that you are in fact using a password, but the password is incorrect. It will (and should) NEVER give out the password in an error like that. It's a huge security risk.

What you need to do is double check your mysql_connect() call and verify two things:
1.) The username is the proper username
[indent]In a cPanel environment, the username is usually the site's username (first 8-letters of the domain) underscore ("_") and then your mySQL users name. An example would be:
Domain: domain.com
Username: domain
mySQL User: domain_myUser1

Domain: phpbuilder.com
Username: phpbuild
mySQL User: phpbuild_myUser1[/indent]
2.) The password you're using in the mysql_connect() call is in actuality the password for the mySQL user you're wanting to use.

Houdini

It is the wrong password so since you are using XAMPP you can go to the XAMPP main page then select phpMyAdmin then without selecting a database go to priviliges and you should see root, pma and any other users that have been granted priviliges. On this screen you can edit existing users leave root and pma alone, just add one for yourself and then give it a password, or if you have forgotten the password then delete the existing user (not root or pma) and then re enter them with a new password.

I know that there is a warning about root not having a password (but this is your own PC) so do not add a password for root unless you know that you will also have to edit the phpmyadmin/config.inc file because that is where it looks for a username and password and be default this file is set up with root with no password.

You might want to try to change your Config.php to something like this in the meantime.

<?php
$host="localhost";
$user="root";
$pass="";
$connect =mysql_connect($host,$user,$pass)
  or die("Could not connect to server, MySQL said: ".mysql_error());
?>

bpat1434

One reason why I hate XAMPP.... too easy to get lost in it, and using root for your mySQL.... shame on XAMPP...