ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

简介: ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

这种情况就是把密码设置的复杂一些:比如生成个18位的大小写了特殊字符就可以了。

另一种就是这个修改安全等级

之前在CentOS安装完MySQL修改默认密码时出现了如下错误:

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
  • 1

原因是因为密码设置的过于简单会报错,MySQL有密码设置的规范,具体是与validate_password_policy的值有关,下图表明该值规则

如果想要查看MySQL完整的初始密码规则,登陆后执行以下命令

SHOW VARIABLES LIKE 'validate_password%';
  • 1

密码的长度是由validate_password_length决定的,但是可以通过以下命令修改

set global validate_password_length=4;
  • 1

validate_password_policy决定密码的验证策略,默认等级为MEDIUM(中等),可通过以下命令修改为LOW(低)

set global validate_password_policy=0;
相关文章
|
6月前
|
关系型数据库 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
46 0
|
7月前
|
安全 关系型数据库 MySQL
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements问题处理
【5月更文挑战第8天】ERROR 1819 (HY000): Your password does not satisfy the current policy requirements问题处理
838 2
|
7月前
|
关系型数据库 MySQL 数据库
mysql Your password does not satisfy the current policy requirements
mysql Your password does not satisfy the current policy requirements
158 13
|
Linux
WARNING: Re-reading the partition table failed with error 22: Invalid argument
在划分磁盘分区时,遇到错误“WARNING: Re-reading the partition table failed with error 22: Invalid argument” 如下所示: [root@DB-Server u02]# fdisk -l   Disk /dev/sda: 500.
2547 0
|
关系型数据库 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
164 0
|
关系型数据库 MySQL 数据安全/隐私保护
MySQL: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
155 0
|
关系型数据库 MySQL 数据库
Your password has expired. To log in you must change it using a client that supports expired passwod
Your password has expired. To log in you must change it using a client that supports expired passwod错误解决
Your password has expired. To log in you must change it using a client that supports expired passwod
|
关系型数据库 MySQL 数据安全/隐私保护

热门文章

最新文章