how to set permanent default timezone in mysql server

Question

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

Answer 1

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

Answer 2

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'