查看mysql当前时间,当前时区
1 2 |
select now(); show variables like "%time_zone%"; |

修改时区
1 |
set global time_zone = '+8:00'; |
1 |
set time_zone = '+8:00'; |
1 |
flush privileges; |
rpm安装的修改my.cnf配置文件
1 |
vim /usr/my.cnf |
1 |
default-time_zone = '+8:00' |
大王叫我来巡山,我把博客转一转。(*^__^*) 嘻嘻……