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

墨蓝 2022-12-07 11:43 188阅读 0赞

报这个错的原因是从mysql5.7之后加强了密码规则。  
查看password的规则：

show VARIABLES like '%password_policy%'

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poZXpoZWJpZQ_size_16_color_FFFFFF_t_70_pic_center]  
本地测试，使用简单密码：

set global validate_password.policy=0

<table> 
 <thead> 
  <tr> 
   <th>Policy</th> 
   <th align="left">Tests Performed</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>0</td> 
   <td align="left">or LOW Length</td> 
  </tr> 
  <tr> 
   <td>1</td> 
   <td align="left">or MEDIUM Length; numeric, lowercase/uppercase, and special characters</td> 
  </tr> 
  <tr> 
   <td>2</td> 
   <td align="left">or STRONG Length; numeric, lowercase/uppercase, and special characters; dictionary file</td> 
  </tr> 
 </tbody> 
</table>

### 查看password的长度： ###

show VARIABLES like '%validate_password_length%'

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poZXpoZWJpZQ_size_16_color_FFFFFF_t_70_pic_center 1]

### 完整： ###

show VARIABLES like '%validate_password%'
    set global validate_password.policy=0;
    set global validate_password.length=3;
    create user 'supports_manager'@'%' identified WITH mysql_native_password by '13232';
    
    grant all privileges on *.* to supports_manager@'%';
    
    flush privileges;

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poZXpoZWJpZQ_size_16_color_FFFFFF_t_70_pic_center]: /images/20221123/438b12530c9d4b499f8f57cce497dc56.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poZXpoZWJpZQ_size_16_color_FFFFFF_t_70_pic_center 1]: /images/20221123/64b15f83d89740359c1015c4e7c04b57.png

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密码出现的错误：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