How can I change the timezone of my MySQL database?

Modificato il:
timezone mysql change timezone per-connection time zones database timezone

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:

More useful articles:

Rendi qualcuno felice oggi!