mysql数据库技巧

MySQL 5.7 关闭密码策略设置validate_password

错误:
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
查看密码策略,改过的:

mysql> show variables like '%valid%';
+--------------------------------------+-------+
| Variable_name                        | Value |
+--------------------------------------+-------+
| query_cache_wlock_invalidate         | OFF   |
| 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             | LOW   |
| validate_password_special_char_count | 1     |
+--------------------------------------+-------+
8 rows in set (0.00 sec)

如果不需要密码策略,在my.cnf文件中添加如下配置禁用即可:
validate_password = off
修改完后记得需要重新启动MySQL服务
validate_password相关参数说明:
validate_password_dictionary_file:密码策略文件,策略为STRONG才需要
validate_password_length:密码最少长度
validate_password_mixed_case_count:大小写字符长度,至少1个
validate_password_number_count :数字至少1个
validate_password_special_char_count:特殊字符至少1个上述参数是默认策略MEDIUM的密码检查规则。
validate_password_policy:密码策略,默认为MEDIUM策略,共有如下三种密码策略:

策略 检查规则
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

临时改:

  1. set global validate_password_policy=0;
  2. set global validate_password_length=1;

永久改,my.cnf里:

validate_password_policy=0 #0(LOW),1(MEDIUM),2(STRONG)