mysqldump error

W

wtfbrb

Verified User
Joined
Oct 11, 2009
Messages
71
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?
 
If you changed the password then you need to update /usr/local/directadmin/conf/mysql.conf
 
Tried that first...

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...
 
Removed /root/.my.cnf the system and things worked perfect. Thanks.
 
Last edited:
You must log in or register to reply here.
Back
Top