I don't know what really happened, but all of the sudden the root password for mysql doesn't work and our users are seeing this error in their cpanel:

ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)'

Can anyone help please?

The password in /root/.my.cnf is probably incorrect. You will need to correct it in order to get it to work. If you don't know the right password, you can reset it with the following procedure:

http://www.mysql.com/doc/R/e/Resetting_permissions.html

Best Regards,
Matt Lightner
mlightner@site5.com

Hi Matt, I already tried that and it doesn't do anything. I am having the exact same problem as this guy here:

http://www.vdi.net/forums/viewtopic.php?TopicID=78

Actually, I can change the root password for mysql and see the mysql processes with the WHM, but I get that message with the CPanel and my users cannot access their databases. I cannot access mysql from the shell either.

Is there anything else that you can think off?

Thanks for the help

Youll need to shutdown mysql and restart it with the skipgrant option a quick check of the doco on the mysql site will give the exact option you need to use to start mysql so it doesnt use the users table.Then you can change the root password.

Why are your applications using the root user anyway or is this for the control panel?

Originally posted by madmatty
Why are your applications using the root user anyway or is this for the control panel?

That was the first thing I was thinking! :D Guessing it is the CP (hoping).

It is for the control panel. I have tried with the skip grant option and have reset the password. Still does not work. :(