11-02-2009, 12:59 PM | #1 |
Junior Member
Join Date: Nov 2009
Posts: 4
|
backup error while doing mysql backup
Every time I do backup, I got this error message:
Code:
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 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! |
11-04-2009, 12:31 PM | #5 |
Junior Member
Join Date: Nov 2009
Posts: 4
|
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? |
11-04-2009, 12:46 PM | #6 |
ISPsystem team
Join Date: May 2008
Location: ISPsystem
Posts: 588
|
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 Last edited by tanya; 11-05-2009 at 06:14 AM. |
|
|