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.
Complete the Installing the Audit Plugin recipe described earlier in this chapter to install the Audit Plugin, prior to using the Audit Plugin.
Connect to MariaDB using the
mysqlcommand-line client with a user that has theSUPERprivilege.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:
Turn off the audit logging with the following command:
SET GLOBAL server_audit_logging=OFF;Turn on the audit logging with the following command:
SET GLOBAL server_audit_logging=ON;Force the audit logfile to rotate immediately with the following command:
SET GLOBAL server_audit_file_rotate_now=ON;