Monday, May 16, 2016

Error from mySQL: ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement

I got this error when I was trying to use the mySQL command line. I can't even show my databases, because I was asked to reset my password.

I got this error earlier when I was connecting to mySQL using Visual Studio, and I did reset my password. I do not know why I got this again when I am using mySQL command line. I just searched for how to reset password, and it works fine again.

This is how to reset password in mySQL:

ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
Reference: MySQL Reference Manual - How to reset root password?

No comments:

Post a Comment