原因是需要修改密码
重新修改密码即可:
1、用root用户登录
2、修改密码命令
update mysql.user set authentication_string=password(‘the_password’) where user=’root’;
set password=password(‘the_password’);
mysql 报错:ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
原文:https://www.cnblogs.com/Sunshine-bing/p/15101320.html