MYSQL_审计日志查看

1.下载插件libaudit_plugin.so

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

2. 安装插件

# unzip audit-plugin-percona-5.7-1.1.7-805-linux-x86_64.zip

# cd /u01/soft/audit-plugin-percona-5.7-1.1.7-805/lib

# cp libaudit_plugin.so /usr/local/mysql/lib/plugin/

# cd /usr/local/mysql/lib/plugin/

# chown mysql:mysql libaudit_plugin.so

# chmod 755 libaudit_plugin.so

# cd /u01/soft/audit-plugin-percona-5.7-1.1.7-805/utils

# ./offset-extract.sh /usr/local/mysql/bin/mysqld

修改/etc/my.conf

添加内容如下:

plugin-load=AUDIT=libaudit_plugin.so

audit_offsets=7824, 7872, 3632, 4792, 456, 360, 0, 32, 64, 160, 536, 7988, 4360, 3648, 3656, 3660, 6072, 2072, 8, 7056, 7096, 7080, 13464, 148, 672

3.重启数据库

# service mysqld stop

# service mysqld start

mysql> install plugin audit soname 'libaudit_plugin.so';

ERROR 1125 (HY000): Function 'audit' already exists

4. 检查插件

mysql> show plugins;

| AUDIT | ACTIVE | AUDIT | libaudit_plugin.so | GPL