ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
来源:互联网 发布:淘宝otc货到付款可信吗 编辑:程序博客网 时间:2024/05/29 14:30
如果出现以上症状,恭喜你,密码强度不够。
mysql5.7 默认赠送密码强度校验的插件
解决方法有二:
- 换个超级无敌吊炸天的复杂密码
- 修改数据库安全配置
第一个就不用说了吧。
第二种方法这样搞:
他有几个可爱的选项
validate_password_dictionary_file
:插件用于验证密码强度的字典文件路径。validate_password_length
:密码最小长度。validate_password_mixed_case_count
:密码至少要包含的小写字母个数和大写字母个数。validate_password_number_count
:密码至少要包含的数字个数。validate_password_special_char_count
:密码至少要包含的特殊字符数。validate_password_policy
:密码强度检查等级,0/LOW
、1/MEDIUM
、2/STRONG
。0/LOW
:只检查长度。1/MEDIUM
:检查长度、数字、大小写、特殊字符。2/STRONG
:检查长度、数字、大小写、特殊字符字典文件。
聪明的同学已经想到了歪门邪道了
- 首先修改
validate_password_policy
为0,让他只检查数字。然后你会发现8位数以下貌似还是不行,莫慌,不然怎么写其次。 - 其次修改
validate_password_length
为你有多短就写多短(邪恶的笑),默认应该是8
- 首先修改
- 命令在这:
set global validate_password_policy=0;set global validate_password_length=1;
这就差不多了,走你。
赠送官方文档:https://dev.mysql.com/doc/refman/5.7/en/validate-password-plugin.html
阅读全文
0 0
- ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- Mysql 异常ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- Mysql 5.7 遇到ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- ERROR 1819 (HY000): Your password does NOT satisfy the CURRENT policy requirements。
- mysql5.7修改密码ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- linux mysql 报错 ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- mysql5.7设置简单密码报错ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- mysql5.7设置密码安全级别 ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- mysql提示密码不符合要求:ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- Your password does not satisfy the current policy requirements
- Python 字符串操作方法大全
- 阿里云服务器ces
- Spring Boot 快速上手(六)集成MongoDB
- 30 个常用 Maven 命令
- JZOJ 5444. 【NOIP2017提高A组冲刺11.2】救赎
- ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- 用php获取本周,上周,本月,上月,本季度日期的代码
- 有一种策略...
- Java基础总结篇--JavaSE你必须要知道的基础
- Monkey自动化测试
- freemarker 循环list 并取值
- Android 6.0 的权限管理自己简单的封装--(到BaseActivity)
- 开发工具介绍
- TCP三次握手四次挥手状态转移