ERROR 1819 (HY000): Your password does not satisfy the current policy requiremen 【mysql】

向右看齐 2022-04-17 03:47 156阅读 0赞

### 报错信息,修改密码时可能出现如下的错误。 ###

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
    ERROR 1819 (HY000): Your password does not satisfy the current policy requiremen

### 这是由于mysql密码强度的设置规则导致的。 ###

*  查看mysql全局的密码相关的参数

**参数解释**

<table> 
 <thead> 
  <tr> 
   <th align="center">相关参数</th> 
   <th align="center">解释</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td align="center">validate_password_dictionary_file</td> 
   <td align="center">插件用于验证密码强度的字典文件路径。</td> 
  </tr> 
  <tr> 
   <td align="center">validate_password_length</td> 
   <td align="center">密码最小长度，参数默认为8，它有最小值的限制，最小值为：validate_password_number_count + validate_password_special_char_count + (2 * validate_password_mixed_case_count)</td> 
  </tr> 
  <tr> 
   <td align="center">validate_password_mixed_case_count</td> 
   <td align="center">密码至少要包含的小写字母个数和大写字母个数。</td> 
  </tr> 
  <tr> 
   <td align="center">validate_password_number_count</td> 
   <td align="center">密码至少要包含的数字个数。</td> 
  </tr> 
  <tr> 
   <td align="center">validate_password_policy</td> 
   <td align="center">密码强度检查等级，0/LOW、1/MEDIUM、2/STRONG。</td> 
  </tr> 
  <tr> 
   <td align="center">validate_password_special_char_count</td> 
   <td align="center">密码至少要包含的特殊字符数。</td> 
  </tr> 
 </tbody> 
</table>

**密码强度等级解释**：

<table> 
 <thead> 
  <tr> 
   <th align="center">密码强度</th> 
   <th align="center">解释</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td align="center">0 or LOW</td> 
   <td align="center">Length</td> 
  </tr> 
  <tr> 
   <td align="center">1 or MEDIUM</td> 
   <td align="center">Length; numeric, lowercase/uppercase, and special characters</td> 
  </tr> 
  <tr> 
   <td align="center">2 or STRONG</td> 
   <td align="center">Length; numeric, lowercase/uppercase, and special characters; dictionary file 默认是1，即MEDIUM，所以刚开始设置的密码必须符合长度，且必须含有数字，小写或大写字母，特殊字符</td> 
  </tr> 
 </tbody> 
</table>

### 修改mysql参数： ###

mysql> set global validate_password_policy=0;  
    Query OK, 0 rows affected (0.05 sec)  
      
    mysql>   
    mysql>   
    mysql> set global validate_password_mixed_case_count=0;  
    Query OK, 0 rows affected (0.00 sec)  
      
    mysql> set global validate_password_number_count=3;  
    Query OK, 0 rows affected (0.00 sec)  
      
    mysql> set global validate_password_special_char_count=0;  
    Query OK, 0 rows affected (0.00 sec)  
      
    mysql> set global validate_password_length=3;  
    Query OK, 0 rows affected (0.00 sec)  
      
    mysql> SHOW VARIABLES LIKE 'validate_password%';  
    +--------------------------------------+-------+  
    | Variable_name                        | Value |  
    +--------------------------------------+-------+  
    | validate_password_dictionary_file    |       |  
    | validate_password_length             | 3     |  
    | validate_password_mixed_case_count   | 0     |  
    | validate_password_number_count       | 3     |  
    | validate_password_policy             | LOW   |  
    | validate_password_special_char_count | 0     |  
    +--------------------------------------+-------+  
    6 rows in set (0.00 sec)

#### 修改密码 ####

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123');  
    Query OK, 0 rows affected, 1 warning (0.00 sec)

#### 参考博客 ####

[博客地址1][1]

[1]: https://blog.csdn.net/u014236541/article/details/78244601

ERROR 1819 (HY000): Your password does not satisfy the current policy requiremen 【mysql】

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

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

相关修改mysql密码出现的错误：Your password does not satisfy the current policy requirements

相关安装MySQL5.6新建用户并创建密码时总是提示密码不符合要求：ERROR 1819 (HY000): Your password does NOT satisfy the CURRENT ……

相关【mysql】设置密码报错ERROR 1819 (HY000)

相关 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 requiremen 【mysql】

相关 mysql赋予远程权限出现mysqlERROR 1819 (HY000): Your password does not satisfy the current policy requiremen

相关 Linux环境下修改密码报ERROR 1819 (HY000): Your password does not satisfy the current policy requirements