Featured resource
2025 Tech Upskilling Playbook
Tech Upskilling Playbook

Build future-ready tech teams and hit key business milestones with seven proven plays from industry leaders.

Check it out
  • Lab
    • Libraries: If you want this lab, consider one of these libraries.
    • Cloud
    • Data
Labs

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 platform
Lab Info
Level
Intermediate
Last updated
Aug 29, 2025
Duration
1h 0m

Contact sales

By filling out this form and clicking submit, you acknowledge our privacy policy.
Table of Contents
  1. Challenge

    Create a Cloud SQL Instance
    1. From the main console navigation, head over to SQL.
    2. Click on CREATE INSTANCE.
    3. Then choose MySQL.
    4. 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)
    5. Click Create.
  2. Challenge

    Create a Compute Engine Instance
    1. From the main console navigation, head over to Compute Engine*
    2. Click Create.
    3. Click on Allow HTTP. Then leave everything else as the default. The boot disk should be Debian.
    4. Click Create.
  3. Challenge

    Enable the Cloud SQL Admin API
    1. From the main console navigation, head over to APIs and Services.
    2. Click on Enable APIs and Services.
    3. Then type in "Cloud SQL Admin API".
    4. Click Enable.
  4. Challenge

    Add the Compute Engine Instance Public IP as a Authorized Network for Cloud SQL
    1. From the main console navigation, head over to Compute Engine.
    2. Then choose and copy the public IP for your instance.
    3. From the main console navigation, head over to SQL.
    4. Click on the test-connection-instance. Click on Edit, and then Connectivity.
    5. Click on Add network, paste the VM's IP, and click Done.
    6. Click Save.
  5. Challenge

    SSH into Your VM to Connect to Cloud SQL
    1. From the main console navigation, head over to Compute Engine.
    2. Click on SSH.
    3. Once connected, get and install updates.
    4. Connect to the instance by using the command.
    5. Use the password you set up for your instance.

    You are now connected.

About the author

Pluralsight Skills gives leaders confidence they have the skills needed to execute technology strategy. Technology teams can benchmark expertise across roles, speed up release cycles and build reliable, secure products. By leveraging our expert content, skill assessments and one-of-a-kind analytics, keep up with the pace of change, put the right people on the right projects and boost productivity. It's the most effective path to developing tech skills at scale.

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.

Get started with Pluralsight