4
votes

I can't add "0.0.0.0/0" as an authorized network for my cloud sql. Error message from client: Lost connection to MySQL server at 'reading initial communication packet', system error: 0

If I authorize my IP address it works just fine but for some reason "0.0.0.0/0" doesn't work. Google's documentation suggests that it should work: https://cloud.google.com/sql/docs/access-control#dynamicIP

Thanks :)

1
I can't replicate this :( Adding 0.0.0.0/0 to my instance did allow me to access the database. Can you contact [email protected] with your instance name and I will look into it for you? Can you include a screenshot of the Access Control page? Thanks!cflewis
Trying this today I get the following message and can't Save the changes I've made: You have added 0.0.0.0/0 as an allowed network. This prefix will allow any IPv4 client to pass the network firewall and make login attempts to your instance, including clients you did not intend to allow. Clients still need valid credentials to successfully log in to your instance. and Operation failed: The incoming request contained invalid data. ... does anybody know whether GCP have maybe tightened their restrictions on adding 0.0.0.0/0 as a range? Perhaps I've not activated some extra hidden setting?olisteadman

1 Answers

4
votes

Turns out that I was trying to authorize all IPv6 addresses. The cloud-sql team at Google added a new feature to authorize all IPv6 addresses by adding "::/0".