Microsoft AzureOverview
Enable audit_log_enabled on MySQL flexible servers.
Rationale
Enabling audit_log_enabled helps MySQL Database to log items such as connection attempts to the server, DDL/DML access, and more. Log data can be used to identify, troubleshoot, and repair configuration errors and suboptimal performance.
Impact
Further costs are incurred for storing logs, which will be significant for high-traffic databases. Determine your organization's needs before enabling.
Default Value
By default, audit_log_enabled is set to OFF.
Remediation guidance
Remediate from Azure Portal
Turn on audit logs
- Login to Azure Portal using https://portal.azure.com.
- Go to
Azure Database for MySQL flexible servers. - For each database, under
Settings, clickServer parameters. - Set
audit_log_enabledtoON. - Click
Save.
Remediate from Azure CLI
Use the below command to enable audit_log_enabled :
az mysql flexible-server parameter set --resource-group <resourceGroup> --server-name <serverName> --name audit_log_enabled --value on
Remediate from PowerShell
Use the below command to enable audit_log_enabled :
Update-AzMySqlFlexibleServerConfiguration -ResourceGroupName <resourceGroup> -ServerName <serverName> -Name audit_log_enabled -Value on
Capture the Audit Logs
Once you have audit_log_enabled enabled, you can capture the logs.
- Under Monitoring, select
Diagnostic settings. - Select
+ Add diagnostic setting. - Provide a diagnostic setting name.
- Under Categories, select
MySQL Audit Logs. - Specify destination details.
- Click
Save.
It may take up to 10 minutes for the logs to appear in the configured destination.
Service-wide remediation
Recommended when many resources are affected: fix the platform baseline first so new resources inherit the secure setting, then remediate the existing flagged resources in batches.
Azure
Use management group or subscription Azure Policy assignments, remediation tasks where supported, landing-zone standards, and IaC modules so drift is prevented at scale.
Operational rollout
- Fix the baseline first at the account, subscription, project, cluster, or tenant scope that owns this control.
- Remediate the currently affected resources in batches, starting with internet-exposed and production assets.
- Re-scan and track approved exceptions with an owner and expiry date.
Query logic
These are the stored checks tied to this control.
Azure MySQL Flex Servers without audit log
Connectors
Covered asset types
Expected check: eq []
{
mySqlFlexibleServers(
where: {
configurations_SOME: {
name: "audit_log_enabled"
value_MATCHES: "(?i)off"
}
}
) {
...AssetFragment
}
}
