Saturday, July 1, 2017

[google-cloud-sql-discuss] ERROR 2003 (HY000): Can't connect to MySQL server on 'x.x.x.x' (110)

I'm trying to establish a basic mysql connection from a google compute engine instance in one project to a google cloud sql instance (2nd generation) in a different project.


I've done this many times before without any problem. You simply add the ip address of the google compute instance to the list of authorized networks for the google cloud sql instance. This has always worked in the past but it is not working now.


The only thing that I can think of which is different about this situation is that I've recently been experimenting with using the cloudsql-proxy to establish a connection from a different gce instance to the same google cloud sql instance. Could this be the problem? Perhaps the google cloud sql instance is getting confused by having to support both connection mechanisms?


I just need the connection to work. Is there a work-around?

P.S. I followed the "rule of thumb" and posted this technical question to stackoverflow first:

https://stackoverflow.com/questions/44863898/error-2003-hy000-cant-connect-to-mysql-server-on-x-x-x-x-110



--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/d9fbf806-4df1-4fb9-be7f-d5c15168215e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment