Get the App
SLTechnology News&Howtos  ›  Database  › 

How to modify the default time zone of mysql

Shulou Source: shulou.com Published: 2022-06-01 11:38:54 11月16日 Update

This article shows you how to modify the default time zone of mysql. The code is concise and easy to understand, which will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

View the current time zone and time of MySQL

Show variables like "% time_zone%"; # View time zone

# time_zone indicates that mysql uses the time zone of system, while system_time_zone indicates that system uses CST time zone

Select curtime (); # View time select now (); # View date + time

II. Modify the time zone

You can modify the time zone by modifying the my.cnf configuration file

# vim / etc/my.cnf

Add the following to the [mysqld] area:

Default-time_zone ='+ 8VR 00'

After the modification is completed, you need to restart the startup MySQL, and the configuration takes effect.

The above is how to modify the default time zone of mysql. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Tags: Time zone time content skills knowledge configuration concise concise code region can be passed that is documents articles dates more articles industry information information channels Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno NVidia Xiaomi Linux Huawei Docker