You must reset your password using ALTER USER statement before executin

MySQL版本：5.7.18

不管怎么输入，总是有后面这个报错

root 20:33 [(none)]> use mysql;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

既然说要用alter user，那就试试

1、 修改用户密码
mysql> alter user 'root'@'localhost' identified by 'mysql123'; 【或者       mysql> set password=password("mysql123");】

刷新一下
mysql> flush privileges;

结果如下：

root 20:40 [(none)]> alter user 'root'@'localhost' identified by 'mysql123';
Query OK, 0 rows affected (0.01 sec)

root 20:41 [(none)]> flush privileges;
Query OK, 0 rows affected (0.00 sec)

root 20:41 [(none)]> show databases
    -> ;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.03 sec)
问题解决