6.7 Ensure 'audit_log_include_accounts' is Set to 'NULL'

Information

The audit_log_include_accounts variable enables the administrator to set accounts for which events should be logged in the audit log.

Rationale:

The audit_log_include_accounts variable has two permitted values, either NULL or a list of MySQL accounts. Setting this variable correctly ensures all MySQL users are being logged in the audit log.

Impact:

If a user or a list of users are set as the values for audit_log_include_accounts, these user(s) will ONLY be logged. Other users permitted to access the MySQL Server but not listed under the audit_log_include_accounts variable will avoid being logged in the audit log. Setting audit_log_include_accounts to NULL ensures no MySQL users excluded from the audit log.

Solution

To remediate this configuration setting, execute the following SQL statement

SET GLOBAL audit_log_include_accounts = NULL;

Or set audit_log_include_accounts=NULL in my.cnf.

Default Value:

audit_log_exclude_accounts is set to NULL by default.

See Also

https://workbench.cisecurity.org/files/3848