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.