show global variables like 'plugin_dir';
在 [mysqld] 部分的 MySQL 选项文件 (my.cnf) 中添加以下选项:
plugin-load=AUDIT=libaudit_plugin.so
您需要发出以下 sql 命令来安装插件:
INSTALL PLUGIN AUDIT SONAME 'libaudit_plugin.so';
运行sh脚本 获取偏移量 写入my.cnf
audit_offsets=7832, 7880, 3640, 4800, 456, 360, 0, 32, 64, 160, 544, 7996, 4368, 3648, 3656, 3660, 6080, 2072, 8, 7064, 7104, 7088, 13480, 148, 672, 0
只能生成json文件在data目录。
{"msg-type":"activity","date":"1654162742062","thread-id":"15","query-id":"648101","user":"zzs","priv_user":"zzs","ip":"192.168.203.244","host":"192.168.203.244","_os":"Windows","_client_name":"libmariadb","_pid":"12228","_thread":"8612","_platform":"AMD64","_client_version":"2.0.0","status":"0","cmd":"set_option","query":"set global audit_json_file=1"}