Article ID: 112492, created on Oct 10, 2011, last review on Jul 26, 2016

  • Applies to:
  • Plesk for Linux/Unix

Symptoms

Unable to log in to Plesk. The following error is displayed instead of the login screen:

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

Cause

The password in the file /etc/psa/.psa.shadow, which is used to access the Plesk database, does not match your admin password.

OR

The "old-passwords=1" option is enabled in /etc/my.cnf (on Debian-like distributions the path is /etc/mysql/my.cnf).

Resolution

  1. Make sure that option old-passwords = 1 is disabled in the /etc/my.cnf file (on Debian-like distributions the path is /etc/mysql/my.cnf).

  2. Obtain the correct Plesk password:

    # cat /etc/psa/.psa.shadow
    $AES***
    
  3. Try connecting to the MySQL database and updating the admin password:

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin mysql
    mysql> UPDATE mysql.user SET Password=PASSWORD('$AES***') WHERE User='admin';
    

    Note: If you are unable to connect, enable skip-grant-tables in the /etc/my.cnf file (on Debian-like distributions the path is /etc/mysql/my.cnf), restart MySQL, then update the admin password:

    # cat /etc/my.cnf
    ...
    [mysqld]
    skip-grant-tables
    ...
    
    # /etc/init.d/mysqld restart
    # mysql -uadmin mysql
    mysql> UPDATE mysql.user SET Password=PASSWORD('$AES***') WHERE User='admin';
    

    Do not forget to remove skip-grant-tables after that and restart MySQL.

  4. Update the password for Plesk using the ch_admin_passwd utility:

    # /usr/local/psa/bin/admin --show-password
    password
    # export PSA_PASSWORD=password
    # /usr/local/psa/admin/bin/ch_admin_passwd
    

Search Words

[1045] Access denied for user 'admin'@'localhost' (using password: YES) (Abstract.php:144)

unable to togin to panel

mysql database

database

start /stop mysql

Unable to connect to database

ERROR: PleskFatalException

ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)

A System Error has occured Relogin and try again. Additionally you can enter problem description or steps to reproduce to submit this problem to developers

56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 29d1e90fd304f01e6420fbe60f66f838

Email subscription for changes to this article
Save as PDF