首页 > 其他分享 >ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this st

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

时间:2023-03-27 12:55:30浏览次数:40  
标签:reset set 1820 HY000 executing statement ERROR password

安装mysql8后,本地登录成功,选择数据库报错

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

 

解决办法: 

执行语句修改密码:set password='新密码';


如果密码符合Mysql要求,会修改成功。如果出现以下错误信息:
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
执行如下两条语句:
set global validate_password.policy=0;
set global validate_password.length=1;
然后再次执行 set password='新密码'; 即可。

标签:reset,set,1820,HY000,executing,statement,ERROR,password
From: https://www.cnblogs.com/leihongnu/p/17261173.html

相关文章