6.8 Ensure 'audit_log_policy' is Set to 'LOGINS'

Information

With the audit_log_policy setting the amount of information which is sent to the audit log is controlled. It must be set to log logins.

Rationale:

If this setting is set to QUERIES or NONE then connections are not written to the audit log file.

Solution

Add the following line to the [mysqld] section of the MySQL configuration file and restart the MySQL service:

audit_log_policy=LOGINS

Default Value:

ALL

See Also

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