首页 > 数据库 > MySQL > MySQL8.0变化之密码策略
从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)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20893244/viewspace-2565368/,如需转载,请注明出处,否则将追究法律责任。