[MYSQL] ACTIVATE SERVER AUDIT - fourslickz/notes GitHub Wiki

create logging directory

mkdir -p /var/log/mysql
chown mysql:mysql /var/log/mysql
chmod 750 /var/log/mysql

mysql -u root -p

SET GLOBAL server_audit_logging=OFF;
SET GLOBAL server_audit_events='CONNECT,QUERY_DDL,QUERY_DCL,QUERY_DML';
SET GLOBAL server_audit_query_log_limit=4096;
SET GLOBAL server_audit_file_path='/var/log/mysql/server_audit.log';
SET GLOBAL server_audit_file_rotate_size=100000000;
SET GLOBAL server_audit_file_rotations=30;

nano /etc/my.cnf.d/server.cnf

plugin_load_add = server_audit

server_audit_logging = ON
server_audit_events = CONNECT,QUERY_DDL,QUERY_DCL,QUERY_DML
server_audit_query_log_limit = 4096

server_audit_file_path = /var/log/mysql/server_audit.log
server_audit_file_rotate_size = 100000000
server_audit_file_rotations = 30