Mysql5.7错误：ERROR 1820 (HY000): You must reset your password using ALTER USER statement before execut...

为什么80%的码农都做不了架构师？>>>   

 

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