Connecting MySQL Workbench with Google Cloud SQL

1
votes

I have read and tried prior suggestions.

Here is what I have done.

  1. I signed up for a static IP through a Proxy Server (that uses Port 3128)
  2. I have tested that static IP is working (verified with several IP look up services)
  3. I have chanced the authorized root password
  4. I have tried setting the client host to Proxy Server value on the authorized users.
  5. I have white labeled/authorized the static IP in Cloud SQL
  6. I have tried both the IPv6 and IPv4 addresses from Cloud SQL in MySQL Workbench

I never get passed the error: Lost connection to MySQL server at 'reading initial communication packet', system error: 22 when using the IPv6 and Lost connection to MySQL server at 'reading initial communication packet', system error: 0 when using the IPv4

As an aside, I was able to authorize Zapier IP and have tested a webhook to Cloud SQL

1
mysqlsql-servermysql-workbenchgoogle-cloud-sql
Have you walk these steps cloud.google.com/sql/docs/mysql-client – Drew
Yes. I have MySQL and the Community Server. – Marston Gould
As I mention above, I have changed the root user password in Cloud SQL and made use of these credentials in the Workbench connection. I have tested my static proxy IP and white labeled this within Cloud SQL. I have tried to use both the IPv6 and IPv4 addresses. I have tested MySQL on my localhost and that works smashingly well, both from command line and Workbench. – Marston Gould
BTW - I have also tried restarting the service – Marston Gould
I would be happy to open up an aws 3306 if you wanted to hit it to rule out something – Drew

1 Answers

0
votes

It isn't clear from your description: did you whitelist your computer's IP address? There are sites that will tell you which IP address your computer is using, and that is the address you should use under the Access Control panel.