How to connect WAMP to Google SQL with Cloud Proxy

Question

On our development server and test linux boxes, we have been using Google SQL with Cloud Proxy for connections. Everything is working just fine.

However, I need to setup a couple users with WAMP. (Windows 10 64bit Apache, PHP 7). I am not very familiar with WAMP. We have everything working except Cloud Proxy.

On our Linux boxes we have the socket setup in its own folder (under root) /cloudsql.

What is the equivalent location on WAMP? (We don't want to have to maintain different configuration files just for one or two WAMP boxes).

Answer 1

On Windows, you must use TCP sockets. The documentation can be found here: https://cloud.google.com/sql/docs/mysql/connect-external-app#6_start_the_proxy

Specifically you must tell the proxy the instance name and the local port on which to listen for connections for that instance:

cloud_sql_proxy.exe -instances=<INSTANCE_CONNECTION_NAME>=tcp:3306