Wednesday, September 7, 2011

Plesk password issue.


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

0: common_func.php3:108
        psaerror(string 'Unable to connect to database: saved admin password is
incorrect.')
1: auth.php3:93

In order to fix such issue we need to put the right password into Plesk”s
database.

1. First access your server via SSH and switch to ”root”.

Stop the MySQL daemon. Under Linux systems this can be done with the
following command:

/etc/init.d/mysqld stop

# on Red Hat like Linux operating systems you can either use

# 'services' to stop the deamon

service mysqld stop

2. Now start it with no user information:

/usr/bin/safe_mysqld –skip-grant-tables &

Now you should be able to access the database without the root password.

3. To log in type :

mysql -u root

4. Then you will see ”mysql>” prompt. While you are there type the following:

UPDATE mysql.user SET Password=PASSWORD('new_pwd') WHERE User='admin';

Type the new password instead new_pwd. Keep the letters case and do not
forget to put ”;” at the end to finish the command line.

5. Once you are done you will need to flush the privileges:

FLUSH PRIVILEGES;

6. Quit ”mysql>” with exit command and restart the Plesk control panel.

7. Via SSH you can do that as typing:

service psa restart

No comments:

Post a Comment