Cacher is the code snippet organizer for pro developers

-- Чтобы проверить текущую временную зону, нужно выполнить команду:
SHOW VARIABLES LIKE '%zone%';
SELECT @@global.time_zone, @@session.time_zone;

-- http://nagg.ru/2012/12/mysql-obnovlenie-timezone/


------------------------------------------------

-- поменять время и без перезагрузки:
/Applications/MAMP/Library/bin/mysql_tzinfo_to_sql /usr/share/zoneinfo | /Applications/MAMP/Library/bin/mysql -p -u root mysql


------------------------------------------------

-- Warning: Unable to load ‘/usr/share/zoneinfo/+VERSION’ as time zone. Skipping it.
-- After deleting (or temporarily moving) the +VERSION file from the zoneinfo directory, I was able to install the time zones in MySQL without a problem.

-- http://www.larryullman.com/2011/05/27/utc-and-time-zone-support-in-mysql/