°Ë¸ö²½ÖèÐÞ¸ÄlinuxʱÇø

For ubuntu: [1]http://webonrails.com/2009/07/15/change-timezone-of-ubuntu-machine-from-command-line/
2
Logged in as root, check which timezone your machine is currently using by executing `date`. You'll see something like Mon 17 Jan 2005 12:15:08 PM PST, PST in this case is the current timezone.
3
Change to the directory /usr/share/zoneinfo here you will find a list of time zone regions.Choose the most appropriate region, if you live in Canada or the US this directory is the "America" directory.
4
If you wish, backup the previous timezone configuration by copying it to a different location. Such as
mv /etc/localtime /etc/localtime-old
5
Create a symbolic link to the appropriate timezone from /etc/localtime. Example:
ln -sf /usr/share/zoneinfo/Europe/Amsterdam /etc/localtime
6
If you have the utility rdate, update the current system time by executing
/usr/bin/rdate -s time-a.nist.gov
7
Set the ZONE entry in the file /etc/sysconfig/clock file (e.g. "America/Los_Angeles")
8
Set the hardware clock by executing:
/sbin/hwclock --systohc
2.ÐÞ¸ÄmysqlʱÇø
MySQL ʱÇøĬÈÏÊÇ·þÎñÆ÷µÄʱÇø¡£
¿ÉÒÔͨ¹ýÒÔÏÂÃüÁî²é¿´SQL´úÂëmysql> show variables like '%time_zone%';   +------------------+--------+   | Variable_name    | Value  |   +------------------+--------+   | system_time_zone | CST    |    | time_zone        | SYSTEM |    +------------------+--------+   2 rows in set (0.00 sec)   ¿ÉÒÔͨ¹ýÐÞ¸Ämy.cnf
ÔÚ [mysqld] ֮ϼÓ
default-time-zone=timezone 
À´ÐÞ¸ÄʱÇø¡£È磺
default-time-zone = '+8:00'
¸ÄÁ˼ǵÃÖØÆômsyqlà¸
×¢ÒâÒ»¶¨ÒªÔÚ [mysqld] ֮ϼӠ£¬·ñÔò»á³öÏÖ unknown variable 'default-time-zone=+8:00'
ÁíÍâÒ²¿ÉÒÔͨ¹ýÃüÁî set t