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.

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.

See Also

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

Item Details

Category: CONFIGURATION MANAGEMENT

References: 800-53|CM-6b.

Plugin: MySQLDB

Control ID: e199e728b98a626dc761bfacc14967fe4ffb8ff768db31fe19a19fea7fec3838