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:
/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
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:
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