MySQL数据库系统原理 课件 7. 用户和权限.pptx

7用户和权限管理安装validate_password插件 在线安装mysql INSTALL PLUGIN validate_password SONAME validate_password.so查看插件状态mysql select plugin_name,plugin_status,plugin_type,load_option,plugin_library - from information_schema.plugins - where plugin_name like validate%\G*************************** 1. row *************************** plugin_name: validate_password plugin_status: ACTIVE plugin_type: VALIDATE PASSWORD load_option: ONplugin_library: validate_password.so1 row in set (0.00 sec)在线卸载mysql UNINSTALL PLUGIN validate_password;查看插件目录mysql show variables like plugin_dir;密码策略相关参数mysql show variables like validate%;+--------------------------------------+--------+| 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 |+--------------------------------------+--------+查看密码策略指定参数mysql show variables like validate_password.policy;+--------------------------+--------+| Variable_name | Value |+--------------------------+--------+| validate_password.policy | MEDIUM |+--------------------------+--------+密码策略级别0 or LOW 只检查密码长度是否符合要求 1 or MEDIUM(默认)检查密码长度包括数字、大小写字母、特殊字符2 or STRONG检查密码长度包括数字、大小写字母、特殊字符不能出现在dictionary file(/usr/share/mysql-8.0/dictionary.txt ) Medium及strong级别的密码长度validate_password.length参数默认为8密码中各部分字符个数参数Validate_password.number_count： 数字个数Validate_password.special_char_count：特殊字符个数Validate_password.mixed_case_count： 大小写字母个数默认值均为1validate_password.length最小值为4数字个数 + 特殊字符个数 + 2*Validate_password.mixed_case_count若要设置validate_password.length4，可以先修改Validate_password.number_count，Validate_password.special_char_count，Validate_password.mixed_case_count为0修改密码策略参数修改密码策略级别为0mysql set global v