[Solved] - MySQL TimeZone Database Error

[areast]

Did search alot and still could not fix by myself

I done below step still not work
under php.ini
[Date]
date.timezone="Asia/Hong_Kong"

under mysql -> bin -> my.ini
[mysql]
[Date]
;Defines the default timezone used by the date functions
Date.timezone = Asia/Hong_Kong

Saw few post about "mysql_tzinfo_to_sql — Load the Time Zone Tables"
But I have no idea how to start? (is that a .sql table import to?)
Have some expert can sharp the full step how to config ?

[netniV]

.

[tertius]

Saw few post about "mysql_tzinfo_to_sql — Load the Time Zone Tables"
But I have no idea how to start? (is that a .sql table import to?)
Have some expert can sharp the full step how to config ?

The time zone table in mysql is a different thing than setting a timezone in php.ini.
That table has to be filled with the all of the timezone information that is installed on the system. There is a program that reads this data and produces a *.sql file with INSERT INTO statements to populate that table.
The program is mysql_tzinfo_to_sql and is contained in the mysql-server package (or mariadb-server, if you use mariadb instead of mysql).
Call "man mysql_tzinfo_to_sql" to get command line parameter help. It is probably called as "mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql" to populate the table in one step, but depending on your system the directory may vary or the mysql user.

[areast]

Hi Tertius
Thanks for explain

I did solve "MySql timezone" with below step

http://www.geeksengine.com/article/popu ... mysql.html

Download the "timezone_2018c_posix" and paste under MySql -> Data