前言
mysql ERROR 1820(HY000)问题的处理
一、错误的全部提示信息
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
密码过期,需要修改密码
二、处理步骤
1.修改密码
ALTER USER 'username'@'localhost' IDENTIFIED BY 'new_password';
以root为例,修改root@%和root@localhost的密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
ALTER USER 'root'@'%' IDENTIFIED BY '123456';
总结
按照提示修改密码即可。