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';
+