3.4 Ensure 'slow_query_log' Has Appropriate Permissions

Warning! Audit Deprecated

This audit has been deprecated and will be removed in a future update.

View Next Audit Version

Information

MySQL can operate using a variety of log files, each used for different purposes. These are the binary log, error log, slow query log, relay log, and general log. Because these are files on the host operating system, they are subject to the permissions structure provided by the host and may be accessible by users other than the MySQL user.
NOTE : Nessus has not performed this query, and this check is only provided for informational purposes.

Solution

Modify permissions for the 'slow_query_log' log to not include inheritance, like the following:

administrators:
+ Apply To: 'this folder, subfolders and files'
|- Inheritance: 'not inherited'
|- Allow: 'full control'

creator owner:
+ Apply To: 'subfolders and files only'
|- Inheritance: 'not inherited'
|- Allow: 'full control'

MYSQL_USER or NETWORK SERVICE:
+ Apply To: 'this folder, subfolders and files'
|- Inheritance: 'not inherited'
|- Allow: 'full control'

system:
+ Apply To: 'this folder, subfolders and files'
|- Inheritance: 'not inherited'
|- Allow: 'full control'

See Also

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