• Article for your preferred language does not exist. Below is international version of the article.

Article ID: 1657, created on Oct 6, 2008, last review on Nov 23, 2015

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

Symptoms

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

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

OR

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

OR

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

Cause

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:

/etc/my.cnf
/etc/mysql/my.cnf
SYSCONFDIR/my.cnf
$MYSQL_HOME/my.cnf
defaults-extra-file (The file specified with --defaults-extra-file=path, if any)
~/.my.cnf

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

Resolution

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 -uadmin -p`cat /etc/psa/.psa.shadow` psa 

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

Email subscription for changes to this article
Save as PDF