MYSQL connect problem

[sean14592]

hi im getting the following error:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'USERNAME'@'localhost' (using password: YES) in /home/USERNAME/public_html/DIRECTORY/DIRECTORY/reg_pro.php on line 181
Access denied for user 'USERNAME'@'localhost' (using password: YES)

 

ok, Usually I would think, ok it means there login is not correct, but it was all working before I set them up as variables and include config.php. heres my code:

 

re_pro.php

// Make a MySQL Connection
mysql_connect($host,$username,$password) or die(mysql_error());
mysql_select_db($database) or die(mysql_error());

 

config.php

$host = ("localhost"); //Host for all databases
$database = ("DATABASE"); //database containing all tables
$username = ("USERNAME"); //username to access the database
$password = ("PASSWORD"); //password for the above user

 

Thanks in advance.

Sean

[revraz]

Can really only be a couple things.  The username is wrong or the password is wrong,

[Maq]

Also, nothing to do with your problem but here's a better way to set up a class for your MySQL database connectivity: MySQL Class.

[sean14592]

Can really only be a couple things.  The username is wrong or the password is wrong,

 

nope, username and password are 100% correct, I even tried deleting and making  a new user account, any more ideas?

 

thanks

sean

[wildteen88]

When creating a new MySQL user account make sure you are allowing connections from localhost

[sean14592]

yep, im allowing them access to the database

 

[PFMaBiSmAd]

You probably have a typo. Check the spelling and case of what you are doing.

[Chicken Little]

Have you tried restarting the server?

[PFMaBiSmAd]

Another possibility, since you switched to using variables, would be if you have some other code before your mysql_connect() statement that is using those same variable names and have overwritten the values. Posting your whole actual code would help someone to help you without playing a game of 20 guesses first.

[Lee-Bartlett]

Is db connection case sensitive? if so might be that.