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

原创 2016年08月31日 00:01:49
mysql> alter  user 'root'@'localhost' identified by '111111';


输入以上语句,会提示:

ERROR 1819 (HY000): Your password does not satisfy the current policy requirement.


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

mysql> alter  user 'root'@'localhost' identified by '#20as3SElksds0ew98';

Query OK, 0 rows affected (0.00 sec)


mysql> flush privileges;

做完以上操作就修改密码成功了,然后就不会再提示错误了。

版权声明:本文为博主原创文章,未经博主允许不得转载。

相关文章推荐

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

搭建slave 库, 主库执行: mysql> grant replication slave on *.* to repl@"192.168.40.132" identified by 'roo...

Banner程序

<script type="text/javascript"

CentOS7.2安装MySQL5.7及遇到的坑

1、找到相关 Yum Repo,参考: http://dev.mysql.com/downloads/repo/yum/ 其它版本可以参考:http://repo.mysql.com/ 本文主要讲...
  • qsw412
  • qsw412
  • 2016-06-27 10:29
  • 2495

MySql5.7 ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

在mysql配置文件my.ini的mysqld下面添加一句default_password_lifetime=0重启mysql服务就行了。下面是截取了mysql官方文档关于密码过期策略的介绍。 ...

解决ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

今天在MySql5.6操作时报错:You must SET PASSWORD before executing this statement解决方法,需要的朋友可以参考下 ERROR 1820 (H...
  • july_2
  • july_2
  • 2014-12-12 16:53
  • 8866

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

昨天登录mysql(Server version: 5.7.11) 还是很好的,今天登录后执行任何命令都报下面的错误 mysql> help contents ERROR 1820 (HY000):...

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

昨天登录mysql(Server version: 5.7.11) 还是很好的,今天登录后执行任何命令都报下面的错误 mysql> help contents ERROR 1820 (HY000):...

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...

yum 安装mysql5.7 是 出现无法登陆问题以及mysql error You must reset your password using ALTER USER statement befor

centos7 mysql5.7.17 error You must reset your password using ALTER USER statement before executing t...

【mysql】You must reset your password using ALTER USER statement before executing this statement.

故障现场:登陆到MySQL服务器,不管你执行什么命令都报这个错 mysql> show databases; ERROR 1820 (HY000): You must reset your pass...
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:深度学习:神经网络中的前向传播和反向传播算法推导
举报原因:
原因补充:

(最多只允许输入30个字)