check timezone of mysql database
SELECT @@system_time_zone as tz;
set database timezone mysql
SET GLOBAL time_zone = '+8:00'; SET GLOBAL time_zone = 'Europe/Helsinki'; SET @@global.time_zone = '+00:00';
Source: stackoverflow.com
check mysql timezone
#The query below returns the timezone of the current session. select timediff(now(),convert_tz(now(),@@session.time_zone,'+00:00'));
set database timezone mysql
# SET ON /etc/my.cnf default-time-zone='+00:00'
Source: stackoverflow.com
mysql timezone
[mysqld] default-time-zone = "+00:00"
Source: phoenixnap.com