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
From the navigation pane, go to Protect > Databases.
The Instances page appears.
Click Add instance, and then select Cloud database service.
The Add Cloud DB instance dialog box appears.
From the Select vendor list, select a vendor where you want to create an instance.
From the Database service list, select MySQL.
From the Cloud account list, select a hypervisor.
From the Backup plan list, select a server plan.
From the Instance name list, select an instance.
In the Database user box, type the user name to access the Cloud SQL for MySQL application.
In the Password box, type the password to access the Cloud SQL for MySQL application.
If SSL is enabled on the cloud, move the Use SSL options toggle key to the right, and then complete the following tasks:
In the SSL CA file box, provide SSL CA file path in the proxy computer.
In the SSL Key file box, provide SSL key file path in the proxy computer.
In the SSL Cert file box, provide SSL certificate file path in the proxy computer.
Click Add.
Results
The new instance contains a default database group. The default database group includes all the data in the Google Cloud SQL for MySQL database. You cannot delete the default database group.