Turns out MySQL doesn’t load timezone info by default! As you can read about here.

To load MySQL timezone info:

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql