MySQL 5.7 密码安全策略简介

左手的ㄟ右手 2024-04-17 23:51 92阅读 0赞

**查看现有的密码策略**

**validate\_password\_number\_count参数是密码中至少含有的数字个数，当密码策略是MEDIUM或以上时生效。**  
  
**validate\_password\_special\_char\_count参数是密码中非英文数字等特殊字符的个数，当密码策略是MEDIUM或以上时生效。**  
  
**validate\_password\_mixed\_case\_count参数是密码中英文字符大小写的个数，当密码策略是MEDIUM或以上时生效。**  
  
**validate\_password\_length参数是密码的长度，这个参数由下面的公式生成**  
  
**validate\_password\_number\_count+ validate\_password\_special\_char\_count+ (2 \* validate\_password\_mixed\_case\_count)**  
  
**validate\_password\_dictionary\_file参数是指定密码验证的字典文件路径。**  
  
**validate\_password\_policy这个参数可以设为0、1、2，分别代表从低到高的密码强度，此参数的默认值为1，如果想将密码强度改若，则更改此参数为0。**  
  
**创建用户时报错：**  
  
mysql> CREATE USER 'test'@'localhost' IDENTIFIED BY 'test';  
**ERROR 1819 (HY000): Your password does not satisfy the current policy requirements**  
  
**报错原因：**  
指定的密码没有符合现有的密码策略。  
  
**解决方法：**  
可以按照现有策略设置密码，也可以更改密码策略。

**① 按照现有密码策略指定密码**  
  
mysql>  CREATE USER 'test'@'localhost' IDENTIFIED BY 'System\#2016';  
Query OK, 0 rows affected (0.16 sec)  
  
**② 更改密码策略，降低密码的验证标准**  
  
\--更改密码策略为LOW  
mysql> set global validate\_password\_policy=0;  
Query OK, 0 rows affected (0.00 sec)  
  
\--更改密码长度  
mysql> set global validate\_password\_length=0;  
Query OK, 0 rows affected (0.00 sec)  
  
\--密码最小长度为4  
mysql> SHOW VARIABLES LIKE 'validate\_password%';  
\+--------------------------------------+-------+  
| Variable\_name                        | Value |  
\+--------------------------------------+-------+  
| validate\_password\_dictionary\_file    |       |  
| validate\_password\_length             | 4     |  
| validate\_password\_mixed\_case\_count   | 1     |  
| validate\_password\_number\_count       | 1     |  
| validate\_password\_policy             | LOW   |  
| validate\_password\_special\_char\_count | 1     |  
\+--------------------------------------+-------+  
6 rows in set (0.00 sec)  
  
mysql> drop user 'test'@localhost;  
Query OK, 0 rows affected (0.07 sec)  
  
\--创建长度为3的密码报错  
mysql> CREATE USER 'test'@'localhost' IDENTIFIED BY 'tes';  
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements  
  
\--创建长度为4的密码，4为现有密码策略的最小长度  
mysql> CREATE USER 'test'@'localhost' IDENTIFIED BY 'test';  
Query OK, 0 rows affected (0.01 sec)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26506993/viewspace-2062622/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26506993/viewspace-2062622/