【第22期】观点:IT 行业加班,到底有没有价值?

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.17-winx64的安装配置

第一步:下载mysql-5.7.17-winx64解压版本:http://dev.mysql.com/downloads/mysql/ 第二步:解压到安装目录,如:C:\myprogram\...

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

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

欢迎关注CSDN程序人生公众号

关注程序员生活,汇聚开发轶事。

解决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
  • 8254

mysql5.7免安装版报错处理You must reset your password using ALTER USER statement before executing

安装完mysql 之后,登陆以后,不管运行任何命令,总是提示这个 step 1: SET PASSWORD = PASSWORD(‘your new password‘); step 2:...

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

mysql安装过程中出现错误 ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

最近新装好的mysql在进入mysql工具时,总是有错误提示: # mysql -u root -p Enter password: ERROR 1045 (28000): Access den...

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

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

环境:ubuntu 16.04/mysql 5.7.16 今天使用mysql的时候出现了下面这种情况: mysql> show databases; ERROR 1820 (HY000): You m...

ERROR 1820 (HY000): You must reset your password using ALTER USER statement befo re executing this s

mysql> update mysql.user set password=PASSWORD('123456') where User='root'; ERROR 1820 (HY000): You...
收藏助手
不良信息举报
您举报文章:深度学习:神经网络中的前向传播和反向传播算法推导
举报原因:
原因补充:

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