Troubleshooting a Connection Issue with Cloud SQL

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.

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.

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.

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.

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.