Removing 0.0.0.0/0 as allowed IP from a Google SQL instance production
My PHP app is on a DigitalOcean droplet while my MySQL 8.0 database is on Google Cloud SQL.
I was testing for a while on localhost and hence gave 0.0.0.0/0, but now I don't want any server other than my droplet to connect to the Google Cloud SQL instance.
Can I now safely remove 0.0.0.0/0 ?
Solution
yes it should be safe, and is actually recommended to remove 0.0.0.0/0 from the allowlist.
Once this is removed you will still be able to connect from external IPs not in the whitelist using either the CloudSQL auth proxy or with SSL/TLS certificates
- Connect Google Cloud SQL Potsgres with Google DataStudio
- Postgres CloudSQL Migration: ERROR: permission denied to set parameter "log_min_duration_statement"
- Exporting from Cloud SQL to CSV with column headers
- GCP Cloud SQL Proxy times out: connectex
- Google Cloud MySQL Truncating Timestamps from CSV Import
- How to configure pg_trgm similarity threshold parameters in a Google Cloud SQL PostgreSQL instance
- Why would Mysql return "error Column cannot be null"?
- Data Transfer from BQ To CLoud SQL
- How to link Google Kubernetes Engine (GKE) and Cloud SQL database?
- "FATAL: remaining connection slots are reserved for non-replication superuser connections" triggers despite closing connections
- Creating a cloudsql instance in the VPC network of my Project
- Google Cloud platform performance: how many users
- .NET Core Blazor Server cannot access to Cloud SQL in Cloud Run
- How to export data from Google BigQuery to PostgreSQL
- How to connect Google Data Studio to Google Cloud SQL
- database connection URI string for GCP cloudsql postgres database?
- Best way to import Google Cloud SQL data into BigQuery
- Creating a CloudSQL IAM user different than logged in IAM user
- How to lower costs of having MySQL db in Google Cloud
- Google Cloud Functions and Cloud SQL - Intermittent Connection Errors & SQL Admin Quota
- Secret Manager with Spring Boot issue
- How to fix mysql access denied on google-cloud-platform compute instance
- In Google Cloud SQL Postgres how do I avoid log_min_messages as not superuser?
- How to simplify and remove overlap in GeoJSON polygons
- ERROR 2005 (HY000): Unknown MySQL server host '[35.232.51.216]' (0) in google cloud SQL client
- How to increase the connection limit for the Google Cloud SQL Postgres database?
- Removing 0.0.0.0/0 as allowed IP from a Google SQL instance production
- Issues connecting Data Fusion to CloudSQL Postgres instance - getting a 403 "The client is not authorized to make this request"
- How to connect Sequelize to Google Cloud SQL database when I have deployed my Node.JS backend api?
- Does Cloud SQL have a query console or is CLI the only option?