ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

MySQL 首次安装后，执行命令提示：

3306 [(none)]>show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

解决办法

#ALTER USER 'root'@'localhost' IDENTIFIED BY '123' PASSWORD EXPIRE NEVER;
#flush privileges;

3306 [(none)]>ALTER USER 'root'@'localhost' IDENTIFIED BY '123' PASSWORD EXPIRE NEVER;
Query OK, 0 rows affected (0.01 sec)

3306 [(none)]>flush privileges;
Query OK, 0 rows affected (0.00 sec)

3306 [(none)]>show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.01 sec)