ERROR: PleskFatalException Unable to connect to database: saved admin password is incorrect.

In case you are unable to Log-in your Plesk Control Panel and you are getting following Error Message:

ERROR: PleskFatalException
Unable to connect to database: saved admin password is incorrect.

Follow these steps to recover MySQL admin password:-

–  Stop your MySQL server as                        ::      /etc/init.d/mysqld stop

–  Open your MySQL configuration file      ::      vi /etc/my.cnf

–  Add one line into the [mysqld] section  ::     skip_grant_tables=1

–  Start your MySQL server                              ::     /etc/init.d/mysqld start

–  Login to MySQL as an admin user              ::    mysql -u admin

–  Run query to update admin password     ::

update mysql.user set password=password(‘your_current_password’) where user=’admin’

–   Where [ your_current_password ] is the string from this file /etc/psa/.psa.shadow

–   Exit from the MySQL console

–  Stop your MySQL server as                              ::      /etc/init.d/mysqld stop

–  Open your MySQL configuration file            ::      vi /etc/my.cnf

–  Delete the line from the [mysqld] section  ::    # skip_grant_tables=1

–  Start your MySQL server                                   ::     /etc/init.d/mysqld start

In case everything goes well – you will be able to Log-in your Plesk Control Panel.

Leave a comment