- 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)
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
file has a greater priority and MySQL uses the password from this file.
Make sure there are no additional MySQL configuration files like
with MySQL password.
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
file 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.