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

[trensco]

Hello,

I did a "stupid" mistake and changed the mysql admin password via phpmyadmin and now I cant login anymore into plesk. If I try to login into plesk i get the following message:

ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: YES)

EDIT: At the third attempt this solutions finaly worked: Unable to access Plesk: Access denied for user 'admin'@'localhost' (using password: YES)

Edit 2: But it dont worked. If I my remove skip-grant-tables record from my.cnf I get teh same error if I want login into plesk ... hm :/

Edit 3: Ok, now I got it. This Solution:

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

worked. BUT there is a syntax error in step 10 for MySQL 5.7.6 and later.

Original:

mysql> UPDATE mysql.user SET authentication_string=PASSWORD('$AES-128-***) where User='admin';

Fixed:

mysql> UPDATE mysql.user SET authentication_string=PASSWORD('$AES-128-***') where User='admin';

There is a inverted comma missing beteween "***" and ")". For the most ppl its certainly not a big deal, cause they know mysql syntax well. But some ppl (inlcuding me) copy lines like this in the console and mysql wasn't throwing out a syntax error.

Greetings