# Settings for Server Audit Plugin

plugin-load=server_audit=server_audit.so

server_audit_logging=ON

server_audit_output_type=SYSLOG

server_audit_events=CONNECT

server_audit_syslog_ident=mysql-server_auditing

mysql> show global variables like 'server_aud%';

+-------------------------------+-----------------------+

| Variable_name                 | Value                 |

+-------------------------------+-----------------------+

| server_audit_events           | CONNECT               |

| server_audit_excl_users       |                       |

| server_audit_file_path        | server_audit.log      |

| server_audit_file_rotate_now  | OFF                   |

| server_audit_file_rotate_size | 1000000               |

| server_audit_file_rotations   | 9                     |

| server_audit_incl_users       |                       |

| server_audit_logging          | ON                    |

| server_audit_mode             | 1                     |

| server_audit_output_type      | ?                     |

| server_audit_syslog_facility  | LOG_USER              |

| server_audit_syslog_ident     | mysql-server_auditing |

| server_audit_syslog_info      |                       |

| server_audit_syslog_priority  | LOG_INFO              |

+-------------------------------+-----------------------+

14 rows in set (0.00 sec)

set global server_audit_output_type=SYSLOG;