8.1 Ensure 'require_secure_transport' is Set to 'ON' and/or 'have_ssl' is Set to 'YES'

Information

All network traffic must use SSL/TLS when traveling over untrusted networks.

Enabling Secure Sockets Layer (SSL) will allow clients to encrypt network traffic and verify the identity of the server. The SSL/TLS-protected MySQL protocol helps to prevent eavesdropping and man-in-the-middle attacks.

Solution

Follow the procedures as documented in the MySQL 8.0 Reference Manual to setup SSL.

Set global policy to force SSL for all connections:

set persist require_secure_transport=ON;

Impact:

Enabling SSL could have impact on network traffic inspection.

See Also

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

Item Details

Category: ACCESS CONTROL, IDENTIFICATION AND AUTHENTICATION, SYSTEM AND COMMUNICATIONS PROTECTION

References: 800-53|AC-17(2), 800-53|IA-5, 800-53|IA-5(1), 800-53|SC-8, 800-53|SC-8(1), CSCv7|14.4

Plugin: MySQLDB

Control ID: 3ccf240d44c0f891219f94b99c4150198cfe9e7a5d58fd14ff52ec118a8eeb9d