Timezone of a mysql server can be set same as of the system in which mysql database is installed.
Login into the mysql console and type the following command.
mysql> SET GLOBAL time_zone = 'SYSTEM';
Offset values can be set as below.
mysql> SET GLOBAL time_zone = '+10:00';
Retrieve the timezone by following command.
mysql> SELECT @@global.time_zone;
Output:
+--------------------+
| @@global.time_zone |
+--------------------+
| SYSTEM |
+--------------------+
1 row in set (0.00 sec)
palatana 