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

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

0 comments

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles