backup error while doing mysql backup

[milstanyu]

Every time I do backup, I got this error message:

2009-11-02 Databases partial backup failed: Unable to dump mysql database: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect

I have several mysql databases that I need to be included in backup. I can access them normally as root user through phpMyAdmin.

I am running IPS Manager Pro 4.3 on VPS.net server (Ubuntu 8.04 x64 LAMP).

Thanks a lot for your nice and useful software!

[slava]

You need to write correct mysql root password in the ISPmanager Server configuration - Database servers menu

[milstanyu]

It's already done. I put "root" as user there and valid password. With this password I can login in phpMyAdmin as root user and work with DBs without problems.

[vian]

Please check file my.cnf or .my.cnf in your home directory. There should be an alternative configuration which is used when mysql tries to do a dump

[milstanyu]

Thanks for advice. I found file .my.cnf, but not in /home directory, but in /root directory. I changed it to be:

[client]
user=root
pass=mypasshere

However, the error is still there. Should I copy this file to /home directory?

[slava]

You do not need to add lines with password to my.cnf file, you need to remove it if this file contain incorrect data.

Login and password for mysql server must be inserted in the ISPmanager - Database servers menu

[milstanyu]

OK, I removed it from /root. DB pass is already in Database servers menu. Beside that:

Connection type: Local
Coding: Latin1
Path to socket file: /var/run/mysqld/mysqld.sock
Access: Allow to all