ERROR 1820 (HY000): Unknown error 1820

created at 11-17-2021 views: 4

problem description

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

After changing the password and restarting, prompt this:

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

You need to execute this command to change the password to take effect.

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)
created at:11-17-2021
edited at: 11-17-2021: