mysql审计日志 设置_配置Mysql审计

mysql-audit.json：Mysql审计日志

插件下载地址：

https://bintray.com/mcafee/mysql-audit-plugin/release/1.1.4-725#files

首先查看mysql的插件保存目录：

mysql> show global variables like 'plugin_dir';

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

| Variable_name | Value |

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

| plugin_dir | /usr/local/mysql/lib/plugin/ |

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

1 row in set (0.01 sec)

解压缩：

unzip audit-plugin-mysql-5.7-1.1.4-725-linux-x86_64.zip

把so文件复制到上面的目录下：

cp audit-plugin-mysql-5.7-1.1.4-725/lib/libaudit_plugin.so /usr/local/mysql/lib/plugin/

chmod +x /usr/local/mysql/lib/plugin/libaudit_plugin.so

查看安装后的插件版本：

mysql> show global status like 'AUDIT_version';

+