1

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

It is adding my local machine to the authorisation list. I can see that 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...  
Connecting to database with SQL user [root].  
Enter password:   
ERROR 2003 (HY000): Can't connect to MySQL server on '{db ip}' (110)

It isn't configured to use SSL.

GalloCedrone
  • 4,869
  • 3
  • 25
  • 41
stephen
  • 385
  • 3
  • 24
  • By the way if you want you can open a private Google issue posting the project ID and I can take a look into your project. Register it here issuetracker.google.com/issues/new?component=187164 and post in the comment the link (Disclaimer: I work for Google Cloud Platform Support) – GalloCedrone Feb 16 '18 at 14:44

1 Answers1

2

Some thoughts:

A. User root might not be authorized on the database instance, period.

  1. Go to https://console.cloud.google.com/sql/instances/dbinstance/users
  2. Is the user root listed there?
  3. If so, is root authorized from any IP address? (represented by '%')

B. If user root is indeed authorized on 'dbinstance' from any host, there may be a firewall issue in play here on your local network.

  1. In your project, open up the Cloud Shell by clicking on the icon that looks like >_, in the top nav of the Console site. That allows you to move within the GCP network rather than through any firewalls your local network might have in place.
  2. In the Cloud Shell, type: gcloud beta sql connect dbinstance --user=root
  3. It should ask for your password. Type it in.

If the password for root doesn't work, even in the Cloud Shell, try resetting the password (Users tab on your dbinstance Console page, three dots next to root's entry, choose "Change Password."

If the password for root does work within the Cloud Shell environment, you've established that the issue lies between your local machine and the DB instance. Most often it's a firewall issue.

ingernet
  • 1,342
  • 2
  • 12
  • 29