一、下载插件:
https://bintray.com/mcafee/mysql-audit-plugin/release/1.1.7-805#files
二、解压插件复制到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
三、数据库中查看...mysql的插件目录:
SHOW GLOBAL VARIABLES LIKE 'plugin_dir'
四、拷贝libaudit_plugin.so到mysql插件目录:
cp libaudit_plugin.so.../usr/local/mysql/lib/plugin/
chmod +x libaudit_plugin.so
chown mysql:mysql libaudit_plugin.so
五、mysql.../mysql_audit.json #日志路径
audit_offsets=7824, 7872, 3632, 4792, 456, 360, 0, 32, 64, 160, 536, 7988, 4360