Lost connection error when trying to connect to proxy SQL on VM with Container Optimised OS

Question

For a project with Data Fusion I need to create a Virtual Machine with Proxy SQL. In order to test this proxy I've created a second instance with MariaBD but I'm not able to establish the connection with the proxy. Here is what I have:

A VM running on Container Optimised OS with a static internal IP and no external IP. This VM is running with the following startup script:

sudo docker run -d \
  -p 0.0.0.0:3307:3307 \
  gcr.io/cloudsql-docker/gce-proxy:latest /cloud_sql_proxy \
  -instances=sqlinstance_connection_name=tcp:0.0.0.0:3307

a Cloud SQL for MySQL instance with private IP activated.

Everything is running on GCP in the same project on the same region and network (default). Firewall are widely open for testing purpose.

When running the following command mysql -u user_name -p'123' -h 10.132.0.4 -P 3307 from a second VM for testing purpose I have the following error:

(HY000): Lost connection to MySQL server at 'handshake: reading initial communication packet', system error: 11 

So what is the issue here?

Answer 1

Can you check if the instance's service account has the CloudSQL Client role?