Error 2003 (HY000): can't connect to MySQL server on ' IPv4 address' (10060)

kelly Published at Dev

Kelly

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.

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

Kelly

Thanks everyone for your help. After trying all of your suggestions I found a Google group and logged the issue. Google have responded to it as follows:

David Newgas: For now try connecting from a GCE instance (including cloud shell) or using a GCE instance to proxy connections from your laptop. I have updated the dashboard with some more information (although it may take a while for you to see it due to caching) To be clear, this issue will only be affecting first generation instances.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-02-28

Comments

0 comments

From Dev

Google CloudSQL (MySQL) error when trying to connect: ERROR 2003 (HY000): Can't connect to MySQL server on 'google mysql ip here'

From Dev

Error while connecting to MySQL on local docker container: ERROR 2002 (HY000): Can't connect to MySQL server on '127.0.0.1' (115)

From Dev

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' - Missing files

From Dev

Mac terminal ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

From Dev

Laravel migrations work fine, but when I open a page I get "SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'x.x.x.x' (13)" - using vagrant

Related Related

Article