how to set permanent default timezone in mysql server

8
votes

I am using default_time_zone='+00:00' in my.conf file and restart mysql server. But again default time zone is showing SYSTEM.

2
mysql
stackoverflow.com/questions/930900/how-to-set-timezone-of-mysql – Anshul Parashar
Thanks.But this link is not clear solution. anyway I have got the solution - Go to /etc/mysql/my.conf and in Mysqld tag put the code default_time_zone='+00:00' – Ankit Kumar

2 Answers

20
votes

In my.conf file, try:

[mysqld]
...
# default_time_zone='+00:00'
default-time-zone=+00:00
...

Documentation: 5.1.3. Server Command Options: --default-time-zone=timezone

7
votes

I use Ubuntu so on my machine location of the config file is:

/etc/mysql/mysql.conf.d/mysqld.cnf

add the value:

default_time_zone='+00:00'