Cloud SQL for MySQL: Qwik Start - GSP151

Overview

In this lab, you learn how to create and connect to a Cloud SQL for MySQL instance and perform basic SQL operations using the Cloud console and the mysql client.

What you'll do

• Create a Cloud SQL instance

• Connect to the instance in Cloud Shell

• Create a database and upload data

Task 1. Create a Cloud SQL instance

1. From the Navigation menu () click on SQL.

2. Click Create Instance.

3. Choose MySQL database engine.

4. Enter Instance ID as myinstance.

5. In the password field click on the Generate link and the eye icon to see the password. Save the password to use in the next section.

6. Select the database version as MySQL 8.

7. For Choose a Cloud SQL edition, select Enterprise edition.

8. For Preset choose Development (4 vCPU, 16 GB RAM, 100 GB Storage, Single zone).

Warning: if you choose a preset larger than Development, your project will be flagged and your lab will be terminated.

9. Set Region as <REGION>.

10. Set the Multi zones (Highly available) > Primary Zone field as <ZONE>.

11. Click CREATE INSTANCE.

It might take a few minutes for the instance to be created. Once it is, you will see a green checkmark next to the instance name.

12. Click on the Cloud SQL instance. The SQL Overview page opens.

Test Completed Task

Click Check my progress to verify your performed task. If you have successfully created a Cloud SQL instance, you will see an assessment score.

Create a Cloud SQL instance

Check my progress

Test your understanding

Below is a true/false question to reinforce your understanding of this lab's concepts. Answer it to the best of your ability.

Instance ID is used to uniquely identify your instance within the project.TrueFalse

Task 2. Connect to your instance using the mysql client in Cloud Shell

1. In the Cloud Console, click the Cloud Shell icon in the upper right corner.

2. Click Continue.

3. At the Cloud Shell prompt, connect to your Cloud SQL instance by running the following:

gcloud sql connect myinstance --user=root

Click Authorize.

4. Enter your root password when prompted. Note: The cursor will not move.

5. Press the Enter key when you're done typing.

You should now see the mysql prompt.

Task 3. Create a database and upload data

1. Create a SQL database called guestbook on your Cloud SQL instance:

CREATE DATABASE guestbook;

Test completed task

Click Check my progress to verify your performed task. If you have successfully created a custom database on the Cloud SQL instance, you will see an assessment score.

Create a database.

Check my progress

2. Insert the following sample data into the guestbook database:

USE guestbook;
CREATE TABLE entries (guestName VARCHAR(255), content VARCHAR(255),
    entryID INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(entryID));
    INSERT INTO entries (guestName, content) values ("first guest", "I got here!");
INSERT INTO entries (guestName, content) values ("second guest", "Me too!");

3. Now retrieve the data:

SELECT * FROM entries;

You should see:

+--------------+-------------------+---------+
| guestName    | content           | entryID |
+--------------+-------------------+---------+
| first guest  | I got here!       |       1 |
| second guest | Me too!           |       2 |
+--------------+-------------------+---------+
2 rows in set (0.00 sec)
mysql>

Solution of Lab

export ZONE=

curl -LO raw.githubusercontent.com/quiccklabs/Labs_solutions/master/Cloud%20SQL%20for%20MySQL%20Qwik%20Start/quicklabgsp151.sh
sudo chmod +x quicklabgsp151.sh
./quicklabgsp151.sh