Cannot log in to Parallels Plesk Panel (PP). The following error is displayed instead of the login screen:
ERROR: PleskFatalException Unable to connect to database: saved admin password is incorrect. 0: common_func.php3:93 psaerror(string 'Unable to connect to database: saved admin password is incorrect.') 1: auth.php3:127
Cause
The password in the file /etc/psa/.psa.shadow used to access the Plesk Panel database does not match your admin password.
Resolution 1
Simply reset your PP admin password using ch_admin_passwd utility:
# export PSA_PASSWORD= # /usr/local/psa/admin/bin/ch_admin_passwd
Replaceabove with a desired password.
Resolution 2
Note: This only works for PP 9.x and earlier versions.
If the first resolution does not solve your issue, follow these steps to reset the/etc/psa/.psa.shadow password:
1. Modify the MySQL server settings in the file /etc/my.cnf and add the skip-grant-tables
option in the [mysqld] section: [mysqld] skip-grant-tables
2. Restart the MySQL server:
# /etc/init.d/mysqld restart
3. Add new password to the /etc/psa/.psa.shadow file.
4. Reset the password in the service table of the MySQL server:
# /usr/bin/mysql -D mysql -e"update user set password=PASSWORD('`cat /etc/psa/.psa.shadow`') where User='admin';"
5. Delete the skip-grant-tables option from the /etc/my.cnf file.
6. Restart the MYSQL server:
# /etc/init.d/mysqld restart