【mysql】You must reset your password using ALTER USER statement before executing this statement.

登录mysql服务器之后，执行什么命令，都报ERROR错误：

mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> use test;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
.

这个主要是由一个参数控制的 default_password_lifetime,

执行命令：

show variables like 'default_password_lifetime';

ENETR之后即显示：

mysql> show variables like 'default_password_lifetime';
+---------------------------+-------+
| Variable_name             | Value |
+---------------------------+-------+
| default_password_lifetime | 0     |
+---------------------------+-------+
1 row in set (0.00 sec)

所以，当默认密码的生命剩余时间为0时即出现这种问题；

解决方案：修改密码  eg:新密码为：123456

 

alter user user() identified by "123456";