Set Mysql Password Psa Plesk

Symptoms
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

Replace above 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