Shulou(Shulou.com)06/01 Report--

Mysql 5.7.12

Mariadb 10.1.14

Https://mariadb.com/kb/en/mariadb/server_audit-system-variables/

INSTALL PLUGIN server_audit SONAME 'server_audit.so'

# important parameters

Server_audit_incl_users=''

Server_audit_excl_users=''

Server_audit_events='QUERY,QUERY_DDL,QUERY_DML,QUERY_DCL,CONNECT'

# other parameters

Server_audit_file_rotate_size=10000000

# enable

Set global server_audit_logging=1

# switch log path

Set global server_audit_logging=0, server_audit_file_path='new path'

Set global server_audit_logging=1

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.