Mysql 密码报错 You must reset your password ... 和 Your password does N
来源:互联网 发布:旭日阳刚成名网络视频 编辑:程序博客网 时间:2024/06/03 19:38
原文地址 http://blog.sina.com.cn/s/blog_a0d71a9d0102wlz3.html
如果MySQL数据库用户的密码设置过于简单,数据库在用户登录后会提示重置密码,并且不接受简单的密码。
提示需要重置密码:
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
Mysql数据库版本:5.7.1
操作系统:CentOS 7
这个问题是否奇怪,因为明明是刚刚用密码登录了mysql服务器。怎么要重置密码呢?因为密码太简单了,不符合MySQL的安全要求。
参考官方的文档,见http://dev.mysql.com/doc/refman/5.6/en/alter-user.html。重置用户密码操作:
mysql> SET PASSWORD = PASSWORD(‘123456’); //123456 是重置的新密码
以上操作后又遇到新问题:
ERROR 1819 (HY000): Your password does NOT satisfy the CURRENT policy requirements。
又参考了官方文档,见http://dev.mysql.com/doc/refman/5.7/en/validate-password-plugin.html。
应该是密码过于简单了。 后来用大写字母+数字+特殊字符混合了一个密码。重置密码成功!
以后操作,没有再出现上述问题。
注意:如果只想设置简单密码需要修改两个全局参数:
mysql> set global validate_password_policy=0;
mysql> set global validate_password_length=1;
- Mysql 密码报错 You must reset your password ... 和 Your password does N
- Mysql报错: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
- you must reset your password using alter table
- 5.7 以后的MYSQL 登录数据库还是报错ERROR 1820 (HY000): You must reset your password using ALTER USER statement be
- mysql 5.7 ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executi
- mac mysql error You must reset your password using ALTER USER statement before executing this statem
- Mysql 5.7.15 You must reset your password using ALTER USER
- mac mysql error You must reset your password using ALTER USER statement before executing this statem
- 【mysql】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 executing t
- MySQL错误:You must reset your password using ALTER USER statement before executing this statement.
- mysql error 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 executing
- [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
- mysql中ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing t
- char数组转换为LPCTSTR乱码问题 某人的评论里得出的解决方法
- Windows线程同步——临界区对象
- Spring特征
- 请你谈谈Cookie的弊端
- POJ 3104(二分)
- Mysql 密码报错 You must reset your password ... 和 Your password does N
- C语言的strcpy()和strncpy()函数
- CSS 相关问题
- Python图表绘制:matplotlib绘图库入门
- html部分
- Java.lang.NoClassDefFoundError: javax/servlet/jsp/jstl/core/Config
- JQ楼层效果 需改良左右两边定位问题
- dva源码解析(一)
- 如何实现浏览器内多个标签页之间的通信?