ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
来源:互联网 发布:js urldecode gbk 编辑:程序博客网 时间:2024/06/04 08:15
MySQL5.7在添加用户的时候提示错误:
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
mysql> create user 'abuser'@'localhost' identified by 'abuser';ERROR 1819 (HY000): Your password does not satisfy the current policy requirementsmysql>
这个问题怎么样解决呢?看提示已经很清楚了,就是我们设置的密码没有满足当前的要求机制。我们先查询一下有关的密码参数,使用命令如下:
mysql> SHOW VARIABLES LIKE 'validate_password%';
得到的结果如下表所示:
在这里,我们的mysql已经开启了中级密码验证,密码长度至少为8,包含大小写字母、数字和特殊字符。如果选用这种密码验证,那只要设置的密码包含以上所写的要求即可。
ps:据说是可以修改my.cnf文件来跳过密码验证,可以查查有关的资料,我自己没有试过。
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
- Android RecyclerView 使用完全解析 体验艺术般的控件
- 结构体,联合的位域定义方法,以及结构体大小的计算
- c编程
- mac os x环境下使用git+hexo搭建博客:没想到你们是这样的npm和hexo
- 没有意义的阶段性目标
- ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- ShareSDK社会化分享之那些年我们踩过的坑
- 形象易懂的观察者模式
- java-list运用
- Visual Studio Code 使用 Typings 实现智能提示功能
- Codeforces Round #375 Text Document Analysis
- mybatis入门
- Html的基本知识
- 常用的Mysql数据库操作语句大全