MySQL连接报错：ERROR 1820 (HY000): You must reset your password using ALTER USER...

如果在连接MySQL报错以下：

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

说明你必须要重设你的用户密码，解决方法：

执行以下命令： alter user 'root'@'localhost' identified by 'youpassword'; 例如：alter user 'root'@'localhost' identified by '123456';

或者执行下面的命令： set password="yourpassword"; 例如：set password="123456";

刷新 flush privileges;