3.2 Ensure 'log_bin_basename' Files Have Appropriate Permissions and Ownership

Warning! Audit Deprecated

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

View Next Audit Version

Information

Limiting the accessibility of these objects will protect the confidentiality, integrity, and availability of the MySQL logs.

Solution

Execute the following command for each log file location requiring corrected permissions and ownership: chmod 660 <log file> chown mysql:mysql <log file> Impact: Changing the permissions and ownership of the log files might impact monitoring tools which use a logfile adapter. If the permissions on the binary log files are accidentally changed to exclude the user account which is used to run the MySQL service, then this might break replication. The binary log file can be used for point in time recovery so this can also affect backup, restore and disaster recovery procedures.

See Also

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