- Plesk 12.5 for Linux
- Plesk 10.x for Linux
- Plesk Onyx for Linux
- Plesk 11.x for Linux
- Plesk 12.0 for Linux
- Plesk 9.x for Linux
Plesk upgrade or installation fails with one of the following errors in
CONFIG_TEXT: Access denied for user 'admin'@'localhost' (using password: YES)
CONFIG_TEXT: Access denied for user 'horde'@'localhost' (using password: YES)
CONFIG_TEXT: Access denied for user 'pp_sb_db'@'localhost' (using password: yes)
CONFIG_TEXT: EMERGENCY: The file /root/.my.cnf contains a password for the MySQL console client. Please remove this file temporarily and restore it after the upgrade, otherwise the upgrade will fail.
Attempt to connect to Plesk database fails:
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
There is a
/etc/mysql/conf.d/vsh-mariadb.cnffile on the server containing invalid credentials:
# cat /root/.my.cnf
Invalid MySQL credentials. Additional MySQL configuration files are included.
- MySQL reads 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)
Plesk uses the environment variable to pass the password to MySQL server, but
.my.cnffile has a greater priority and MySQL uses the password from this file.
Make sure there are no additional MySQL configuration files like
/root/.my.cnfwith MySQL password. If it exists, rename it:
# mv /root/.my.cnf /root/.my.cnf.backup
Since 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.cnffile use the following directive:
CONFIG_TEXT: !include /home/mydir/myopt.cnf
If there is an !include directive make sure it does not refer to invalid credentials.