Benchmark: MySQL
Description
This benchmark provides a set of controls that detect Terraform Azure MySQL resources deviating from security best practices.
Usage
Install the mod:
mkdir dashboardscd dashboardspowerpipe mod initpowerpipe mod install github.com/turbot/steampipe-mod-terraform-azure-complianceStart the Powerpipe server:
steampipe service startpowerpipe serverOpen http://localhost:9033 in your browser and select MySQL.
Run this benchmark in your terminal:
powerpipe benchmark run terraform_azure_compliance.benchmark.mysqlSnapshot and share results via Turbot Pipes:
powerpipe benchmark run terraform_azure_compliance.benchmark.mysql --shareControls
- Geo-redundant backup should be enabled for Azure Database for MySQL
- MySQL servers should use customer-managed keys to encrypt data at rest
- Infrastructure encryption should be enabled for Azure Database for MySQL servers
- Ensure 'TLS Version' is set to 'TLSV1.2' for MySQL flexible Database Server
- Public network access should be disabled for MySQL servers
- MySQL servers should have threat detection enabled
- Enforce SSL connection should be enabled for MySQL database servers