set mysql timezone code example

Example 1: set database timezone mysql

SET GLOBAL time_zone = '+8:00';
SET GLOBAL time_zone = 'Europe/Helsinki';
SET @@global.time_zone = '+00:00';

Example 2: how to set global time_zone in mysql

SET GLOBAL time_zone = timezone;

eg: SET GLOBAL time_zone = 'Asia/Kolkata';

Example 3: set database timezone mysql

# SET ON /etc/my.cnf

default-time-zone='+00:00'