Unable to access Plesk on Linux: Access denied for user 'admin'@'localhost' (using password: YES)




  • Avatar

    The commands like mysql -uadmin mysql still says  Access denied for user admin, even after adding skip-grant-tables to my.cnf

    All these commands that should reset password assume I am already logged in, when in fact that is my initial problem.


    These doc pages don't seem accurate at all.

  • Avatar
    Vitaly Zhidkov

    @adrianTNT, after modifying the my.cnf file and adding the skip-grant-tables option it is needed to restart the database server.

  • Avatar

    "11. If an output of the command is similar to the above - both strings Password and authentication_string are defined and the plugin is set as mysql_native_password for the admin user in the mysql.user table - run the query below. If not - move to the step 13."


    What is the step 13??


    Thanks !!

  • Avatar
    Ivan Postnikov

    @fabianevt, thank you for notice, It is required to move to step 12. The article was updated.

  • Avatar

    What is the step 12 or 13 ?

  • Avatar
    Ivan Postnikov

    Hello @WartraxX!

    Since previous comments regarding steps 12 and 13, the resolution was optimized and shortened.

    Now resolution consists only of 10 steps.

  • Avatar

    but once the automatic reset is done, what is my new password ???

  • Avatar
    Alexandr Redikultsev

    Hi @Domenico,

    The password is stored in /etc/psa/.psa.shadow file in the hashed form.

    You can copy the content and use it as a plain text password, MySQL will understand it.

Please sign in to leave a comment.

Have more questions? Submit a request