InformationMySQL 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 and ownership structure provided by the host and may be accessible by users other than the MySQL user.
Limiting the accessibility of these objects will protect the confidentiality, integrity, and availability of the MySQL logs.
Changing the permissions and ownership of the relay logs and binary log files might have impact on external tools.
If the permissions on the relay logs and 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.
SolutionExecute the following command for each log file location requiring corrected permissions and ownership:
chmod 660 <log file>
chown mysql:mysql <log file>