How to set timezone in mysql?

Question

MySQL

Decided to set the timezone in mysql. added lines to my.cnf
[mysqld]
default-time-zone='+03:00'
But all the old data that was on the server also had dates (timestamp) shifted, which I would not like, can this problem be solved somehow? or as an option to change the type of timestamp to datetime?

Answer 1

when connecting to the database
SET @@session.time_zone = "+00:00";