We use cookies
We use cookies to optimize our website. By continuing to browse the site, you agree to our use of cookies.
Control panel
  • Русский
  • Українська
  • English
  • UAH
  • USD
  • RUB
  • EUR
  • 0-800-307-307 Hotline
  • +38 (044) 392-74-33 Kiev
  • +38 (057) 728-39-00 Kharkiv
  • +38 (056) 794-38-31 Dnipro
  • +38 (032) 229-58-93 Lviv
  • +38 (048) 738-57-70 Odessa
  • +38(093) 170-15-42  Life
  • +38 (067) 400-88-44 Kievstar
  • +1(888)393-24-51  USA, Toll free
  • +44(131)507-01-14  Great Britain
  • +7 (499) 348-28-61 Moscow

2.7.2.5. DataGrip

DataGrip

Commercial IDE tool for working with databases.

Official site

To connect to the database, in the left pane, select “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.).