to create a service account in your Google Cloud account and download the content of the JSON file
To generate service-account credentials and view the public credentials already created, follow these steps:
- Open the Service accounts page. When prompted, select a project.
- Click CREATE SERVICE ACCOUNT.
- In the CREATE SERVICE ACCOUNT window, type a name for the service account, and select Furnish a new private key. Click Create.
When you create a key, your new public/private key pair is generated and downloaded to your machine.
To configure access to your Cloud SQL instance
Go to the Cloud SQL Instances page in the Google Cloud Console.
- From the client machine, use What's my IP to see the IP address of the client machine.
- Copy that IP address.
- Go to the Cloud SQL Instances page in the Google Cloud Console.
- Open the instance Overview page, and record the IP address.
- Select the Connections tab.
Under Authorized networks, click Add network and enter the IP address of the client machine.
The IP address of the instance and the mysql client IP address you authorize must be the same IP version: either IPv4 or IPv6.
- Click Done and then Save at the bottom of the page to save your changes.
