How to update/install zoneinfo timezone database on CentOS?

Solution 1:

Don't update the zoneinfo database manually. Just install the updates which are already provided for you by EL/CentOS in the tzdata package:

# yum update tzdata

Also note that MySQL keeps its own internal time zone tables, separate from the system timezone database. To update MySQL's internal time zone tables, run the mysql_tzinfo_to_sql script which came with MySQL.