Using the Audit Plugin

Installing the MariaDB Audit Plugin, as described in the previous recipe, doesn't do a whole lot for us. In order to get the most out of this plugin, we need to configure it. That is what this recipe is about.

Getting ready

Complete the Installing the Audit Plugin recipe described earlier in this chapter to install the Audit Plugin, prior to using the Audit Plugin.

How to do it...

1. Connect to MariaDB using the mysql command-line client with a user that has the SUPER privilege.

2. Show the Audit Plugin variables with the following command:

   SHOW GLOBAL VARIABLES LIKE 'server_audit%';
   

   The preceding command displays an output similar to the following screenshot:

   

3. Turn off the audit logging with the following command:

   SET GLOBAL server_audit_logging=OFF;
   

4. Turn on the audit logging with the following command:

   SET GLOBAL server_audit_logging=ON;
   

5. Force the audit logfile to rotate immediately with the following command:

   SET GLOBAL server_audit_file_rotate_now=ON;
   

6. Show the location of the...