mysql用户口令复杂度_MySQL 配置密码复杂度

1.mysql 5.7.15版本好像默认启用了密码复杂度设置，插件名字叫做 validate_password，如果没有安装

mysql>>INSTALL PLUGIN validate_password SONAME 'validate_password.so';

2.在/etc/my.cnf加上配置,并重启mysql

[mysqld]

plugin-load=validate_password.so

validate_password_policy=0

validate-password=FORCE_PLUS_PERMANENT

3.登陆数据库查看

mysql> show variables like 'validate%';

+--------------------------------------+-------+

| Variable_name | Value |

+--------------------------------------+-------+

| 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 |

+--------------------------------------+-