我如何确保我的服务器和 MYSQL 具有相同的时区？

Question 1

您没有提到操作系统，但对于 RedHat 衍生系统，应该system-config-time设置时区。对于 MySQL，请阅读此 URL：

http://dev.mysql.com/doc/refman/5.1/en/mysql-tzinfo-to-sql.html

总而言之，我必须从操作系统加载时区：

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql

在``/etc/my.cnf`部分中添加以下行mysqld并重新启动：

default-time-zone='Pacific/Honolulu'

鲍勃是你的叔叔：

mysql> SELECT @@global.time_zone, @@session.time_zone;
+--------------------+---------------------+
| @@global.time_zone | @@session.time_zone |
+--------------------+---------------------+
| Pacific/Honolulu   | Pacific/Honolulu    | 
+--------------------+---------------------+
1 row in set (0.00 sec)

我尝试了以下测试脚本：

import MySQLdb
import os
import re
import time
import datetime
from datetime import date, datetime, time

db = 'test'
dbhost = 'localhost'
dbport = 3306
dbuser = 'test'
dbpass = 'test'

start_time = datetime.today()

con = MySQLdb.connect(host=dbhost, port=dbport, user=dbuser, passwd=dbpass, db=db)
cursor = con.cursor()
sql = "SELECT current_time;"
cursor.execute(sql)
list = cursor.fetchall()
con.close()

print "------------------------------------------------------------------------------------"
print "Python time is: "
print start_time
print
print "MYSQL time is:"
for result in list:
    print result[0]
print "--

----------------------------------------------------------------------------------”

输出：

------------------------------------------------------------------------------------
Python time is: 
2010-03-30 22:29:19.358184

MYSQL time is:
22:29:19
------------------------------------------------------------------------------------

您是否已填充时区表：

mysql> use mysql;
mysql> select count(*) from time_zone;
+----------+
| count(*) |
+----------+
|     1678 | 
+----------+
1 row in set (0.00 sec)

Answer