mysql error on all cpanel/WHM pages

[WSMITH]

Guys i have got another error which trying to connect mysql

DBI connect(mysql:localhost,root,...) failed:
It show that Access denied for user: root@localhost (Using password: YES) at /usr/local/cpanel/Cpanel/Mysql.pm line 42 ERROR 1045: Access denied for user: root@localhost (Using password: YES) 0 / unlimited.

[rocky123]

I think the root@localhost means that you are trying to connect with user root on your own server, not the other one. For anyone else seeing this open /root/.my.cnf on your cPanel server and on the remote server then verify the password.

[Jeffrey]

Solution for the problem can be as follows:-
Step 1:- First of all Edit the file /root/.my.cnf
Step 2:- Use the mysql root password in the file and reset the mysql password to that password in .my.cnf file.

Code:
---------------------------------------------------------------
/etc/init.d/mysqld stop
safe_mysqld --skip-grant-tables
mysql
USE mysql
UPDATE user
SET password=password("Password in .my.cnf file")
WHERE user="root";
flush privileges;
exit;
killall mysqld
---------------------------------------------------------------