Plesk shows the error: Access denied for user 'admin'@'localhost' (using password: YES)

Follow

Comments

4 comments

  • Avatar
    Jacobo Cano

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

    0
    Comment actions Permalink
  • Avatar
    Maxime Perraud

    By adding

    skip-grant-tables

    It became impossible to install server agent (plesk360)

    General error: 1290 The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement, query was: CREATE USER `monitoring`@`localhost

    0
    Comment actions Permalink
  • Avatar
    Kuzma Ivanov

    Hello Maxime Perraud

    Adding "skip-grant-tables" to my.ini file is a part of the solution and has to be removed when you reset the "admin" password.

    It is strongly not recommended to keep "skip-grant-tables" in MySQL configuration on a production server.

     
     

     

     

    0
    Comment actions Permalink
  • Avatar
    Dalhatu Ahmed

    Hello. Kuzma Ivanov,

    I get the following error message in step 8 when I try to update the admin password:

    C:\>plesk db "update mysql.user set authentication_string=password('new_password') where user='admin'"
    ERROR 1348 (HY000) at line 1: Column 'authentication_string' is not updatable

    I copied the error message and search for a solution but I couldn't get it. 

    Kindly help me. Thanks.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request