MYSQL error

[WNWORLD]

Access denied for user 'username'@'localhost' to database 'dbname' Even though in my CPanel I have allowed the user to access to db! Help!

 

[Dead-i]

Access denied for user 'username'@'localhost' to database 'dbname'

Your script (or whatever you are using to connect) is attempting to connect using 'username' to the database 'dbname'. You need to change the configuration to the correct username and database name that you created within your cPanel.

For example, my database username would be something like: deadix10_duser

 

[WNWORLD]

Sorry I hid my db name and that info but look at my code : $con = mysql_connect("localhost","whatsn32_socks","PASSWORD HERE");
if (!$con)
{
error_log("failed to connect:" , 0);
error_log(mysql_error(), 0);
exit("success=false");
} else{
$lol = mysql_select_db("whatn32_social", $con);
if (!$lol){
error_log(mysql_error(), 0);
exit("success=false");
} else{ Error as displayed in original post but matching these variables

 

[WNWORLD]

Please help

 

[descalzo]

Drop the user from the database and then add it back making sure you check ALL PRIVILIGES

On further review:

$lol = mysql_select_db("whatn32_social", $con);


should be the same as your cPanel username (like in your db user). Missing an s