MySQL服务器登陆故障ERROR 1820 (HY000)的解决方法

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.......

mysql> select version();+--------------+| version() |+--------------+| 5.7.10-3-log |+--------------+1 row in set (0.01 sec) mysql> show variables like 'default_password_lifetime';+---------------------------+-------+| Variable_name    | Value |+---------------------------+-------+| default_password_lifetime | 360  |+---------------------------+-------+1 row in set (0.00 sec)

alter user user() identified by "123456";