B
B
Boris2021-03-18 17:17:47
MySQL
Boris, 2021-03-18 17:17:47

How to connect MySQL database in PhpStorm?

Good day everyone!
Faced such problem:
If it is important, I use local OpenServer, in the same place and a file with a database.
C:\Users\Boris\Desktop\OpenServer\OSPanel\domains\mysite.local\db\web.sql
I want to run "qwery tool" in PhpStorm IDE instead of CMD.
But nothing works according to the instructions, all sorts of jokes and jokes are written on the Internet, but there is no sense. Maybe I'm really dumb ... if anyone knows, I would appreciate the help!
PS: the MySQL driver installed like, but the error crashes during a test connection.
6053609a1f5f2016859883.jpeg
605360a6408e2669129222.jpeg
605360d061afd809098875.jpeg

Answer the question

In order to leave comments, you need to log in

1 answer(s)
B
Boris, 2021-03-18
@BorisFX107

Found a solution, you never know who will come in handy:
The situation is as follows.
Initially, I created a database in OpenServer in PhpMyAdmin.
In order to make requests and manipulations in Storm, of course, you need to connect, and then there was a problem.
It was connected with timezone.
SOLUTION:
6053bcb60f207789804847.jpeg
In the tab "Advanced" found "Name" - "serverTimezone" and registered UTC.
OR ! I also checked this method works:
6053be78dbcdb764235943.jpeg
Here in the URL field I registered an additional parameter: serverTimezone=UTC .

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question