Monday, October 10, 2016

[google-cloud-sql-discuss] Re: Error 2003 (HY000): can't connect to MySQL server on ' ' (10060)


Hi 

I don't know if there is a solution for this error already, but I couldn't find one. I'm having the same issue. I was able to connect to the cloud SQL for the first time from MYSQL client(windows machine). 
But after that I'm no longer able to connect to the cloud, nor from my windows neither from mac or ubuntu.

1. I have got same error number but I got three separate socket number after 127.0.0.1, here they are 
    (a) ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (10061)  - in windows
    (b) ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
    (c) ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (110)

I appreciate any help in this regard. FYI, I was using second generation instance, accessing MYSQL from google console has no issue. 
Thanks 
SYED

On Thursday, April 14, 2016 at 5:55:41 AM UTC-4, Kelly Ingram wrote:

I have a Google Cloud SQL Instance that I have been using for some time now and connecting successfully from MySQL Workbench. However as of yesterday I can't connect using MySQL Workbench (or the command line on my laptop) and get the error:


ERROR 2003 (HY000): Can't connect to MySQL server on '207.xxx.xxx.xx' (10060)


I have done the following already:

  • Authorised my laptop's IP address (found using whatismyip.com) in the Google Console.
  • Assigned an IPv4 address to the database in the Google Console.
  • Created new users and passwords to see if it was a user issue. But that didn't help.
  • Restarted the instance, restarted my home network/laptop and got new IP addresses (and updated the authorised IP address accordingly).
  • Upgraded to the latest MySQL workbench 6.3 CE but still have the issue.

The database works as my app can connect to it and accesses the data, I just can't get a remote connection from my laptop.


Someone else is having a similar problem with their Django project (https://github.com/GoogleCloudPlatform/appengine-django-skeleton/issues/16)


I am new to this and am out of ideas on how to fix it. Any help would be greatly appreciated.

--
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/7a983112-f2ac-4754-b9f2-1c9c635932a3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment