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

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;

mysql> help contents



原文链接:https://www.jianshu.com/p/2b62015f8731

posted @ 2022-05-06 09:43  独苏  阅读(82)  评论(0编辑  收藏  举报