Windows MySQL 报错

1. 首次更改密码报错解决 ERROR 1820 (HY000)

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

问题解决

• 修改密码
  ALTER USER 'username'@'host' IDENTIFIED BY 'new_password';
• 刷新权限
  flush privileges;

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '12345678';
Query OK, 0 rows affected (0.03 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)