Mysql8数据库安全加固（等保）

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