現(xiàn)象：設(shè)置簡單密碼會報(bào)錯(cuò)：

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

原因：

原來MySQL5.6.6版本之后增加了密碼強(qiáng)度驗(yàn)證插件validate_password，相關(guān)參數(shù)設(shè)置的較為嚴(yán)格。使用了該插件會檢查設(shè)置的密碼是否符合當(dāng)前設(shè)置的強(qiáng)度規(guī)則，若不滿足則拒絕設(shè)置。影響的語句和函數(shù)有：create user,grant,set password,password(),old password。

解決：

該問題其實(shí)與mysql的validate_password_policy的值有關(guān)，查看一下msyql密碼相關(guān)的幾個(gè)全局參數(shù)：

**[sql]** [view plain](http://blog.csdn.net/youshounianhua123/article/details/79606581# "view plain")[copy](http://blog.csdn.net/youshounianhua123/article/details/79606581# "copy")

<embed id="ZeroClipboardMovie_1" src="https://csdnimg.cn/public/highlighter/ZeroClipboard.swf" loop="false" menu="false" quality="best" bgcolor="#ffffff" width="16" height="16" name="ZeroClipboardMovie_1" align="middle" allowscriptaccess="always" allowfullscreen="false" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" flashvars="id=1&amp;width=16&amp;height=16" wmode="transparent" style="animation-duration: 0.001s; animation-name: playerInserted; box-sizing: border-box;"> 

1.  mysql> select @@validate_password_policy;    
2.  +----------------------------+    
3.  | @@validate_password_policy |    
4.  +----------------------------+    
5.  | MEDIUM                     |    
6.  +----------------------------+    
7.  1 row in set (0.00 sec)    

10.  mysql> SHOW VARIABLES LIKE 'validate_password%';    
11.  +--------------------------------------+--------+    
12.  | Variable_name                        | Value  |    
13.  +--------------------------------------+--------+    
14.  | validate_password_dictionary_file    |        |    
15.  | validate_password_length             | 8      |    
16.  | validate_password_mixed_case_count   | 1      |    
17.  | validate_password_number_count       | 1      |    
18.  | validate_password_policy             | MEDIUM |    
19.  | validate_password_special_char_count | 1      |    
20.  +--------------------------------------+--------+    
21.  6 rows in set (0.08 sec)  

參數(shù)解釋

validate_password_dictionary_file
插件用于驗(yàn)證密碼強(qiáng)度的字典文件路徑。

validate_password_length
密碼最小長度，參數(shù)默認(rèn)為8，它有最小值的限制，最小值為：validate_password_number_count + validate_password_special_char_count + (2 * validate_password_mixed_case_count)

validate_password_mixed_case_count
密碼至少要包含的小寫字母個(gè)數(shù)和大寫字母個(gè)數(shù)。

validate_password_number_count
密碼至少要包含的數(shù)字個(gè)數(shù)。

validate_password_policy
密碼強(qiáng)度檢查等級，0/LOW、1/MEDIUM、2/STRONG。有以下取值：
<u style="box-sizing: border-box;">Policy Tests Performed </u>
0 or LOW Length
1 or MEDIUM Length; numeric, lowercase/uppercase, and special characters
2 or STRONG Length; numeric, lowercase/uppercase, and special characters; dictionary file
默認(rèn)是1，即MEDIUM，所以剛開始設(shè)置的密碼必須符合長度，且必須含有數(shù)字，小寫或大寫字母，特殊字符。

validate_password_special_char_count

密碼至少要包含的特殊字符數(shù)。

修改：

**[html]** [view plain](http://blog.csdn.net/youshounianhua123/article/details/79606581# "view plain")[copy](http://blog.csdn.net/youshounianhua123/article/details/79606581# "copy")

<embed id="ZeroClipboardMovie_2" src="https://csdnimg.cn/public/highlighter/ZeroClipboard.swf" loop="false" menu="false" quality="best" bgcolor="#ffffff" width="16" height="16" name="ZeroClipboardMovie_2" align="middle" allowscriptaccess="always" allowfullscreen="false" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" flashvars="id=2&amp;width=16&amp;height=16" wmode="transparent" style="animation-duration: 0.001s; animation-name: playerInserted; box-sizing: border-box;"> 

1.  mysql> set global validate_password_policy=0;    
2.  Query OK, 0 rows affected (0.05 sec)    

4.  mysql>     
5.  mysql>     
6.  mysql> set global validate_password_mixed_case_count=0;    
7.  Query OK, 0 rows affected (0.00 sec)    

9.  mysql> set global validate_password_number_count=3;    
10.  Query OK, 0 rows affected (0.00 sec)    

12.  mysql> set global validate_password_special_char_count=0;    
13.  Query OK, 0 rows affected (0.00 sec)    

15.  mysql> set global validate_password_length=3;    
16.  Query OK, 0 rows affected (0.00 sec)    

18.  mysql> SHOW VARIABLES LIKE 'validate_password%';    
19.  +--------------------------------------+-------+    
20.  | Variable_name                        | Value |    
21.  +--------------------------------------+-------+    
22.  | validate_password_dictionary_file    |       |    
23.  | validate_password_length             | 3     |    
24.  | validate_password_mixed_case_count   | 0     |    
25.  | validate_password_number_count       | 3     |    
26.  | validate_password_policy             | LOW   |    
27.  | validate_password_special_char_count | 0     |    
28.  +--------------------------------------+-------+    
29.  6 rows in set (0.00 sec)    

原文鏈接：http://blog.csdn.net/kuluzs/article/details/51924374