mysqli::real_connect(): (HY000/3118): Access denied for user 'root'@'localhost'. Account is locked.

[Nikolay-Dimitrov-Dimitrov]

Good day

In phpMyAdmin I accidentally pressed on root lock button.
Please assist. I can't enter the database.

Thank you

[Daviddjire]

in yourCLI

mysql -u root -p

mysql> SELECT user, host, account_locked FROM mysql.user where user = 'root';

ALTER USER root@localhost ACCOUNT UNLOCK;

[Md123etplus]

This works for me, thx!

[amangat2002]

how can you please tell me i'm facing same difficulty

[moamahfouz]

I run the same command mysql -u root -p
And I got

ERROR 3118 (HY000): Access denied for user 'root'@'localhost'. Account is locked.