- Lab
-
Libraries: If you want this lab, consider one of these libraries.
- Cloud
- Data

Troubleshooting a Connection Issue with Cloud SQL
Sometimes, you may face connectivity issues with your Cloud SQL instance, and it's important to know what to look for when troubleshooting. In this hands-on lab, we will discover a solution when troubleshooting a connection issue between a Compute Engine Instance and a Cloud SQL Instance.

Lab Info
Table of Contents
-
Challenge
Create a Cloud SQL Instance
- From the main console navigation, head over to SQL.
- Click on CREATE INSTANCE.
- Then choose MySQL.
- Name the instance "test-connection-instance" and add the following settings:
- Root password: "12345"
- Database version: MySQL 5.7
- Machine type: Standard (1 vCPU, 3.75 GB)
- Click Create.
-
Challenge
Create a Compute Engine Instance
- From the main console navigation, head over to Compute Engine*
- Click Create.
- Click on Allow HTTP. Then leave everything else as the default. The boot disk should be Debian.
- Click Create.
-
Challenge
Enable the Cloud SQL Admin API
- From the main console navigation, head over to APIs and Services.
- Click on Enable APIs and Services.
- Then type in "Cloud SQL Admin API".
- Click Enable.
-
Challenge
Add the Compute Engine Instance Public IP as a Authorized Network for Cloud SQL
- From the main console navigation, head over to Compute Engine.
- Then choose and copy the public IP for your instance.
- From the main console navigation, head over to SQL.
- Click on the test-connection-instance. Click on Edit, and then Connectivity.
- Click on Add network, paste the VM's IP, and click Done.
- Click Save.
-
Challenge
SSH into Your VM to Connect to Cloud SQL
- From the main console navigation, head over to Compute Engine.
- Click on SSH.
- Once connected, get and install updates.
- Connect to the instance by using the command.
- Use the password you set up for your instance.
You are now connected.
About the author
Real skill practice before real-world application
Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.
Learn by doing
Engage hands-on with the tools and technologies you’re learning. You pick the skill, we provide the credentials and environment.
Follow your guide
All labs have detailed instructions and objectives, guiding you through the learning process and ensuring you understand every step.
Turn time into mastery
On average, you retain 75% more of your learning if you take time to practice. Hands-on labs set you up for success to make those skills stick.