【MySQL 5.7】安装validate_password插件
xixuefeng
MySQL, MySQL-Install
2022-08-26 9:06:33
804 次浏览
【MySQL 5.7】安装validate_password插件已关闭评论
1：确认MySQL是否安装了插件
|
1 2 3 4 |
mysql> show variables like 'validate%'; Empty set (0.00 sec) mysql> |
2：查看插件所在路径
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
mysql> show global variables like 'plugin_dir'; +---------------+------------------------------+ | Variable_name | Value | +---------------+------------------------------+ | plugin_dir | /usr/local/mysql/lib/plugin/ | +---------------+------------------------------+ 1 row in set (0.01 sec) mysql> ##操作系统上确认插件 [root@mss ~]# cd /usr/local/mysql/lib/plugin/ [root@mss plugin]# ls |grep validate_password validate_password.so [root@mss plugin]# |
3：安装插件
|
1 2 3 4 |
mysql> install plugin validate_password soname 'validate_password.so'; Query OK, 0 rows affected (0.05 sec) mysql> |
4：确认
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
mysql> show variables like 'validate%'; +--------------------------------------+--------+ | Variable_name | Value | +--------------------------------------+--------+ | validate_password_check_user_name | OFF | | 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> |