Shulou(Shulou.com)06/01 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.