How to change a MySQL database to UTC?
I'm on Windows 7 and I'm a bit new to this database stuff. I tried searching on 开发者_运维问答Google for how to change the timezone from my system to UTC but the documents are somewhat advanced and I'm not too sure how to change this field.
In your my.ini file, under the [mysqld] section, add the following line:
default-time-zone = '+00:00'
Restart the server. You could also set it at runtime from the command line with
mysql> SET GLOBAL time_zone = '+00:00';
The documentation from MySql
精彩评论