Page 1 of 1

Illegal or unknown default time zone - mysql

PostPosted: 09. January 2010 16:55
by demon510
mysql wont start up so I searched the logs and found out why. 100109 9:33:05 [ERROR] Fatal error: Illegal or unknown default time zone 'America/Chicago' Anyone have a solution? I have read that I can comment out a line in the my.cnf but I cannot even find this file.

Re: Illegal or unknown default time zone - mysql

PostPosted: 09. January 2010 17:02
by demon510
I found the location of the file and it is in xampp/mysql/bin/my.ini and I commented out the line but does anyone know the correct information to place in their?

Re: Illegal or unknown default time zone - mysql

PostPosted: 09. January 2010 17:08
by demon510
ok I was able to figure it out.

In the my.ini file you can change the following line:

default-time-zone = "-06:00" <-- change to your appropriate GMT Zone. Mine is Central Time Zone or you can comment out this line so you can get mysql fired up till you resolve the issue.

Re: Illegal or unknown default time zone - mysql

PostPosted: 09. January 2010 19:09
by Wiedmann
mysql wont start up so I searched the logs and found out why. 100109 9:33:05 [ERROR] Fatal error: Illegal or unknown default time zone 'America/Chicago'

What's your XAMPP and MySQL version?