More Info:

Determine if the SQL instances provisioned in the account are only of the type desired by the organization and nothing else.

Risk Level

Medium

Address

Operational Maturity

Compliance Standards

CBP

Triage and Remediation

Remediation

The following are the step-by-step instructions to remediate the misconfiguration “Determine SQL Instances Provisioned are of Desired Type” for GCP using GCP console:

  1. Open the Google Cloud Console and navigate to the SQL Instances page.

  2. Identify the SQL instances that are not of the desired type.

  3. Click on the name of the SQL instance that needs to be remediated.

  4. In the Instance details page, click on the Edit button at the top of the page.

  5. In the Edit page, scroll down to the Configuration Options section.

  6. In the Configuration Options section, select the desired SQL type from the drop-down menu.

  7. Click on the Save button at the bottom of the page to save the changes.

  8. Repeat the above steps for all the SQL instances that are not of the desired type.

  9. Verify that all the SQL instances are now of the desired type by checking the Instance details page for each SQL instance.

By following the above steps, you can remediate the misconfiguration “Determine SQL Instances Provisioned are of Desired Type” for GCP using GCP console.