?
首先需要查看mysql的當前時區,用time_zone參數
mysql>?show?variables?like?'%time_zone%';??? +------------------+--------+ |?Variable_name????|?Value??| +------------------+--------+ |?system_time_zone?|?CST????| |?time_zone????????|?SYSTEM?| +------------------+--------+ 2?rows?in?set?(0.00?sec)
1 可以通過修改my.cnf
在 [mysqld] 之下加
default-time-zone=timezone
來修改時區。如:
default-time-zone = ‘+8:00’
修改完了記得記得重啟msyql
注意一定要在 [mysqld] 之下加 ,否則會出現 unknown variable ‘default-time-zone=+8:00’
2 另外也可以通過命令行在線修改
set?time_zone?=?timezone 比如北京時間(GMT+0800) set?time_zone?=?'+8:00';?如下: mysql>?set?time_zone='+8:00'; Query?OK,?0?rows?affected?(0.00?sec) mysql>?show?variables?like?'%time_zone%';??? +------------------+--------+ |?Variable_name????|?Value??| +------------------+--------+ |?system_time_zone?|?CST????| |?time_zone????????|?+08:00?| +------------------+--------+ 2?rows?in?set?(0.00?sec)
?
3 再通過select now()來驗證時區
mysql>?show?variables?like?'%time_zone%';??? +------------------+--------+ |?Variable_name????|?Value??| +------------------+--------+ |?system_time_zone?|?CST????| |?time_zone????????|?+08:00?| +------------------+--------+ 2?rows?in?set?(0.00?sec) mysql>?select?now(); +---------------------+ |?now()???????????????| +---------------------+ |?2013-08-05?10:35:31?| +---------------------+ 1?row?in?set?(0.00?sec) mysql>??set?time_zone='+0:00';Query?OK,?0?rows?affected?(0.00?sec)
mysql>?show?variables?like?'%time_zone%'; +------------------+--------+ |?Variable_name????|?Value??| +------------------+--------+ |?system_time_zone?|?CST????| |?time_zone????????|?+00:00?| +------------------+--------+ 2?rows?in?set?(0.00?sec)
mysql>?select?now(); +---------------------+ |?now()???????????????| +---------------------+ |?2013-08-05?02:35:43?| +---------------------+ 1?row?in?set?(0.00?sec)
?
?以上就是修改MySQL的時區,涉及參數time_zone的內容,更多相關內容請關注PHP中文網(www.php.cn)!?
? 版權聲明
文章版權歸作者所有,未經允許請勿轉載。
THE END