How can I change the timezone of my MySQL database?

Your server's Global time configuration cannot be changed, but you can use per-connection time zones. Here's an example of SQL command that you can phpMyAdmin that sets the timezone to Asia/Bangkok:

SET time_zone = 'Asia/Bangkok';

A list of available timezones can be found here: http://www.php.net/manual/en/timezones.php

More useful articles: