Documentation Home
MySQL 9.4 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 41.2Mb
PDF (A4) - 41.3Mb
Man Pages (TGZ) - 262.8Kb
Man Pages (Zip) - 368.8Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


8.4.6.9 Disabling Audit Logging

Theaudit_log_disable variable 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;

Settingaudit_log_disable to true disables the audit log plugin. The plugin is re-enabled whenaudit_log_disable is set back tofalse, 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 deprecatedSUPER privilege) normally required to set a global system variable runtime value.