Home:ALL Converter>Connecting to an SSL-Only Cloud SQL database through Cloud Shell

Connecting to an SSL-Only Cloud SQL database through Cloud Shell

Ask Time:2020-07-29T16:25:59         Author:James Hunt

Json Formatter

So obviously I have my certificates for connecting to the database externally, but how do I connect to an SSL-only database using Cloud Shell?

If I tap "Connect using Cloud Shell" on the Cloud SQL page and use their pre-filled Shell command:

gcloud sql connect INSTANCENAME --user=root --quiet

It won't let me log in using my root password, and as far as I can see there are no options to supply certificates like there is when just using a cli mysql client. If I turn forced SSL off, I can connect correctly. Am I missing something obvious?

Author:James Hunt,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/63149416/connecting-to-an-ssl-only-cloud-sql-database-through-cloud-shell
yy