Sunday, July 27, 2014

Connecting Google Cloud SQL via mySQL ODBC database driver in Windows 8.1

There are 3 things you have to do in the "Access control" of the Cloud SQL instance
  1. Request an IP of the Cloud SQL instance. P.S. It costs you $0.01 per hour if there is an IP address assign to an idle instance
  2. Set a root password
  3. Provide IP address of the authorized network, usually it means to IP address of your workstation or server.

After that, get the ODBC database driver handy, you may download the driver via this link, your choice of 32/64bits


Next, configure the ODBC driver, enter the IP address provided by Google. You may test the connection by pressing the test button.


All things done, you are on.

I can even connect my Cloud SQL instance through my homebrew database client + ASP code generator created in early years.  You may still find my program published on download.com here. It works on 32bits driver only.


Tears coming out of my eyes

No comments:

Post a Comment

Applying SMA10/20, SMA20/50 as trading signals

This is the comparison for results before and after applying SMA10/20 and SMA20/50 in the stock trader. Background Trading 3 stock ma...