mysql5.7安裝審計插件libaudit_plugin.so

1.下載下傳插件:

https://bintray.com/mcafee/mysql-audit-plugin/release/1.1.7-805#files

2.解壓插件複制到mysql lib庫插件目錄下：

unzip audit-plugin-mysql-5.7-1.1.7-805-linux-x86_64.zip

cd audit-plugin-mysql-5.7-1.1.7-805/lib

3.資料庫中檢視mysql的插件目錄:

SHOW GLOBAL VARIABLES LIKE 'plugin_dir'

4.拷貝libaudit_plugin.so到mysql插件目錄:

cp libaudit_plugin.so /usr/lib64/mysql/plugin/

5.mysql指令行安裝libaudit_plugin.so：

install plugin audit soname 'libaudit_plugin.so';

6.開啟設計功能

set global audit_json_file=1;

7.在mysql主目錄下會生成審計日志檔案：

mysql-audit.json