73.Mysql密码验证组件

Mysql在设置用户密码时有一个关于密码验证组件，该组件的功能就是提高用户设置密码时的安全性。

1.安装和卸载

mysql> INSTALL COMPONENT 'file://component_validate_password';
mysql> UNINSTALL COMPONENT 'file://component_validate_password';

2.查看

mysql> SHOW VARIABLES LIKE 'validate_password.%';
+-------------------------------------------------+--------+
| Variable_name                                   | Value  |
+-------------------------------------------------+--------+
| validate_password.changed_characters_percentage | 0      |
| validate_password.check_user_name               | ON     |
| 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      |   
+-------------------------------------------------+--------+

上面的各个参数可以参考下面的解释

https://dev.mysql.com/doc/refman/8.0/en/validate-password-options-variables.html