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/15504

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: 3482cc86a5759bb89f6ac08001e960931654c4a833df61ff95896704bcb7fa41