Get your server issues fixed by our experts for a price starting at just 25 USD/Hour. Click here to register and open a ticket with us now!

Author Topic: Plesk ERROR: PleskFatalException Unable to connect to database: saved admin pass  (Read 1979 times)

0 Members and 1 Guest are viewing this topic.

rohitj

  • Guest
Plesk ERROR: PleskFatalException Unable to connect to database: saved admin password is incorrect. 0: common_func.php

This is because the password in the file /etc/psa/.psa.shadow used to access the Plesk Panel database does not match your admin password.

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


Restart the MySQL server:

# /etc/init.d/mysqld restart


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';"

Delete the skip-grant-tables option from the "/etc/my.cnf" file.

Restart the MYSQL server:
# /etc/init.d/mysqld restart

OR

Simply reset your PP admin password using the ch_admin_passwd utility:

    # export PSA_PASSWORD=<NEW_PASSWORD>
    # /usr/local/psa/admin/bin/ch_admin_passwd


Replace <NEW_PASSWORD> above with a password of your choice.

 ;)