From the course: Advanced MySQL and MariaDB

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Using MariaDB audit logging

Using MariaDB audit logging

From the course: Advanced MySQL and MariaDB

Start my 1-month free trial

Using MariaDB audit logging

Once the MariaDB plugin is installed, there are a few configuration variables to consider. Logging is off by default, so the first configuration variable is used to turn logging on and is called server audit logging. You can set this variable on command line with SET GLOBAL server audit logging=ON or you can put the variable into your configuration file under the [mysqld] group for a more permanent setting which will stay even when the database server is restarted. The MariaDB audit plugin offers a choice of where to log the output. By default, the audit will log to a file called server_audit.log in the MariaDB data directory. However, you can change it so the plugin logs to syslog, a standard system logging tool. To set where the audit file logs to, change the server variable, server audit output type to SYSLOG. Configuring the audit plugin for syslog involves several variables and is beyond the scope of this course. If you use syslog, it is worth looking at the MariaDB knowledge…

Contents