Wrong timezone of MySQL server
A widely used tool for visual exploration of scientific literature.
Brought to you by:
citespace
Menu
▾
▴
Dear professor Chen,
I encountered a problem with new versions of Citespace (since Citespace 5.8.R1 build from 23.05.21). The problem is that Citespace does not connect to the MySQL server (Image 1), even though the server is operating and credentials are correct. The console says that the problem is the time zone of the MySQL server (Image 2). I tried to set up the default time zone in the MySQL.ini file, but it did not help. Maybe you know the solution to this problem. I would much appreciate it.
Best regards,
Glib Voloskyi
The following may be useful, e.g., default-time-zone='+00:00'
https://stackoverflow.com/questions/930900/how-do-i-set-the-time-zone-of-mysql
Thank you for your reply. However, I could not find my.cnf file in the MySQL directory. The manual mentions that it is possible to create my.cnf and edit it afterwards, but I think I have found a simpler solution. In case, someone has a similar problem, here is the solution that worked for me.
The problem arises due to the winter/summer time transition. When your system switch to summertime, it sets up 'FLE Summer time value'. This value is unrecognized by MySQL, so the trick is to change it.
1. For this sake, install a workbench relevant to your version of MySQL
2. Start the workbench and open a control page for your server
3. Go to "Status and system variables" (screen 1)
4. Go to the system variables tab, and type "zone" in the search field (screen 2)
5. Your time_zone value will show "system". Change it to the relevant timezone (screen 3)
Thanks Glib for sharing this.