Plesk for Linux
kb: technical
ABT: Group B
Applicable to:
- Plesk for Linux
Symptoms
-
Scheduled full backups show the following warning once it's complete in Plesk > Tools & Settings > Backup manager:
PLESK_WARN: Database "example" Unable to make database dump. Error: Failed to exec mysqldump: mysqldump: Got error: 1045: "Access denied for user 'admin'@'localhost' (using password: YES)" when trying to connect
-
MySQL configuration file exists in the
/root/.my.cnf
:# ls -la /root/ | grep .my.cnf
-rw-r----- 1 root root 50 Mar 20 00:49 .my.cnf
Cause
Invalid MySQL credentials. Additional MySQL configuration files are included.
Resolution
-
Rename the additional MySQL configuration files like
/root/.my.cnf
:# mv /root/.my.cnf /root/.my.cnf.backup
Comments
1 comment
I keep getting "Acess denied" errors for the DB dumps in nightly Backups, except it's for 'root'@'localhost,' which doesn't even exist any more. I've checked, and there aren't any .my* files lying around that mysqldump could be getting the password from, either.
Is there a way to tell Plesk Backup to use the correct user with mysqldump?
Please sign in to leave a comment.