Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

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

Nishi Tiwari 1053 08 Jan 2020

explain it.

Nishi Tiwari

Student

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

1 Answers

Nishi Tiwari 09 Jan 2020

On the detail page of our Cloud SQL Instance, take note of Public IP address.

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.

advertising