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.


Leave a Reply

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