Answer the question
In order to leave comments, you need to log in
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.
Answer the question
In order to leave comments, you need to log in
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:
In the tab "Advanced" found "Name" - "serverTimezone" and registered UTC.
OR ! I also checked this method works:
Here in the URL field I registered an additional parameter: serverTimezone=UTC .
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question