Documentation Home
MySQL 9.6 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 41.8Mb
PDF (A4) - 41.9Mb
Man Pages (TGZ) - 272.3Kb
Man Pages (Zip) - 378.1Kb
Info (Gzip) - 4.2Mb
Info (Zip) - 4.2Mb


MySQL 9.6 Reference Manual  /  ...  /  Disabling Audit Logging for Audit Log Plugin (Deprecated)

8.4.6.9 Disabling Audit Logging for Audit Log Plugin (Deprecated)

Important

The audit_log plugin is deprecated, and is being replaced by the audit_log component. Deprecation of the plugin means that you should expect the plugin to be removed in a future version of MySQL. For more information about the audit log component, see Section 8.4.7, “MySQL Enterprise Audit Component”.

The audit_log_disable variable permits disabling audit logging for all connecting and connected sessions. The audit_log_disable variable can be set in a MySQL Server option file, in a command-line startup string, or at runtime using a SET statement; for example:

SET GLOBAL audit_log_disable = true;

Setting audit_log_disable to true disables the audit log plugin. The plugin is re-enabled when audit_log_disable is set back to false, which is the default setting.

Starting the audit log plugin with audit_log_disable = true generates a warning (ER_WARN_AUDIT_LOG_DISABLED) with the following message: Audit Log is disabled. Enable it with audit_log_disable = false. Setting audit_log_disable to false also generates warning. When audit_log_disable is set to true, audit log function calls and variable changes generate a session warning.

Setting the runtime value of audit_log_disable requires the AUDIT_ADMIN privilege, in addition to the SYSTEM_VARIABLES_ADMIN privilege (or the deprecated SUPER privilege) normally required to set a global system variable runtime value.