MYSQL problems

[eternal-empire]

I try to access the mysql db through my PHP page but this is what i get...


Warning: mysql_connect() [function.mysql-connect]: Access denied for user '****'@'localhost' (using password: YES) in /home/********/public_html/functions.php on line 14
Could not connect: Access denied for user '****'@'localhost' (using password: YES)

I double- and triple-checked the passwords and users of the db...Why is this happening??

Its the same user and same pass...

 

[Corey]

Did you create the database, the user, and then assign permissions to the user for the database?

 

[eternal-empire]

yes, i did...i assign all priviledges for the user on that db

 

[Corey]

You're not adding the prefix to your user and database.

You need to add your username_ before the database name and user name. So if my cPanel name is 'staff' and I create a database called corey the real name is staff_corey same thing for user names.

-Corey

 

[eternal-empire]

aaaahhhhhh..........lemme try that
Edit:
it says could not select db

 

[Corey]

Double check you have the names correct.

-Corey

 

[luciotan]

i think he forgot the prefix. that is common mistakes in Access denied to mysql

 

[eternal-empire]

Problem solved... i had forgotten to change prefix for db too

Thanks a lotttttttttt!!!!!!!!!!!

 

[Corey]

No problem, please re-open if further assistance is needed.

-Corey