Groups | Search | Server Info | Login | Register

Groups > comp.databases.mysql > #7683

Re: Time zone, after reboot comes back to SYSTEM (Debian Bookworm)

Show all headers | View raw

On 06/11/2023 09.38, ^Bart wrote:
> Hi guys,
> 
> I login to MariaDB and I do:
> 
> MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'time_zone';
> +---------------+--------+
> | Variable_name | Value  |
> +---------------+--------+
> | time_zone     | SYSTEM |
> +---------------+--------+
> 1 row in set (0,001 sec)
> 
> After it I do:
> 
> MariaDB [(none)]> SET GLOBAL time_zone = 'Europe/Rome';
> Query OK, 0 rows affected (0,004 sec)
> 
> And I have:
> 
> MariaDB [(none)]> SHOW GLOBAL VARIABLES LIKE 'time_zone';
> +---------------+-------------+
> | Variable_name | Value       |
> +---------------+-------------+
> | time_zone     | Europe/Rome |
> +---------------+-------------+
> 1 row in set (0,001 sec)
> 
> After a reboot, like what I wrote in the subject, the time zone value 
> comes back to system.

https://mariadb.com/kb/en/time-zones/

[mariadb]
default_time_zone = 'Europe/Rome'

or if you want the system time to also be the same:
sudo ln -sf /usr/share/zoneinfo/Europe/Rome /etc/localtime


> I inserted the timezone in 50-mysqld_safe.cnf

That will apply when running in safe mode.


I do favor UTC as timezone as then you don't have to bother about the 
heart attack causing time change twice a year.

-- 
  //Aho

Back to comp.databases.mysql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Time zone, after reboot comes back to SYSTEM (Debian Bookworm) ^Bart <gabriele1NOSPAM@hotmail.com> - 2023-11-06 09:38 +0100
  Re: Time zone, after reboot comes back to SYSTEM (Debian Bookworm) "J.O. Aho" <user@example.net> - 2023-11-06 14:23 +0100
    Re: Time zone, after reboot comes back to SYSTEM (Debian Bookworm) ^Bart <gabriele1NOSPAM@hotmail.com> - 2023-11-09 10:55 +0100

csiph-web