如果在连接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;