Home > database >  MYSQL how to modify the time zone
MYSQL how to modify the time zone

Time:10-07

Show variables like "% % time_zone";
VARIABLE_NAME VARIABLE_VALUE system_time_zone UTC time_zone SYSTEM

How to amend the UTC to CST?

CodePudding user response:

Try to modify the system time zone...

CodePudding user response:

- change the global (has joined the session of unaffected)
The set global time_zone='+ 01:00';
- set the current connection
Set the session time_zone='+ 01:00';

If it is permanent change, in the configuration file to join: time_zone='01:00 +'


CodePudding user response:

System_time_zone is the operating system, so you have to change in the operating system
  • Related