forum

Home / DeveloperSection / Forums / Testing Connection to Cloud SQL instance with a MySQL client from VM Instance.

Testing Connection to Cloud SQL instance with a MySQL client from VM Instance.

Nishi Tiwari70308-Jan-2020

explain it.

Updated on 08-Jan-2020

I am a currently pursuing Bca from United Institute of Management. Want to become software developer.

Can you answer this question?

Answer

09-Jan-2020

Now return to our VM Instance and test our connection.
Click on the Navigation Menu go to Compute Engine then VM Instances.
On our newly created VM, Click on SSH, this would open a new window with SSH connection to our VM instance.

On the SSH window, execute these following commands, remember to change 35.202.255.49 to your own Cloud SQL Instance’s Public IP.
sudo apt-get update
sudo apt-get install mysql-client -y
mysql — host=35.202.255.49 — user=root — password
You’ll get a password prompt, enter that password which used when creating the Cloud SQL Instance, if correct, you’ll get connected to your SQL Instance.