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.