Friday, February 16, 2018

[google-cloud-sql-discuss] Cannot connect using gcloud

I can list the databases in my Cloud SQL instance but I can't connect to it.


gcloud beta sql databases list --instance=dbinstance
NAME CHARSET COLLATION
information_schema utf8 utf8_general_ci
main utf8 utf8_general_ci
mysql utf8 utf8_general_ci
performance_schema utf8 utf8_general_ci


I can see my local machine being added to the authorisation list via the console. But it's failing to connect:


gcloud beta sql connect dbinstance --user=root
Whitelisting your IP for incoming connection for 5 minutes...done.
Connecting to database with SQL user [root].
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on 'x.x.x.x' (110)


It isn't configured to use SSL. Actually, this is a newly created instance so I'm happy to try any suggestions regardless of how drastic they are. I can connect in this way from the gcloud command line within the console.

--
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/d2442413-e17f-476e-9def-abdeffc9c4e0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment