MySQL5.7 错误:ERROR 1820 (HY000): You must reset your password using ALTER USER statement before ...
来源:互联网 发布:淘宝限购在哪里设置 编辑:程序博客网 时间:2024/05/02 03:02
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;
做完以上操作就修改密码成功了,然后就不会再提示错误了。
0 0
- MySQL5.7 错误:ERROR 1820 (HY000): You must reset your password using ALTER USER statement before ...
- mysql 5.7 ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executi
- mysql ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing t
- 【MySQL】ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing
- ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this ..
- [mysql] ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing
- mysql5.7 You must reset your password using ALTER USER statement before executing this statement.
- mysql 报错ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executin
- mysql 报错ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing
- mysql中ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing t
- mysql error You must reset your password using ALTER USER statement before executing this statement.
- MySQL错误:You must reset your password using ALTER USER statement before executing this statement.
- mac mysql error You must reset your password using ALTER USER statement before executing this statem
- mac mysql error You must reset your password using ALTER USER statement before executing this statem
- 错误mac mysql error You must reset your password using ALTER USER statement before executing this stat
- mysql5.7免安装版报错处理You must reset your password using ALTER USER statement before executing
- ERROR 1820 (HY000): You must reset your password using ALTER USER statement befo re executing this s
- You must reset your password using ALTER USER statement before executing this statement.
- UVA - 10161 Ant on a Chessboard
- SpringMVC解析器
- UVA - 113 Power of Cryptography
- IntelliJ IDEA 常用设置讲解
- linux信号量
- MySQL5.7 错误:ERROR 1820 (HY000): You must reset your password using ALTER USER statement before ...
- 冒泡排序算法
- 冒泡排序
- java自带的log java.util.logging
- git origin/master
- Oracle:SQL语句--对表空间的操作——删除表空间
- 致雅嵌入式工作室——收到GPS模块的数据
- Android--MVP架构设计Listview
- 二叉树的遍历算法(递归和非递归)