ERROR: Your MySQL TimeZone database is not populated

[westsyde]

Received this error on upgrade from 1.0.2 to 1.0.3

What do I need to change to get it to pass the pre-install check?



mysql> show variables like '%time_zone%';
+------------------+-----------------------+
| Variable_name | Value |
+------------------+-----------------------+
| system_time_zone | Pacific Standard Time |
| time_zone | SYSTEM |
+------------------+-----------------------+
2 rows in set (0.00 sec)

mysql>

[zetoo]

I dont know if this may help you. But I solved my timezone table by:
- Downloading timezone_2016j_posix_sql.zip in http://dev.mysql.com/downloads/timezones.html
- Then go to cmd and type this mysql -u root mysql < file_name
- Restart server

Steps above came from this link https://dev.mysql.com/doc/refman/5.7/en ... pport.html

[jblack]

The above is missing some steps.

http://dev.mysql.com/downloads/timezones.html

Download the appropriate file. Then unzip the .sql file.

From cmd run mysql -u root -p mysql < file_name.sql
Then type mysql -u root -p and enter your root password for MySQL.

Next type: grant select on mysql.time_zone_name to 'cactiuser'@'localhost' identified by 'cactiuser';
Then type: flush priveleges;

No need to reboot. If you refresh the page you shouldn't get the error again.

[loki6000]

Zetoo, life saver been all afternoon researching !!!! this fixed it. I already had the file but all instructions were off !!

Many thanks

[netniV]

If the instructions are off, try submitting an update on our documentation repo.