ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

从MySql5.6.6起可以强制用户修改密码。

 

Session1:先使密码过期
mysql>ALTER USER 'test'@'127.0.0.1' PASSWORD EXPIRE;

 

Session2:可以继续操作，这个操作不会影响已建立的连接

mysql> select 1 \G
*************************** 1. row ***************************
1: 1
1 row in set (0.01 sec)

 

Session3:会影响新的连接
mysql -utest -p
Enter password: ******

mysql> show variables like'port'\G;
ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

当出现ERROR 1820 (HY000)这个错误后，用SET PASSWORD 修改当前用户的密码就可以了。

mysql> SET PASSWORD = PASSWORD('123456');
Query OK, 0 rows affected (0.04 sec)

mysql> select 1 \G
*************************** 1. row ***************************
1: 1
1 row in set (0.01 sec)