US: 1-941-4621-069
  
Cyprus: 3-572-2052-781

Go Back   ISPsystem.com Forums > ISPmanager > Troubleshooting


Closed Thread
 
Thread Tools
Old 11-02-2009, 12:59 PM   #1
Junior Member
 
Join Date: Nov 2009
Posts: 4
milstanyu is on a distinguished road
Default 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 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!
milstanyu is offline  
Old 11-02-2009, 06:53 PM   #2
ISPsystem team
 
slava's Avatar
 
Join Date: May 2008
Location: ISPsystem
Posts: 588
slava is on a distinguished road
Default

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

Last edited by tanya; 11-03-2009 at 04:37 AM.
slava is offline  
Old 11-02-2009, 06:56 PM   #3
Junior Member
 
Join Date: Nov 2009
Posts: 4
milstanyu is on a distinguished road
Default

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.
milstanyu is offline  
Old 11-03-2009, 05:10 AM   #4
ISPsystem team
 
Join Date: Oct 2009
Posts: 118
vian is on a distinguished road
Default

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

Last edited by tanya; 11-05-2009 at 06:16 AM.
vian is offline  
Old 11-04-2009, 12:31 PM   #5
Junior Member
 
Join Date: Nov 2009
Posts: 4
milstanyu is on a distinguished road
Default

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?
milstanyu is offline  
Old 11-04-2009, 12:46 PM   #6
ISPsystem team
 
slava's Avatar
 
Join Date: May 2008
Location: ISPsystem
Posts: 588
slava is on a distinguished road
Default

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.
slava is offline  
Old 11-04-2009, 12:50 PM   #7
Junior Member
 
Join Date: Nov 2009
Posts: 4
milstanyu is on a distinguished road
Default

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
milstanyu is offline  
Closed Thread

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +2. The time now is 04:28 PM.