MariaDB set timezone in config

timezone mariadb
user2562424 picture user2562424 · Oct 14, 2014 · Viewed 18k times · Source

How do I set the server timezone in the MariaDB configuration?

The only thing I can find in the documentation is using command-line flags, which I don't want to do.

default_time_zone, which works on vanilla MySQL, isn't recognized by MariaDB.

Answer

Gergo Erdosi picture Gergo Erdosi · Oct 14, 2014

It is default-time-zone (- instead of _):

[server]
default-time-zone=UTC

Related questions

Does Python's time.time() return the local or UTC timestamp?

Does time.time() in the Python time module return the system's time or the time in UTC?

Read More
How can I get the current date and time in UTC or GMT in Java?

When I create a new Date object, it is initialized to the current time but in the local timezone. How can I get the current date and time in GMT?

Read More
How do I set the time zone of MySQL?

On one server, when I run: mysql> select now(); +---------------------+ | now() | +---------------------+ | 2009-05-30 16:54:29 | +---------------------+ 1 row in set (0.00 sec) On another server: mysql> select now(); +---------------------+ | now() | +---------------------+ | 2009-05-30 20:01:43 | +---------------------+ 1 row in set (0.00 sec)

Read More