Skip to content

Instantly share code, notes, and snippets.

@pramoso

pramoso/Ubuntu and mySQL timezone

Last active May 9, 2016 22:34
Show Gist options
  • Save pramoso/f382c4c1ce0c945b515234f630ca2443 to your computer and use it in GitHub Desktop.
Save pramoso/f382c4c1ce0c945b515234f630ca2443 to your computer and use it in GitHub Desktop.
Download ZIP
Linux and mySQL enviroment
Raw
Ubuntu and mySQL timezone
-- Configure Timezones
sudo dpkg-reconfigure tzdata
--Configure NTP Synchronization
sudo apt-get update
sudo apt-get install ntp
--Load TimeZones
mysql_tzinfo_to_sql /usr/share/zoneinfo/|mysql -u root mysql -p
--mySQL
SET GLOBAL time_zone = "America/Bogota";
--Restart mySQL service
sudo service mysql restart
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment