2.7.2.5. DataGrip

DataGrip Is a commercial IDE tool for working with databases.

To connect to the database, in the left pane, select in the project “Database", Click"+"And in the drop-down list select"Data Source → MySQL»: In the window that opens, specify the connection data and click "OK»:

1. «Name"- specify an arbitrary name for the connection being created.
2. «Driver"- select"MySQL». (If an error occurs "Could not create connection to database server"Try changing the driver to"MySQL 5.1»).
3. «Host"- specify the host from data to connect to the database.
4. «Port"- make sure the default port is specified 3306.
5. «User"- specify the login from data to connect to the database.
6. «Password"- enter the password from data to connect to the database.
7. «Database»- specify the name of the database from data to connect to the database.
8. Click "Test Connection»To check the connection.
   If the test connection was successful, you will see something like the following:

If the error "Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTimezone' property manually", Then in the connection settings on the"Advanced"For the parameter"Server Timezone"Set to"Europe/Kiev"(Or another time zone you need). (The time zone is in the format +03:00 or Europe/Kiev.).