Mysql cannot connect - Access denied (using password yes)
I have hosting provided by eleven 2 and I just created a new MySQL user and gave it access to every action listed.
I'm getting the following error
Warning: mysql_connect() [function.mysql-connect]: Access denied for user '(username is here, removed for posting)' (using password: YES) in /home/.../public_html/config.php on line 10
Here is my config file
//connection details have been removed for posting purposes
<?php
define('SQL_SERVER',''); // Database Server
define('SQL_USER',''); // User
define('SQL_PASS',''); // Password
define('SQL_DB',''); // database
mysql_connect(SQL_SERVER,SQL_USER,SQL_PASS) or die("Error: ".mysql_error()); // Connection to the server
mysql_select_db(SQL_DB) or die("Error: ".mysql_error()); // Connecting to the database
?>
I tried to do the following as suggested by this post Access denied for user 'someuser'@'localhost' (using password: YES)
GRANT ALL PRIVILEGES ON databasename.* TO 'bookorama'@'%' IDENTIFIED BY 'yourpassword';
FLUSH PRIVILEGES;
But I got the following error "#1044 - Access denied for user". When I log into the CPanel and check out the database users, it shows the user that I tried to log in as, so I'm confused as to why it won't work.
EDIT - I got it to work. There was something wrong with the server. Contacted the host and they took care of it. Thanks for the replies.
Answer
I stumbled upon this connection info about Cpanel http://www.inmotionhosting.com/support/community-support/databases/1045-access-denied-for-user-mysql-error
Your cPanel username and password can be used to connect to your databases (as well as your cPanel). If you're connecting to your database using your cPanel username and password, you can reset your cPanel password to ensure you are using the correct username and password.
If you setup a MySQL username and password specifically for accessing a database, you'll want to ensure you are using the correct username in your php scripts. For example, MySQL usernames are always in this format:
cpanel-username_mysql-username
If your cPanel username is userna5 and you created a database username of dbuser1, then the actual database username would be:
userna5_dbuser1
Temporarily, I'd suggest changing your databse password to that of your Cpanel account just to eliminate any doubts.