MYSQL 如何修改时区

Question

show variables like "%time_zone%";
VARIABLE_NAME                                                    VARIABLE_VALUE                                                                                                             system_time_zone                                                 UTC                                                                                                                                           time_zone                                                        SYSTEM 如何将UTC修改为CST？

Answer 1

-- 更改全局的（已经连接的 session 不受影响）
 set global time_zone='+01:00';
-- 设置当前连接的
set session time_zone='+01:00';如果是永久性的修改，在配置文件中加入：  time_zone='+01:00'

Answer 2

system_time_zone 这个是操作系统的，所以你得在操作系统中去改