Illegal or unknown default time zone - mysql

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Illegal or unknown default time zone - mysql

Postby demon510 » 09. January 2010 16:55

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.
demon510
 
Posts: 4
Joined: 09. January 2010 16:20

Re: Illegal or unknown default time zone - mysql

Postby demon510 » 09. January 2010 17:02

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?
demon510
 
Posts: 4
Joined: 09. January 2010 16:20

Re: Illegal or unknown default time zone - mysql

Postby demon510 » 09. January 2010 17:08

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.
demon510
 
Posts: 4
Joined: 09. January 2010 16:20

Re: Illegal or unknown default time zone - mysql

Postby Wiedmann » 09. January 2010 19:09

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?
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 101 guests