FreeBSD & MySQL UTC

After doing a fresh install, load the UTC zone:

$ cd /usr/share/zoneinfo
$ mysql_tzinfo_to_sql  UTC UTC | mysql -u root mysql

Edit the /etc/my.cnf:

[mysqld]
default-time-zone='UTC'

This will set the default timezone on the server to be UTC

To get current timezone of the mysql you can do following things:

mysql> SELECT @@global.time_zone, @@session.time_zone;