'root@localhost' (Using password: YES) at /usr/local/cpanel/Cpanel/Mysql.pm line 42".

[tvmt]

Hi !

i have error with mysql database.

i set my Setup to Remote MySQL server on cpanel = IP, but unsuccess.
when i change mysql server to localhost, i get error : all database disappear in mysql (cpanel interface), i can see it in phpmyadmin.

and this is error in mysql:
DBI connect('mysql:localhost','root',...) failed: 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)

i can using database for normal.

how i can correct this?

please help me!

[NrgUser]

root@localhost means that you are trying to connect with user root on your own server, not the other one.

[xanaduservers]

For anyone else seeing this open /root/.my.cnf on your cPanel server and on the remote server then verify the password.

[Divino]

In the SQL Services.
I changed the password in: MySQL Root Passwd


DBI connect('mysql:localhost','root',...) failed: Access denied for user 'root'@'localhost' to database 'mysql' at /usr/local/cpanel/Cpanel/Mysql.pm line 42

Can anybody help myself to revolve?

Thanks

[Grzeslaw]

1. Edit the file /root/.my.cnf
2. Use the mysql root password in the file and reset the mysql password to that password in .my.cnf file.

/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

[Divino]

He/she perfectly worked.

Thanks.