ERROR 1820 (HY000): Unknown error 1820

mysql> update user set authentication_string=password('mysql123') where user='root' ;
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

mysql> exit

修改完密码重启后，提示这个：

mysql> show databases ;
ERROR 1820 (HY000): Unknown error 1820
mysql> show databases;
ERROR 1820 (HY000): Unknown error 1820
mysql> select version();
ERROR 1820 (HY000): Unknown error 1820

需要执行这个命令重新修改一下密码生效。

mysql> SET PASSWORD = PASSWORD('mysql123') ;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> flush privilges ;
ERROR 1064 (42000):
mysql> flush privileges ;
Query OK, 0 rows affected (0.00 sec)