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.

Rationale:

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.

Impact:

Enabling SSL could have impact on network traffic inspection.

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;

Default Value:

DISABLED

See Also

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

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: d3efdad5bbc9e5ace7eedc4accae7ae5f08f790b65b28b9913fce9cd6bf84ffd