Using DataGrip by JetBrains

Background

DataGrip from Jet Brains is a higher end database manipulation tool that has a very generous student license. It has many of the same features that MSSQL Studio has but also runs on Mac and *nix.

There are 3 steps to setting up DataGrip as your DB Tool:

1. Register for the student license
2. Download the trial software and install the software
3. Connecting to the class servers

Registering for the student license

Visit http://www.jetbrains.com/student/ the click on Apply For A Student Pack. Follow the directions and make sure you use your UML email address. You will be sent a license or a login which you can use as long as you’re a student.

Downloading and Installing the Software

1. Visit https://www.jetbrains.com/datagrip/ and click on download.
2. Run the downloaded exe file and follow the instructions. This can be installed anywhere.

Connecting to the Database Servers

1. Open DataGrip and choose New Project
2. Name your new project.
3. Click on File —> Data Sources
4. In the Data Sources and Drivers window, click on the plus sign in upper left hand corner and then choose MySQL.
5. In the Host input type uml2480.cyqisqc1fx3i.us-west-2.rds.amazonaws.com
6. In the port input type 3306
7. In the user input put your username
8. In the password input put your password
9. If you see an indication to Download Missing Driver Files, do so.
10. The URL input should say something like: jdbc:mysql://uml2480.cyqisqc1fx3i.us-west-2.rds.amazonaws.com:3306
11. Test the connection. If it works, you’re done. If not, check all the settings above for accuracy.
12. Click Ok.
13. Choose View —> Database Explorer to open the side panel
14. Expand the tree under uml2480.cyqisqc1fx3i.us-west-2.rds.amazonaws.com in the left panel by clicking on the triangle.
15. You will see several nodes including tables, views and routines.

That’s it for now