0
0
0ralo2020-06-29 18:08:32
MySQL
0ralo, 2020-06-29 18:08:32

How to save Mysql time zone?

I have 2 OSes on my PC, Windows and Linux, both have Mysql. When I change the OS or restart the Mysql service, the time zone gets lost (it gets lost on both Windows and Linux) and Jpa constantly swears at it. I set the zone like this

set @@global.time_zone='+03:00';
или так
set GLOBAL time_zone='+3:00';

But after the restart, the zone itself is set to SYSTEM, but nothing works with this, is it possible somehow to save the zone forever?
@@global.version=8.0.19(windows), don't remember on Linux.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
vader666, 2020-07-10
@0ralo

in mysql config specify default-time-zone='+03:00' or default-time-zone='Europe/Helsinki' tried?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question