Requirements

mySQL time zones installation:

You have to follow this topic: https://dev.mysql.com/doc/refman/5.6/en/time-zone-support.html#time-zone-installation

MariaDB time zones installation:

You may follow the same topic than for MySQL, and select either the zipped tables or the zipped SQL statements. To choose, just check the type of the time_zone tables in mysql DB : if it's MyISAM then use the zipped tables, it it's InnoDB then use zipped SQL statements.

PHP time zones installation:

Timezonedb is already integrated but may be not up-to-date. You may check that using phpinfo() function. phpinfo() should return something like that:

date
date/time support  enabled  
"Olson" Timezone Database Version  2015.3
Timezone Database  internal  
Default timezone  Europe/Paris 

2015.3 means timezonedb version is year 2015 3rd edition.

Please note that if you get the following result

0.system

It means that your PHP use the system timezone database so ensure it is up-to-date (tzdata package). The pecl/timezonedb doesn't make sense in this case.

If your PHP doesn't use the tzdata package then you may check this to update PHP timezonedb: https://pecl.php.net/package/timezonedb/

Don't forget to update your "php.ini" to enable this updated module, otherwise you'll get the old one.

and in this case, you should get something like

date

date/time support  enabled  
"Olson" Timezone Database Version  2015.3  
Timezone Database  external  
Default timezone  Europe/Paris