Connect to Cloud SQL for MySQL from Cloud Shell
This page shows you how to create and connect to a MySQL instance and perform basic SQL operations by using the Google Cloud console and a client. The resources created in this quickstart typically cost less than a dollar, assuming you complete the steps, including the cleanup, in a timely manner.
To follow step-by-step guidance for this task directly in the Google Cloud console, click Guide me:
Before you begin
- Sign in to your Google Cloud account. If you're new to Google Cloud, create an account to evaluate how our products perform in real-world scenarios. New customers also get $300 in free credits to run, test, and deploy workloads.
-
In the Google Cloud console, on the project selector page, select or create a Google Cloud project.
-
Make sure that billing is enabled for your Google Cloud project.
-
In the Google Cloud console, on the project selector page, select or create a Google Cloud project.
-
Make sure that billing is enabled for your Google Cloud project.
-
Enable the necessary Google Cloud APIs.
Console
In the Google Cloud console, go to the APIs page.
Enable the Cloud SQL Admin API.gcloud
Click the following button to open Cloud Shell, which provides command-line access to your Google Cloud resources directly from the browser. Cloud Shell can be used to run the
gcloud
commands presented throughout this quickstart.Run the
gcloud services enable
command as follows using Cloud Shell to enable the APIs required for this quickstart.:gcloud services enable sqladmin.googleapis.com
This command enables the following APIs:
- Cloud SQL Admin API
Create a Cloud SQL instance
In this quickstart, you use the Google Cloud console. To use the gcloud CLI, cURL, or PowerShell, see Create instances.
-
In the Google Cloud console, go to the Cloud SQL Instances page.
- Click Create Instance.
- Click Choose MySQL.
- Enter
myinstance
for Instance ID. - Enter a password for the
root
user. Click Create.
You're returned to the instances list. You can click the new instance right away to see the details, but it won't be available for other operations until it initializes and starts.
Connect to your instance
In this quickstart, we'll use the mysql client in Cloud Shell to connect to your instance.
- Optional: If you're running a local instance of MySQL, stop it before
connecting to your Cloud SQL instance. Otherwise, you might encounter
errors such as
address already in use
. In the Google Cloud console, click the Cloud Shell icon () in the upper right corner.
When Cloud Shell finishes initializing, a message, such as the following one, appears: following one, appears:
Welcome to Cloud Shell! Type "help" to get started. Your Cloud Platform project in this session is set to sample-project. Use "gcloud config set project [PROJECT_ID]" to change to a different project. username@sample-project:~ (sample-project)$
At the Cloud Shell prompt, connect to your Cloud SQL instance. Use the
gcloud sql connect
command as follows. Replace the instance name if your instance name is different.gcloud sql connect myinstance --user=root
- Click Authorize in the message box to authorize Cloud Shell to make API calls.
A message indicates that your IP is being allowlisted for incoming connections, after which you're prompted to enter your password.
Enter your root password.
The
mysql
prompt appears.
Create a database and upload data
- Create a SQL database on your Cloud SQL instance:
CREATE DATABASE guestbook;
- Insert sample data into the guestbook database:
USE guestbook; CREATE TABLE entries (guestName VARCHAR(255), content VARCHAR(255), entryID INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(entryID)); INSERT INTO entries (guestName, content) values ("first guest", "I got here!"); INSERT INTO entries (guestName, content) values ("second guest", "Me too!");
- Retrieve the data:
SELECT * FROM entries;
The result is:+--------------+-------------------+---------+ | guestName | content | entryID | +--------------+-------------------+---------+ | first guest | I got here! | 1 | | second guest | Me too! | 2 | +--------------+-------------------+---------+ 2 rows in set (0.00 sec) mysql>
Clean up
To avoid incurring charges to your Google Cloud account for the resources used on this page, follow these steps.
-
In the Google Cloud console, go to the Cloud SQL Instances page.
- Select the
myinstance
instance to open the Instance details page. - In the icon bar at the top of the page, click Delete.
- In the Delete instance window, type your instance's name and then click Delete.
Optional cleanup steps
If you're not using the APIs that were enabled as part of this quickstart, you can disable them.
- APIs that were enabled within this quickstart:
- Cloud SQL Admin API
In the Google Cloud console, go to the APIs page.
Select the Cloud SQL Admin API and then click the Disable API button.
What's next
Learn about creating Cloud SQL instances.
Learn about creating MySQL users and databases for your Cloud SQL instance.
See the Cloud SQL pricing information.
In this quickstart you connected to the instance by using Cloud Shell. Learn about all of the connectivity options in Cloud SQL. How you connect depends on your networking configuration, such as if your Cloud SQL instance has a public or private IP address. See how to configure your Cloud SQL instance with a public IP and a private IP address.
Learn about connecting to a Cloud SQL instance from other Google Cloud applications: