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
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 2014.1 Timezone Database internal Default timezone Europe/Paris
2014.1 means timezonedb version is year 2015 5th edition.
Please note that if you get the following result
0.systemIt 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.5 Timezone Database external Default timezone Europe/Paris