How to fix: Mysql ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

The error means the logined user’s password was expired, you excute the sql to confirm:

 

To resolve the error , you can reset the password:

 

If you got error,  you also can drop the user and create it again.

Bookmark/Favorites

Leave a Reply

Your email address will not be published. Required fields are marked *