June 2018
Intermediate to advanced
372 pages
8h 44m
English
Content preview from Google Cloud Platform for Architects
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Creating a database in a Cloud SQL instance
Time to get hands on with Cloud SQL. Let's start with creating a database:
- On the command line simply type gcloud beta sql connect, specify the name of your Cloud SQL instance, and specify the user you want to connect as.
- Here we just have one user, the root user. You will be asked for your root user password before the connection is successful. You will see the MySQL prompt when you log into your MySQL instance. In order to allow Cloud Shell to connect to your MySQL instance, MySQL whitelists the IP address of your Cloud Shell instance temporarily. Cloud Shell instances are ephemeral (destroyed once we close them), so when you reconnect your session changes and your IP address might change ...