Total Page Preview:   000000006546

How to connect cloud SQL using cloudshell in gcp?

In this article I am going to explain how to connect cloud sql in google cloud(gcp) cloudshell command.

 

Syntax 

gcloud sql connect INSTANCE [--database=DATABASE-d DATABASE] [--user=USER-u USER]

 

Example

gcloud sql connect instance1 --user=root

 
Whitelisting your IP for incoming connection for 5 minutes...done.
Connecting to database with SQL user [root].Enter password: type your password then press enter

OUTPUT

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3795
Server version: 5.7.25-google (Google)
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

 

Thank You

About Author

Brijesh Kumar

Database Developer

I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall and Database Migration On-Premise to Azure Cloud.
LinkedIn : https://www.linkedin.com



Comments