Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

257
Views
How do I connect to a Google Cloud MySQL database using DataGrip?

I am new to Google Cloud SQL and new to DataGrip. I've created a database in GC, but have not modified it yet.

My question is, how do I connect the two?

Specifically, what do I put in the following fields: Host, User and URL

Is the User field my Google username? Or something else?

Thanks in advance for helping a noob!

enter image description here

over 4 years ago · Santiago Trujillo
3 answers
Answer question

0

I haven't used DataGrip before, but my guess is that User is going to be your DB user, Host is going to be the IP for the Cloud SQL instance, and leave URL blank (it says in the UI there that it overrides other settings, so you shouldn't need it).

My suggestion would be to setup the Cloud SQL proxy (documentation on how to do so can be found here: https://cloud.google.com/sql/docs/mysql/connect-admin-proxy). The proxy is a binary that you'll run locally with DataGrip that will handle the communication between you and Cloud SQL.

It will walk you through setting up the proxy, which then will allow you to put 'localhost' in that Host field, while still securely connecting to your Cloud SQL instance without having to worry about other settings. If you don't do it, then you'll need to authorize the IP address of where you're connecting from in the Cloud SQL settings which is less secure.

over 4 years ago · Santiago Trujillo Report

0

Ok, I figured it out, and thought someone out there might find my solution useful.

Host:

The IP for your server: SQL > Overview > Connect to this instance > Public IP Address

User: root

Password: password for your database

URL: jdbc:mysql://xx.xx.xxx.xx:zzzz (x's are your IP, z's are your port number)

over 4 years ago · Santiago Trujillo Report

0

Read DataGrip official documentation about MySQL connections

over 4 years ago · Santiago Trujillo Report
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!