The audit log plugin is named
be usable by the server, the plugin library object file must be
located in the MySQL plugin directory (the directory named by
variable). If necessary, set the value of
plugin_dir at server startup to
tell the server the location of the plugin directory.
To load the plugin at server startup, use the
--plugin-load option to name the
object file that contains the plugin. With this plugin-loading
method, the option must be given each time the server starts.
For example, put the following lines in your
If object files have a suffix different from
.so on your system, substitute the correct
suffix (for example,
.dll on Windows).
Alternatively, to register the plugin at runtime, use this statement (changing the suffix as necessary):
INSTALL PLUGIN audit_log SONAME 'audit_log.so';
INSTALL PLUGIN loads the plugin,
and also registers it in the
table to cause the plugin to be loaded for each subsequent
normal server startup.
If the plugin is loaded with
--plugin-load or has been
previously registered with
PLUGIN, you can use the
option at server startup to control plugin activation. For
example, to load the plugin and prevent it from being removed at
runtime, use these options:
[mysqld] plugin-load=audit_log.so audit-log=FORCE_PLUS_PERMANENT
If it is desired to prevent the server from running without the
audit plugin, use
with a value of
FORCE_PLUS_PERMANENT to force server startup
to fail if the plugin does not initialize successfully.
For general information about installing plugins, see
Server Plugins. To verify plugin installation,
INFORMATION_SCHEMA.PLUGINS table or
SHOW PLUGINS statement.
See Obtaining Server Plugin Information.
Audit log file contents are not encrypted. See Section 5.11.2, “Audit Log Plugin Security Considerations”.
For additional information about the parameters used to
configure operation of the
see Section 5.11.6, “Audit Log Plugin Options and System Variables”.