mysql 报错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;

posted @ 2018-07-17 09:58  莫失莫忘csbh  阅读(2372)  评论(1编辑  收藏  举报