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 :: sudo service mysql stop
– Open your MySQL configuration file :: vi /etc/mysql/my.cnf
– Add one line into the [mysqld] section :: skip_grant_tables=1
– Start your MySQL server :: sudo service mysql 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 :: sudo service mysql stop
– Open your MySQL configuration file :: vi /etc/mysql/my.cnf
– Delete the line from the [mysqld] section :: # skip_grant_tables=1
– Start your MySQL server :: sudo service mysql start
Other tips…
RESET ADMIN PASSWORD::
show admin password :
/usr/local/psa/bin/admin --show-password
Reset admin password:
/usr/local/psa/bin//init_conf -u -passwd <new_password>