MySQL modifies the time zone of the database

We can use it again in MySQL:

Select Now () to view the time of the current database.

Now ()
---------------------
2015-02-03 15:06:12

Use show variables like '%time_zone% ' to see the current time zone and the time standard used.

Variable_name Value
----------------     --------
System_time_zone UTC
Time_zone +08:00

If you want to modify the time zone we can use the command to modify or you can use the MySQL configuration file my.cnf configuration

Modify with command: Set time_zone= ' "

If using a configuration file, add default_time_zone= ' mysqld ' to the MySQL configuration file my.cnf

Then we need to restart our database service.

MySQL modifies the time zone of the database