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

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!!!

Sorry, only registered users may post in this forum.