Loading...

Adding an Instance for Google Cloud SQL for MySQL

To manage a database, you can either use an existing instance or add a new instance.

Before You Begin

Your Google account must contain the following permissions to access the Google resources:

Role

Title

Description

Permissions

Lowest Resource

roles/cloudsql.viewer

Cloud SQL Viewer

Provides read-only access of Cloud SQL resource.

cloudsql.backupRuns.get

cloudsql.backupRuns.list

cloudsql.databases.get

cloudsql.databases.list

cloudsql.instances.export

cloudsql.instances.get

cloudsql.instances.list

cloudsql.instances.listServerCas

cloudsql.sslCerts.get

cloudsql.sslCerts.list

cloudsql.users.list

resourcemanager.projects.get

resourcemanager.projects.list

serviceusage.quotas.get

serviceusage.services.get

serviceusage.services.list

Project

Procedure

  1. From the navigation pane, go to Protect > Databases.

    The Instances page appears.

  2. Click Add instance, and then select Cloud DB.

    The Add Cloud DB instance dialog box appears.

  3. From the Select vendor list, select a vendor where you want to create an instance.
  4. From the Database engine list, select MySQL.
  5. From the Cloud account list, select a hypervisor.
  6. From the Backup plan list, select a server plan.
  7. From the Instance name list, select an instance.
  8. In the Database user box, type the user name to access the Cloud SQL for MySQL application.
  9. In the Password box, type the password to access the Cloud SQL for MySQL application.
  10. Optional: If SSL is enabled on the cloud, in the SSL CA file box, provide SSL CA file path in the proxy computer.
  11. Click Add.

Results

  • The new instance contains a default subclient.
  • A default database group is created. The default database group includes all the data in the Google Cloud SQL for MySQL database. You cannot delete the default database group.

Last modified: 10/30/2020 10:31:19 AM