Query: Enforce SSL connection should be enabled for MySQL database servers

Description

Azure Database for MySQL supports connecting your Azure Database for MySQL server to client applications using Secure Sockets Layer (SSL). Enforcing SSL connections between your database server and your client applications helps protect against 'man in the middle' attacks by encrypting the data stream between the server and your application. This configuration enforces that SSL is always enabled for accessing your database server.

Query

Tables used in this query:

• azure_mysql_server
• azure_subscription

Controls using this query:

• 4.3.2 Ensure 'Enforce SSL connection' is set to 'ENABLED' for MySQL Database Server
• 4.4.1 Ensure 'Enforce SSL connection' is set to 'ENABLED' for MySQL Database Server
• 4.4.1 Ensure 'Enforce SSL connection' is set to 'Enabled' for Standard MySQL Database Server
• 4.4.1 Ensure 'Enforce SSL connection' is set to 'Enabled' for Standard MySQL Database Server
• 4.4.1 Ensure 'Enforce SSL connection' is set to 'Enabled' for Standard MySQL Database Server
• Enforce SSL connection should be enabled for MySQL database servers

SQL