--default-time-zone=timezone

--default-time-zone='timezone'

SET GLOBAL time_zone=timezone;

SET time_zone=timezone;

SELECT @@global.time_zone, @@session.time_zone;

SELECT CONVERT_TZ('2012-06-07 12:00:00', 'GMT', 'America/New_York');

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql

USE mysql;
SELECT * FROM `time_zone_name`;

TRUNCATE `time_zone` ;
TRUNCATE `time_zone_leap_second` ;
TRUNCATE `time_zone_name` ;
TRUNCATE `time_zone_transition` ;
TRUNCATE `time_zone_transition_type` ;

mysql_config_editor set --login-path=client --host=localhost --user=root --password

[client]
user=root
password=yourMysqlRootPW

set time_zone = '-6:00';

--default-time-zone=timezone

--default-time-zone='timezone'

SET GLOBAL time_zone=timezone;

SET time_zone=timezone;

SELECT @@global.time_zone, @@session.time_zone;