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

在安装mysql5.7数据库，并初始化数据后进入mysql控制台执行查询命令时，报错提醒：

mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
mysql> exit
Bye

解决方法：

按提示操作，修改首次用户密码。用root首次密码登录mysql后，执行修改密码命令：

mysql> alter user user() identified by "xxxxx3121";
Query OK, 0 rows affected (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

mysql> 

修改密码为 xxxxx3121 ，修改后请记住密码哦。