mysql的配置策略_MySQL-配置密码策略（validate_password）插件

1. 检查插件目录

mysql> show variables like 'plugin_dir';

2. 下载第三方开源插件文件并上传到步骤1目录上

3. 配置文件中添加对象参数配置

[mysqld]

plugin-load-add=validate_password.so

or

plugin-load=validate_password.so

# validate_password_policy=2validate-password=FORCE_PLUS_PERMANENT

4. 连接数据库并进行安装插件

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

5. 检查确认

SELECTPLUGIN_NAME,

PLUGIN_STATUS,

plugin_library,

load_optionFROMINFORMATION_SCHEMA.PLUGINSWHEREplugin_library= 'validate_password.so';

mysql> show plugins;

6. 根据需求配置密码策略

6.1 检查策略变量配置

mysql> SHOW VARIABLES LIKE 'validate_password%';+--------------------------------------+--------+

| Variable_name | Value |

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