------------------
1、定位msyql配置文件my.cnf,查看mysql啟動(dòng)文件 /etc/init.d/mysql
2、注意一定要在 之下加 ,否則會(huì)出現(xiàn) unknown variable 'default-time-zone=+8:00'
default-time-zone = '+8:00'
3、mysql中執(zhí)行sql命令
SHOW VARIABLES LIKE '%time_zone%'
SELECT NOW( )
default-time-zone = '+8:00'
3、mysql中執(zhí)行sql命令
SHOW VARIABLES LIKE '%time_zone%'
SELECT NOW( )