Error: PleskFatalException Unable to connect to database: saved admin password is incorrect.
Do you have this error? "PleskFatalException Unable to connect to database: saved admin password is incorrect." Worry not, because we have the solution for that.
If you've just upgraded Plesk/PHP on your server, you may get this issue. Use Secure Shell to log in as the server's "root" user.
Stop the MySQL daemon
[root@server /]# /etc/init.d/mysqld stop
Now start it with no user information:
[root@server /]# mysqld_safe –skip-grant-tables &
Now you should be able to access the database without the root password. To log in type
[root@server /]# mysql -u root
Then you will see the mysql prompt
mysql> UPDATE mysql.user SET Password=PASSWORD(‘xxxxx’) WHERE User=’admin’;
Type the new password instead xxxxx.
mysql> FLUSH PRIVILEGES;
then Quit ”mysql>” with exit command and restart the Plesk control panel.
[root@server /]# /etc/init.d/psa restart
What's Your Reaction?
