Search code examples
networkingipgoogle-cloud-sqlsubnet

What's my ip address on CIDR format for google sql authorisation

I'm trying to whitelist my ip address on google cloud SQL storage. However they ask for a CIDR notation. I read the wikipedia page, went through various converters and read some post on stackoverflow on how to convert my IP to a CIDR valid ip. I still can't manage to connect with my ip - while by whitelisting all ips 0.0.0.0 it works - .

So here is an example ip : 

80.210.10.180

if I type into ipconfig I see:

Subnet Mask . . . . . . . . . . . : 255.255.255.0

How can I get the cidr ipv4 valid adress ?

Solution

  • The authorization page will accept plain IPs. e.g. If your IP is 80.210.10.180 you can simply enter 80.210.10.180. (If you're curious, the CIDR notation for this is 80.210.10.180/32, but that's not important.)

    If that doesn't work, it's likely that your external IP as seen by Google is different.

    Does this IP match what you see if you type "what is my ip" into Google search?