2.6.1.2.5. DataGrip

DataGrip — a commercial IDE tool for working with databases.

Set up

To connect to the database, in the left panel, select "Database" in the project, click "+", and select "Data Source → MySQL" from the drop-down list: In the window that opens, enter your connection details and click "OK":

  1. "Name" — enter any name you want for the connection you are creating.
  2. "Driver" — select "MySQL". (If you receive the error "Could not create connection to database server", try changing the driver to "MySQL 5.1".)
  3. "Host" — specify the host from the data for connecting to the database.
  4. "Port" — make sure the default port 3306 is specified.
  5. "User" — enter the username from the data for connecting to the database.
  6. "Password" — enter the password from the data for connecting to the database.
  7. "Database" — enter the database name from the data for connecting to the database.
  8. Click "Test Connection" to check your connection.
    If the connection test is successful, you should see something like this:

If you see the error "Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTimezone' property manually", go to the "Advanced" tab in the connection settings and set the "Server Timezone" parameter to "Europe/Kiev" (or another time zone of your choice). (The time zone is specified in the format +03:00 or Europe/Kiev.)

Content