Setting MYSQL time_zone

script.sql

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

-- change the mysql server time zone
SET GLOBAL time_zone = '-05:00';
set time_zone = '-05:00';

-- other option to change the configuration
-- In the file "my.cnf" in the [mysqld] section
-- default-time-zone='-05:00'

select now();