时区

查看时区

  1. show variables like "%time_zone%";

查看时间

  1. select now();

修改为东八区

  1. set GLOBAL time_zone='+8:00';
  3. set time_zone='+8:00';
  5. FLUSH PRIVILEGES;