External IP addresses for access control not getting set in Google Cloud SQL

Question

I'm facing a strange issue in Google Cloud SQL. I'm not able to set external IPs in access control. When I add a IP it shows updating when after sometime it does get updated.

But as soon as I refresh the page, the IP address is gone.

What I'm trying to achieve is connecting my local dev SQL Client to Google Cloud SQL, so I need to configure external IP address to give access. But It wasn't working and I'm getting following error

On further investigation I found that the IP I'm configuring is not getting updated as per error I mentioned above. Google Cloud SQL experts, please help.

Also, if I don't have static IP address of my own, what should I be configuring? I have got IPv4 assigned to my Cloud SQL instance.

PS: Not sure if it'll matter, but I'm under trial period of Google Cloud.

Answer 1

I had the same problem and it was resolved by editing your Cloud SQL instance :

Then you go directly to the Authorized Networks :

And it should be ok.

Answer 2

Try setting a new password for your root user and add your ip address, then try again connecting with your MySQL client. This solution works for me.