Pycharm (pycharm Community Edition 2017.2.1 x6)
Mysql (5.7.26)
Windo10

1, install the database: Pycharm internal Settings for installation: File -> Settings -> Plugins -> search box input the database Navigator to download a plug-in, the installation is complete restart Pycharm,

2, in the database connection mysql: pycharm in view - Tool Windows - DB Brwoser, fill in the user + password content, test the connection;

Error 001:
The server time zone value '? D1u + e x? E +?? 'is unrecognized or represents more than one time zone...

The reason is:
Parts of mysql version of the time zone and our system do not match the time zone,

Solution: 01
CMD - mysql -u root -p - 1, show variables like '% time_zone %'; 2, the set global time_zone='+ 8; Ok (defect is every start to set up again)

Solution 02:
Close the mysql - in my. In the ini file (mysqld) below to add "# synchronization time zone
Default - time - zone='+ 08:00 ", then it is ok to start the mysql, (advantage is once and for all)

CodePudding user response:

Can the attached figure, thank you, my, ini

CodePudding user response:

reference 1st floor qq_31756707 response:

attached figure it, thank you, where is my, ini

Open in a text