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.