mysql数据库设置时区

show variables like '%time_zone%';
mysql> set global time_zone = '+8:00';
mysql> set time_zone = '+8:00';
mysql> flush privileges;

配置文件加上

default-time-zone = '+8:00'