Mysql5.7错误:ERROR 1820 (HY000): You must reset your password using ALTER USER sta

论坛 期权论坛 脚本     
已经匿名di用户   2021-11-26 10:20   3346   0

mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

Ps:输入以上语句,会提示:
ERROR 1819 (HY000): Your password does not satisfy the current policy requirement.


设置密码:

mysql> alter  user 'root'@'localhost' identified by '#20as3SElksds0ew98';  
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements


MySQL5.7 加强了安全保障,以上意思是密码不符合安全策略要求,我们输入一个8位或以上长度,复杂一点的密码,比如:

mysql> alter  user 'root'@'localhost' identified by '#20as3SElksds0ew98';  
Query OK, 0 rows affected (0.00 sec)

转载于:https://my.oschina.net/AnnaWu/blog/1611710

分享到 :
0 人收藏
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

积分:81
帖子:4969
精华:0
期权论坛 期权论坛
发布
内容

下载期权论坛手机APP