9.3 Ensure 'master_info_repository' is Set to 'TABLE'

Information

The master_info_repository setting, which is deprecated as of 8.0.22, determines to where a REPLICA (slave is deprecated as of 8.0.22) logs SOURCE status and connection information. The options are FILE or TABLE. Note also that this setting is associated with the sync_master_info, which is deprecated in 8.0.22, setting as well.

Rationale:

The password which the client uses is stored in the SOURCE info repository, which by default is a plaintext file. The TABLE SOURCE info repository is a bit safer, but with filesystem access it's still possible to gain access to the password the REPLICA is using.

Solution

Perform the following actions to remediate this setting:

Open the MySQL configuration file (my.cnf)

Locate master_info_repository

Set the master_info_repository value to TABLE

Note: If master_info_repository does not exist, add it to the configuration file.

Default Value:

TABLE

See Also

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

Item Details

Category: CONFIGURATION MANAGEMENT

References: 800-53|CM-6b.

Plugin: MySQLDB

Control ID: 4f488af8672b0c0faca1caf8a9ead9f6dd314b42a5f300d2573936eac54869e4