Google Cloud SQL: Relational Databases in Google's Cloud

1. Sign up

   1. If you don't already have one, sign up for a Google account .
   2. Create a Cloud SQL enabled project via the Google Developers Console .
   3. Enable billing from your project's Billing & Settings tab.

2. Create and configure a Google Cloud SQL instance

   Google Developers Console

   1. In the left sidebar, click STORAGE , and then click Cloud SQL .
   2. Click New Instance .
   3. Enter a name for the instance and click Confirm .
   4. After the instance is running, click Access Control and then:
      1. Click Request an IP Address and use this as your instance-IP in Step 3.
      2. In the Set Root Password box, enter a root password, and click Set .
      3. Click Add Authorized Network and add your IP address .

   Cloud SQL Command Line

   1. Install the Cloud SDK .
   2. Use the following command to create an instance:

      $ gcloud sql instances create your-instance-name

   3. Modify the instance and grant access to your IP address :

      $ gcloud sql instances patch your-instance-name --authorized-networks your-ip-address

   4. Set the root password for the instance:

      $ gcloud sql instances set-root-password your-instance-name --password-file path-to-file

   5. Assign an IP address to the instance and retrieve it:

      $ gcloud sql instances patch your-instance-name --assign-ip
      $ gcloud sql instances get your-instance-name

      In the output, find the "ipAddress" field. Use this as your instance-IP in Step 3.

3. Connect to the instance

   1. Install the MySQL Client .
   2. Connect to the instance.

      $ mysql --host=instance-IP --user=root --password

   3. Create a database and table, enter some data, and query the data.

      CREATE DATABASE guestbook;
      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", "hello world!");
      
      SELECT * FROM entries;

4. What next?

   • Read more about the Google approach to security .
   • Review the Overview page to learn more about the features of Cloud SQL.
   • Try out the more in-depth Getting Started tutorial.
   • Learn how to use the Google Developers Console for common tasks.

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 3.0 License , and code samples are licensed under the Apache 2.0 License . For details, see our Site Policies .