PDA

View Full Version : mysqldump error



wtfbrb
06-07-2010, 06:36 AM
All my reseller level user backups give me this error in my messages.

mysqldump error output: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect

I've had some security issues and changed my mysql root pw, via mysql...but I don't know what I need to do to da to change it as well. I thought directadmin used da_admin as it's user...anyhow I haven't had an automatic backup in weeks and I am tired of manually taking them...any suggestions?

scsi
06-07-2010, 07:43 AM
If you changed the password then you need to update /usr/local/directadmin/conf/mysql.conf

wtfbrb
06-07-2010, 08:05 AM
That was the first thing I tried as I found that on another forum. In that file it still says da_admin as the user, I also tried changing that to root without success. The error message clearly says it is using root user...not sure why or where that is stored...

nobaloney
06-12-2010, 09:20 AM
The MySQL root user should be da_admin.

Jeff

wtfbrb
07-16-2010, 01:44 PM
Removed /root/.my.cnf the system and things worked perfect. Thanks.