从8.0.4开始mysql废弃了用了很久的 validate_password插件，改用 validate_password组件。 我的版本是：
mysql> select version(); +-----------+ | version() | +-----------+ | 8.0.14 | +-----------+ 1 row in set (0.00 sec)
来查一下密码策略参数的情况:
mysql> SHOW VARIABLES LIKE 'validate_password.%'; Empty set (0.00 sec)
是因为validate_password组件没有安装，下面开始安装：
mysql> INSTALL COMPONENT 'file://component_validate_password'; Query OK, 0 rows affected (0.00 sec)
再次查看就有了
mysql> SHOW VARIABLES LIKE 'validate_password%'; +--------------------------------------+--------+ | Variable_name | Value | +--------------------------------------+--------+ | 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 | +--------------------------------------+--------+ 7 rows in set (0.00 sec)
还有一个变化是，以前是，参数以前是下划线，现在是.修改的时候要注意
mysql> set global validate_password.policy=low; Query OK, 0 rows affected (0.00 sec) mysql> mysql> mysql> SHOW VARIABLES LIKE 'validate_password%'; +--------------------------------------+-------+ | Variable_name | Value | +--------------------------------------+-------+ | 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 | LOW | | validate_password.special_char_count | 1 | +--------------------------------------+-------+ 7 rows in set (0.00 sec)
