Article ID: 1657, created on Oct 6, 2008, last review on Jun 3, 2016

  • Applies to:
  • Plesk Automation 11.5
  • Plesk 12.5 for Linux
  • Plesk 12.0 for Linux
  • Plesk 11.0 for Linux
  • Plesk 11.5 for Linux
  • Plesk 10.4 for Linux/Unix


An Plesk upgrade or installation fails with this error in the upgrade log:

Access denied for user 'admin'@'localhost' (using password: YES)


Access denied for user 'horde'@'localhost' (using password: YES)


Access denied for user 'pp_sb_db'@'localhost' (using password: yes)


Invalid MySQL credentials. Additional MySQL config files are included.

There is a /root/.my.cnf file on the server, and it contains invalid credentials and prevents the creation of a MySQL dump on the server.

MySQL programs read startup options (including credentials, if defined) from the following files, in the below order:

defaults-extra-file (The file specified with --defaults-extra-file=path, if any)

So, make sure that password and user are not specified in configuration files above.

Beginning with MySQL 5.0.4, it is possible to use !include directives in option files to include other option files and !includedir to search specific directories for option files. For example, to include the /home/mydir/myopt.cnf file, you could use the following directive:

!include /home/mydir/myopt.cnf


Make sure there is no additional MySQL config file like '/root/.my.cnf' file with a MySQL password. Plesk uses the environment variable to pass the password to the MySQL server, but the '.my.cnf' file has a greater priority and MySQL uses the password from this file. If it does not match, the restoration fails. You should also check the !include directive.

In addition, check you are able to connect to MySQL from the command line using:

~# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa

Search Words

Trying to reset database user password for

Access denied for user 'admin'@'localhost' (using password: YES)

Access denied for user 'pp_sb_db'@'localhost'

Error during plesk update version

automatic updates failing

ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)

Access denied for user 'horde'@'localhost'

move .my.cnf

error 500 email

Plesk upgrade


29d1e90fd304f01e6420fbe60f66f838 a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c 33a70544d00d562bbc5b17762c4ed2b3 e0aff7830fa22f92062ee4db78133079 aea4cd7bfd353ad7a1341a257ad4724a 0a53c5a9ca65a74d37ef5c5eaeb55d7f 01bc4c8cf5b7f01f815a7ada004154a2 caea8340e2d186a540518d08602aa065 2a5151f57629129e26ff206d171fbb5f e335d9adf7edffca6a8af8039031a4c7 e8756e9388aeca36710ac39e739b2b37 dd0611b6086474193d9bf78e2b293040 742559b1631652fadd74764ae8be475e

Email subscription for changes to this article
Save as PDF