MYSQL_審計日志查看

發布時間：2020-08-10 19:44:33 來源：ITPUB博客閱讀：368 作者：adamjunior 欄目：MySQL數據庫

1.下載插件libaudit_plugin.so

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

2. 安裝插件

MYSQL_審計日志查看

# 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

MYSQL_審計日志查看

修改/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

MYSQL_審計日志查看

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;

向AI問一下細節

猜你喜歡