Articles in this section

See more

Plesk full backup shows a database warning message: Access denied for user 'admin'@'localhost' (using password: YES)" when trying to connect

Avatar
Nelson Leiva
Updated
Follow
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

  1. Log in to the server via SSH.

  2. Rename the additional MySQL configuration files like /root/.my.cnf:

    # mv /root/.my.cnf /root/.my.cnf.backup

Comments

1 comment

Sort by Date Votes
  • Avatar
    Ed Cates

    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?

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles