Ran into a pinch with my MySQL install on Windows 8.1. It seems the timezone data isn’t installed/loaded into the mysql timezone tables by default.
Here is the quick fix…
- Stop the MySQL Service
- Download the POSIX standard Time zone description tables from http://dev.mysql.com/downloads/timezones.html
- Unzip the downloaded file
- Copy its contents to
C:\ProgramData\MySQL\MySQL Server 5.6\data\mysql
- Start the MySQL Service
There are more details here including directions for populating these tables on Linux.