当前位置:Gxlcms > 数据库问题 > mysql 报错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

时间:2021-07-01 10:21:17 帮助过:5人阅读

解决办法

1、 修改用户密码

mysql> alter user ‘root‘@‘localhost‘ identified by ‘youpassword‘;

或者

mysql> set password=password("youpassword");

2、刷新权限

mysql> flush privileges;

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

标签:密码   localhost   修改   mysq   exec   host   ror   刷新   ges   

人气教程排行