areast wrote:
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.