--default-time-zone=timezone Command-Line Format --default-time-zone=name Option-File Format default-time-zone Permitted Values Type string Set the default server time zone. This option sets the global time_zone system variable. If this option is not given, the default time zone is the same as the system time zone (given by the value of the system_time_zone system variable.
default-time-zone=+8:00
Command-Line Format --default-time-zone=name
Option-File Format default-time-zone
Permitted Values
Type string Set the default server time zone. This option sets the global time_zone system variable. If this option is not given, the default time zone is the same as the system time zone (given by the value of the system_time_zone system variable.
1、mysql默认是用的操作系统的时区的,首先检查下系统时间是否正确吧。
2、在配置文件my.ini里配置(试着修改下吧)
[mysqld]
default-time-zone=+8:00