By accident I locked my root account in MySQL which I launch using wamp server, the error message from phpMyAdmin is
Access denied for user 'root'@'localhost'. Account is locked.
How can I unlock this account, all I could find online was assuming that I have another unlocked account. Thanks in advance.
Using the method from docs.
Create an C:\\init.sql file containing
ALTER USER 'root'@'localhost' ACCOUNT UNLOCK
In the my.ini file
[mysqld]
init-file=C:\\init.sql
Restart the service, check you can access the root user, and then remove init.sql file and backout my.ini change.
per ALTER USER docs
