MySQL启用弱口令

MySQL启动弱口令

有的时候，有点懒，测试环境就想数据库密码简单点，不用什么大小写，特殊字符各种组合

root用户登录
mysql -uroot -p

查看密码策略：

SHOW VARIABLES LIKE 'validate_password%';

输出：

mysql> show variables like "validate_password%";
+--------------------------------------+--------+
| Variable_name                        | Value  |
+--------------------------------------+--------+
| validate_password_check_user_name    | OFF    |
| validate_password_dictionary_file    |        |
| validate_password_length             | 8      |
| validate_password_mixed_case_count   | 1      |
| validate_password_number_count       | 1      |
| validate_password_policy             | MEDIUM |
| validate_password_special_char_count | 1      |
+--------------------------------------+--------+
7 rows in set (0.00 sec)

主要修改两个即可：

set global validate_password_policy=0;

值含义：

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

另一个：

set global validate_password_length=6;

这个值有最小值限制：validate_password_number_count + validate_password_special_char_count + (2 * validate_password_mixed_case_count)
所以默认的validate_password_length最小值是4