Remediation
From Google Cloud Console
- Go to the Cloud SQL Instances page in the Google Cloud Console by visiting https://console.cloud.google.com/sql/instances.
- Select the Mysql instance for which you want to enable to database flag.
- Click
Edit. - Scroll down to the
Flagssection. - To set a flag that has not been set on the instance before, click
Add a Database Flag, choose the flagskip_show_databasefrom the drop-down menu, and set its value toon. - Click
Saveto save your changes. - Confirm your changes under
Flagson the Overview page.
From Google Cloud CLI
-
List all Cloud SQL database Instances
gcloud sql instances list -
Configure the
skip_show_databasedatabase flag for every Cloud SQL Mysql database instance using the below command.gcloud sql instances patch <INSTANCE_NAME> --database-flags skip_show_database=on
Note: This command will overwrite all database flags previously set. To keep those and add new ones, include the values for all flags you want set on the instance; any flag not specifically included is set to its default value. For flags that do not take a value, specify the flag name followed by an equals sign ("=").