1.密码复杂度以及密码长度的加固
1、首先使用root账号登录数据库查看,若结果为空,则就需要安装插件。
mysql>SELECT * from mysql.`plugin`;
2、查看插件所在目录
mysql> show variables like '%plugin_dir%';
+---------------+--------------------------------------------+
| Variable_name | Value |
+---------------+--------------------------------------------+
| plugin_dir | /usr/local/mysql/lib/plugin/ |
+---------------+--------------------------------------------+
1 row in set, 1 warning (0.01 sec)
3、安装插件并验证是否安装成功
mysql>INSTALL PLUGIN validate_password SONAME 'validate_password.so';
mysql> show plugins;
+---------------------------------+----------+--------------------+-----------------------+---------+
| Name | Status | Type | Library | License |
+---------------------------------+----------+--------------------+-----------------------+---------+
| binlog | ACTIVE | STORAGE ENGINE | NULL | GPL |
| mysql_native_password | ACTIVE | AUTHENTICATION | NULL | GPL |
| sha256_password | ACTIVE | AUTHENTICATION | NULL | GPL |
| caching_sha2_password | ACTIVE | AUTHENTICATION