6.3 Ensure 'log_error_verbosity' is Set to '2'

Information

The log_error_verbosity system variable, set to 2 by default, specifies the verbosity of events sent to the MySQL error log. A value of 2 enables logging of error and warning messages, a value of 3 also includes informational logging, a value of 1 logs only errors.

This might help to detect malicious behavior by logging communication errors and aborted connections.

Solution

Perform the following actions to remediate this setting:

- Open the MySQL configuration file ( my.cnf )
- Ensure the following line is found in the mysqld section log_error_verbosity = 2

See Also

https://workbench.cisecurity.org/benchmarks/15503