O'Reilly logo

MariaDB Cookbook by Daniel Bartholomew

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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; ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required