Getting Started with Cloud SQL for MySQL

Create a Cloud SQL instance

1. From the Navigation menu click on SQL.
2. Click Create Instance.
3. Create your instance with the following settings:
   1. Click choose MySQL
   2. Type “myinstance” for Instance ID
   3. In the password field click on the Generate link and the eye icon to see the password. Save the password, you’ll need it in the next section.
      
      Use the default values for the other fields.
4. Click Create Instance.

Connect to your instance using the mysql client in the Cloud Shell

1. In the Cloud Console, click the Cloud Shell icon in the upper right corner.
2. At the Cloud Shell prompt, connect to your Cloud SQL instance by running the following:

   gcloud sql connect myinstance --user=root

3. Click Authorize.
4. Create a SQL database called guestbook on your Cloud SQL instance:

   CREATE DATABASE guestbook;

5. 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!");
   

    

6. Now retrieve the data:

   SELECT * FROM entries;