Using Cloud SQL

To start using Cloud SQL, we will now provision an instance by performing the following steps:

1. From the navigation menu, select SQL:

   Figure 11.13 – SQL menu option

2. From the Cloud SQL Instances page, click CREATE INSTANCE:

   Figure 11.14 – CREATE INSTANCE

3. From the Create an instance page, click Choose MySQL:

   Figure 11.15 – Choose MySQL

4. Provide an Instance ID and Root password, select the Region, and click Show configuration options:

   Figure 11.16 – Show configuration options

5. In the Connectivity section, select Private IP and unselect Public IP:

   Figure 11.17 – Cloud SQL network settings

6. In the Flags section, click Add item:

   Figure 11.18 – Add item to flags

7. Enter sql_mode in the Database flags field and select sql_mode:

   Figure 11.19 – sql_mode

8. Enter the following in the sql_mode field: ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, ALLOW_INVALID_DATES, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER,...