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:

mysql>SELECT user,host,password,password_expired FROM mysql.user;

1	mysql>SELECT user,host,password,password_expired FROM mysql.user;

To resolve the error , you can reset the password:

mysql>SET PASSWORD=PASSWORD('your password');

1	mysql>SET PASSWORD=PASSWORD('your password');

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

1000 Tips