Method 1
#查看时区 show variables like "%time_zone%"; set global time_zone = '+8:00'; ##修改mysql全局时区为北京时间，即我们所在的东8区 set time_zone = '+8:00'; ##修改当前会话时区 flush privileges; #立即生效
Method 2
## linux
# vim /etc/my.cnf ##在[mysqld]区域中加上 default-time_zone = '+8:00' # /etc/init.d/mysqld restart ##重启mysql使新时区生效
windowsModify the configuration file my.ini
C:\ProgramData\MySQL\MySQL Server 5.7
#设置默认时区 default-time-zone='+08:00'
net stop mysql net start mysql
服务名无效。 请键入 NET HELPMSG 2185 以获得更多的帮助。
windows r, open the run, enterservices.msc, and find the mysql service.
net stop mysql57 net start mysql57
mysql video tutorial"
The above is the detailed content of Mysql method to view and modify time zone. For more information, please follow other related articles on the PHP Chinese website!
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
