how to set timezone of mysql?

Question

on one server,when I run:

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2009-05-30 16:54:29 | 
+---------------------+
1 row in set (0.00 sec)

on another server:

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2009-05-30 20:01:43 | 
+---------------------+
1 row in set (0.00 sec)

Answer 1

To set it for the current session, do:

SET time_zone = timezonename;