mysql 报错ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executin

今天在窗口使用命令执行操作时，总是这个报错，一开始感觉莫名其妙

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

后来了解查询之后才找到解决办法

解决办法

1、 修改用户密码mysql> alter user 'root'@'localhost' identified by 'youpassword'; 或者 mysql> set password=password("youpassword");2、刷新权限mysql> flush privileges;

问题就解决了！！！