How to use MySQL Workbench to configure connection and google cloud sql connection

enter a description of the image here. Follow this guide https://cloud.google.com/sql/docs/admin-tools

but he is very abstract.

I cannot correctly configure a new connection in Workbench MYSQL. It always appears "failed to connect to MySQL in 2001: 4860: 4864: 1: c88e: be5b: bd5: 6cf7: 3306 with root user, 10060"

My Google Cloud SQL IP address: 2001: 4860: 4864: 1: c88e: be5b: bd5: 6cf7, port 3306 username: root. (I set the root) password: admin, every time.

I put my ipv4 address on a computer on an authorized Cloud network (authorization).

Question: I guessed: 1. Actually, I’m not sure how to fill the “port” at the local level, I know that it is 3306 as a whole. I am not sure if port 3306 when the instance address is ipv6 format.

  1. Is it possible that I made a mistake when setting up my IP address in Cloud SQL resolution? I used a laptop in my home online store. At first, I just looked up my IP address using google 'my ip address', 108.15.38.144', and then populated it on the "allowed network" in Cloud SQL.

  2. Is it possible that I made a mistake when I set up the user "root"? I simply entered the username and password in the user settings for access control in Cloud Sql. I did not change the default value for clienthost:% when I configured the user,

connection error image: http://i.stack.imgur.com/snhZb.png

, ?

+4
1

MySQL Workbench Google Cloud SQL . , .

, - IPv6, IPv6, . IPv4 Cloud SQL.

+3

Source: https://habr.com/ru/post/1584701/


All Articles