MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
The audit_log_disable variable,
introduced in MySQL 8.0.28, 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.