7.3 Ensure Passwords Are Not Stored in the Global Configuration - %PROGRAMDATA%\MySQL\MySQL Server 5.6\my.ini

Information

The [client] section of the MySQL configuration file allows setting a user and password to be used. Verify the password option is not used in the global configuration file (my.cnf).

Rationale:

Using the password parameter may negatively impact the confidentiality of the user's password.

Solution

Use the mysql_config_editor to store authentication credentials in .mylogin.cnf in encrypted form.

If not possible, use the user-specific options file, .my.cnf., and restricting file access permissions to the user identity.

See Also

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

Item Details

Category: IDENTIFICATION AND AUTHENTICATION, SYSTEM AND COMMUNICATIONS PROTECTION

References: 800-53|IA-5(1), 800-53|SC-28, 800-53|SC-28(1), CSCv7|16.4

Plugin: Windows

Control ID: 562176019bb5a4cfe4ac74e21f9478fd3fb00c9c55672ca906763b98ff2a5719