Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to modify the mysql time, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

Method: 1, use the "sudo cat my.cnf" command to view the "my.cnf" file; 2, use the "vim mysqld.cnf" command to edit the contents of the file, add "default-time_zone ='+ 8vim mysqld.cnf 00'" statement in the file; 3, restart mysql to make the new time effective.

The operating environment of this tutorial: windows10 system, mysql8.0.22 version, Dell G3 computer.

How to modify mysql time

View the my.cnf file

Command:

Cd / etc/mysql/sudo cat my.cnf

Go to the mysql.conf.d folder

Command:

Cd / etc/mysql/mysql.conf.d/

Edit the mysqld.cnf file

Command:

Sudo vim mysqld.cnf

Add the following to the [mysqld] area

Default-time_zone ='+ 8VR 00'

Restart mysql for the new time zone to take effect

Command:

Sudo / etc/init.d/mysql restart

Thank you for reading this article carefully. I hope the article "how to modify mysql time" shared by the editor will be helpful to everyone. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.