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

原因是需要修改密码

重新修改密码即可：

1、用root用户登录

2、修改密码命令

update mysql.user set authentication_string=password(‘the_password’) where user=’root’;

set password=password(‘the_password’);