Complete the Databases Guided Setup for Google Cloud SQL for MySQL

The Databases guided setup guides you through creating a backup plan and adding a Google Cloud SQL for MySQL.

To complete the guided setup, you need the following information:

• The server name

• The host name

• The credentials that you use to access the server

Procedure

1. From the left navigation pane, go to Guided setup.

   The Welcome page appears.

2. In the Databases tile, click Configure.

   The Configure Database Server page appears.

3. Select Database running in the cloud (PaaS).

4. Select Google Cloud Platform, and then click Next.

   The Configure Google Cloud database page appears.

5. Select MySQL, and then click Next.

   The Configure Google Cloud database - MySQL page appears.

6. In the Plan section, select a backup plan to use for the instance, and then click Next.

   The Cloud Account page appears.

7. From the Cloud account list, select an existing cloud account or add a new cloud account.

8. To add a new cloud account, beside the Cloud account list, click +.

   The Add cloud account appears.

9. In the Name box, type the name for the account.

10. From the Credential list, select an existing credential or add a new credential.

    Steps to add a new credential

    1. Click the + icon beside the Credentials list.

       The Add Credential dialog box appears.

    2. From the Credential Vault list, select a credential vault to store credentials for different types of accounts.

    3. In the Credential name box, enter a name for the credential.

    4. Beside Private key file field, click Upload to choose your JSON key file.

    5. In the Description box, enter the details of the credential.

    6. Click Save.

11. From the Access node list, select an existing credential or add a new access node.

    Steps to add a new access node

    1. Click the + icon beside the Access node list.

       The Add a new Access node dialog box appears.

    2. Select Deploy a new access node button.

    3. From the Platform list, you can select the following two platforms:

       • Windows

       • Linux

    4. In the Instance name list, enter the name of the access node.

    5. In the Project id box, enter the project id.

    6. In the Subnet URL, enter the subnet url or path.

    7. Beside Private key file field, click Upload to choose your JSON key file.

    8. In the VPC Network URL box, enter the url or path of the network.

    9. Click Close.

12. Click Save.

13. Click Next.

    The Cloud database instance details page appears.

14. From the Instance name list, select an instance.

15. Under the Connection details section, enter the following details:

    1. From the Credential list, select a saved credential or add a new credential.
    Steps to add a new credential

    1. Click the + icon beside the Credentials list.

       The Add Credential dialog box appears.

    2. From Account type list, select a database account.

    3. From the Database type, select a database.

    4. From the Credential Vault list, select a credential vault to store credentials for different types of accounts.

    5. In the Credential name box, enter a name for the credential.

    6. If you do not move the Use GCP service account toggle key to right, do the following:

       • In the Username box, enter the user name to access the Google Cloud Database SQL for MySQL application.

       • In the Password box, enter the password to access the Google Cloud Database SQL for MySQL application.

       Note

       If you move the Use GCP service account toggle key to right, you do not need to enter the credential details.

    7. The SSL certificate toggle key is unselected by default. By moving the toggle key to right, you can perform the following actions:

       • In the SSL CA file field, provide the SSL CA file path on the proxy computer.

       • In the SSL Cert file field, provide the SSL certificate file path on the proxy computer.

       • In the SSL Key file field, provide the SSL key file path on the proxy computer.

    8. In the Description box, enter the details of the credential.

    9. Click Save.

16. In the Endpoint box, type the name of the endpoint to connect to the database instance.

17. Click Next.

    The Backup Content page appears.

18. Click Next.

19. To filter the content that is backed up, click Edit, select or clear the tables, and then click Save.

    The Summary page appears.

20. Review the summary, and then click Finish.