How do I add proxy and authorization to access Cloud SQL db from my PC

[Vinod Babu]

Hello,

I am a newbee on cloud sql - please help me. 

I have created a mySql 2nd Generation database on google cloud. I am able to access it from my PC, add/remove tables etc after I add my IP address (from whatismy ip search on google) in the authorized IP address list. But my IP address keeps changing everyday and I have to keep updating the IP address. 

I read that it is possible to fix this by creating a proxy in the Google Compute Engine. With my inexperience I could not follow the instructions on the google website.

Can someone help me to create a proxy on Google Compute engine, so that my PC gets authorized even if the IP address changes? 

Thank you very much..

[Kamran (Google Cloud Support)]

Hello Babu,

You can use Cloud SQL Proxy. The Cloud SQL Proxy is useful when connecting from clients with dynamic IP addresses. Please visit this article for more information about Google Cloud SQL Proxy and installation instructions. However, please note that this is a Beta release.

Sincerely,

Kamran

[Kevin Malachowski]

To be explicit: you can run the Cloud SQL Proxy directly from your PC. No need to use a Compute Engine VM! Please feel free to post back if you are having trouble setting up the Proxy, we'll be glad to help out.

In general, there are three major steps:

1) Download the proxy: on the page previously linked, you can download a precompiled version for your OS/CPU combination of your system.

2) Run the proxy: there are a few examples at the bottom of the page on how to start running the proxy

3) Connect to the proxy: depending on what flag options you passed to the proxy when starting it, you will need to configure your application (mysql command line, for example) to connect via TCP or UNIX socket.

If you have gcloud installed and have run `gcloud auth login`, the latest version of the proxy will just use those credentials when accessing Cloud SQL Databases.

[Vinod Babu]

That seems to be an excellent option and thank you for suggesting. That way I don't have to use the VM only for proxy. 

I will follow the steps mentioned and try to set it up.

Regards

[Vinod Babu]

Thank you,

I was able to follow the steps and it works for me with cloud proxy installed on my local windows 8 machine. Now I access the db using cloud_sql_proxy_x64.exe..

Thanks again

Babu