MySQL :: MySQL 8.0 Reference Manual :: 8.4.5.9 Disabling Audit Logging (original) (raw)

8.4.5.9 Disabling Audit Logging

The audit_log_disable variable, introduced in MySQL 8.0.28, permits disabling audit logging for all connecting and connected sessions. Theaudit_log_disable variable can be set in a MySQL Server option file, in a command-line startup string, or at runtime using aSET 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 withaudit_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. Settingaudit_log_disable to false also generates warning. Whenaudit_log_disable is set to true, audit log function calls and variable changes generate a session warning.

Setting the runtime value ofaudit_log_disable requires theAUDIT_ADMIN privilege, in addition to theSYSTEM_VARIABLES_ADMIN privilege (or the deprecated SUPER privilege) normally required to set a global system variable runtime value.