New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

How to Connect to Aurora RDS MySQL Database with DataGrip #17

Open
jimmyjuarez opened this Issue Dec 23, 2017 · 1 comment

Comments

Projects
None yet
2 participants
@jimmyjuarez

jimmyjuarez commented Dec 23, 2017

I'm having trouble connecting to the MySQL database with JetBrains DataGrip, here are the "Data Source Properties":

GENERAL
Host: (My Cluster Endpoint)
Port: 3306
Database: (My Database Name)
User: (My Database Username)
Password: (My Database Password)
URL: (My Cluster Endpoint):3306/(My Database Name)
general

SSH/SSL
Use SSH Tunnel: FALSE
Proxy Host: Undefined
Proxy User: Undefined
Auth Type: Undefined
Proxy Password: Undefined

Use SSL: TRUE
CA File: Undefined
Client Certificate File: Undefined
Client Key File: (My_Security_Group_PEM_File.pem)
ssh-ssl

I can't figure out what I'm doing wrong here, please help.

@RGuilfoyle

This comment has been minimized.

RGuilfoyle commented Dec 24, 2017

Jimmy, I expect you are connecting remotely, from your own PC or Mac. The default Firewall rules will not allow Database access directly from the internet (this is almost never wise). However, the tool you are using appears to have SSH tunnel support. You should be able to use a Bastion host to reach the database.
Try;
Use SSH Tunnel: True
Proxy Host: Bastion Host/ Public IP
Proxy User: ec2-user
Auth Type: SSH Key
Proxy Key: My_Security_Group_PEM_File.pem (assuming this allows access to the Bastion)
Don't use SSL as this is Client certificate authentication, which is not used in this case.
For the database itself you should use password access, with the database username and password you chose when launching the templates.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment