MySQL default time zone
Posted by: rhf (---.knology.net)
Date: May 10, 2012 03:59AM

How do I set the default timezone for the WAMP MySQL server.
Note: I am referring to MySQL, not Php.
When I enter either of the options below in my.ini
default-time-zone = "US/Central"
or
default-time-zone = "America/Chicago"
I get the mysql.log error:

[ERROR] Fatal error: Illegal or unknown default time zone 'US/Central'
or
[ERROR] Fatal error: Illegal or unknown default time zone 'America/Chicago'

Any suggestions?

Thanks,
Bob

Options: ReplyQuote
Re: MySQL default time zone
Posted by: RiggsFolly (---.as13285.net)
Date: May 21, 2012 12:06PM

Try

default-time-zone = '+6:00'


The value can be given as a named time zone, such as 'Europe/Helsinki', 'US/Eastern', or 'MET'.
BUT
Named time zones can be used only if the time zone information tables in the mysql database have been created and populated.
Population is not done automatically!!!

Options: ReplyQuote


Sorry, only registered users may post in this forum.