Wrong username/password. Access denied phpmyadmin

vishal3184

Registered
Feb 3, 2011
1
0
51
Hi All,

I am newbie to cPanel. I have a created a database using phpMyAdmin which has 3 tables.

Today morning i have reset my cPanel's password and unfortunately i am not able to see 2 tables of my database. It gives me an error of "Wrong username/password. Access denied." (I can see one of the table in database)

Thanks in advance.
 

forum17

Active Member
Mar 30, 2007
29
0
151
Hi All,

I am newbie to cPanel. I have a created a database using phpMyAdmin which has 3 tables.

Today morning i have reset my cPanel's password and unfortunately i am not able to see 2 tables of my database. It gives me an error of "Wrong username/password. Access denied." (I can see one of the table in database)

Thanks in advance.
Please try reseting the password for the cpanel account and check.

If that do not works, you can try executing the below script

/scripts/grabmysqlprivs

If you are still having issues then the issue could be mysql password is not reset even if we reset the cpanel password. In this case you need to update the mysql password for the user from the shell to that of changed cpanel password.

mysql> update user set password=PASSWORD("pass") where user='user';
mysql> flush privileges;

Regards,
host.co.in
 

coderiser

Member
Jan 31, 2011
18
0
51
go in your whm and reset the root mysql password
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
Resetting the root MySQL password would not correct the cPanel user's password not working for accessing tables in a database. I would suggest resetting the cPanel password again and ensuring that "Allow MySQL password change" is checked when changing the password.

If it is and you are still having issues, go to your root directory for that user (/home/username) and check for a .my.cnf file there. If there is one, check that the password listed is the same as the new password you've used for MySQL and cPanel. If it is not the same, change to the right password.
 

cyberdyne

Member
Jun 23, 2011
18
0
51
Resetting the root MySQL password would not correct the cPanel user's password not working for accessing tables in a database. I would suggest resetting the cPanel password again and ensuring that "Allow MySQL password change" is checked when changing the password.

If it is and you are still having issues, go to your root directory for that user (/home/username) and check for a .my.cnf file there. If there is one, check that the password listed is the same as the new password you've used for MySQL and cPanel. If it is not the same, change to the right password.
Is the password that is contained within the '.my.cnf' file meant to only control only MySQL access? I ask as I have a different passwords for my cPanel login and phpMyAdmin, and I've also noticed that the password within the '.my.cnf' file is different again to the two others.

Thanks
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
The .my.cnf in /home/username handles MySQL database logins for PHPMyAdmin as the cPanel user as well as for database credential logins as that same user (if any script is set to use the cPanel username).