GCP SQL database does not use the latest Major version misconfiguration detected in code

Rule Details

Cortex AppSec Rule ID	APPSEC_GCP_79
Category - Subcategory	Compute - Unsanctioned Resource Or Type
Provider	GCP
Severity	LOW
Framework	Terraform

Impact

Using the latest major version for your Google Cloud Platform (GCP) SQL database can help improve the security and reliability of your database. Newer versions of software often include security updates and bug fixes that can help protect your database from potential threats and improve its performance.

How to Fix

[source,go]

resource "google_sql_database_instance" "pass" { provider = google-beta

name = "private-instance-${random_id.db_name_suffix.hex}" region = "us-central1" database_version = "MYSQL_8_0"

depends_on = [google_service_networking_connection.private_vpc_connection]

settings { tier = "db-f1-micro" ip_configuration { ipv4_enabled = false private_network = google_compute_network.private_network.id } } }