Unable to connect to cloud sql using mysql client

[Garima Ahuja]

Hi,

I am a newbie to google app engine. I have been trying to connect to Cloud SQL using mysql client. I have whitelisted my ip in the app. The error I am getting is:

ERROR 2003 (HY000): Can't connect to MySQL server on 'ip' (111)

I am behind a proxy, could that be the reason? If yes, kindly guide me on how to resolve this.

Hoping for helpful responses.

Sincerely,

Garima Ahuja

[Vinny P]

On Sun, Nov 10, 2013 at 1:30 PM, Garima Ahuja <garimaah...@gmail.com> wrote:

I have been trying to connect to Cloud SQL using mysql client. I have whitelisted my ip in the app. The error I am getting is:

ERROR 2003 (HY000): Can't connect to MySQL server on 'ip' (111) I am behind a proxy, could that be the reason? 

Error 111 is generally code for connection refused, as you can see from the error text. 

The proxy may be the issue here, depending on how it's configured. Did you whitelist your IP or the proxy's IP address in the console? Try whitelisting both. Also, try using the SQuirrel client ( https://developers.google.com/cloud-sql/docs/admin-tools#squirrel ), it tends to be much more user-friendly than the standard client. 

In addition, post your issue at the Cloud SQL Google Group located at https://groups.google.com/forum/#!forum/google-cloud-sql-discuss . There are a number of helpful people on that board with expertise in Cloud SQL. 

 

-----------------

-Vinny P

Technology & Media Advisor

Chicago, IL

App Engine Code Samples: http://www.learntogoogleit.com