MySQL time zone Database

1. Import Time Zone Data to MySQL

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

2. Grant "Select" Privileges to MySQL user

GRANT SELECT ON mysql.time_zone_name TO cacti@localhost;

flush privileges;

Tags