SLTechnology News&Howtos › Database ›

MYSQL_ audit log view

Shulou Source: shulou.com Published: 2022-06-01 05:59:29 10月31日 Update

1. Download Plugin libaudit_plugin.so

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

2. mounting insert

# 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

Modify/etc/my.conf

Add the following:

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. restart the database

# service mysqld stop

# service mysqld start

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

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

4. check plugin

mysql> show plugins;