UTC time showing wrong
mysql need the mysql.timezone* tables to be filled properly for explicit and implicit TZ conversions. They are not created and filled automatically on installation. 


Install fresh timezones on your host. Usually they are provided by zoneinfo package.
Run mysql_tzinfo_to_sql /path/zoneinfo | mysql -u root mysql


Refer the mysql manual for further information: https://dev.mysql.com/doc/refman/5.5/en/mysql-tzinfo-to-sql.html