Articles in this section

See more

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

Avatar
Alexey Lapshin
Updated
Follow

Applicable to:

  • Plesk for Windows

Symptoms

After upgrading Plesk on Windows or after changing the admin password, the following error is shown instead of the Plesk login page:

CONFIG_TEXT: Access denied for user 'admin'@'localhost' (using password: YES)

Cause

An incorrect password is set for the user admin in the MySQL database.

Resolution

  1. Connect to the server via RDP

  2. Add the skip-grant-tables option in [PleskSQLServer] section of the file %plesk_dir%MySQL\my.ini:

    CONFIG_TEXT: . . .
    [PleskSQLServer]
    skip-grant-tables
    . . .

  3. Open cmd.exe as Administrator and restart the Plesk SQL Server service:

    C:\> net stop PleskSQLServer && net start PleskSQLServer

  4. Then change the admin password:

    C:\> plesk db "update mysql.user set authentication_string=password('new_password') where user='admin'"

  5. Remove the skip-grant-tables from %plesk_dir%MySQL\my.iniand restart the service again (repeat step #3).

Comments

1 comment

Sort by Date Votes
  • Avatar
    Jacobo Cano

    Thank you very much Pavel, it's works for me! Very good!

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles