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

^Bart <[email protected]> Thu, 9 Nov 2023 10:55:00 +0100
Newsgroups comp.databases.mysql
Organization A noiseless patient Spider
Message-ID <[email protected]>
> https://mariadb.com/kb/en/time-zones/
> 
> [mariadb]
> default_time_zone = 'Europe/Rome'

I did it in /etc/mysql/mariadb.conf.d/nano 50-server.cnf

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

Thanks also for this info! :)

>> I inserted the timezone in 50-mysqld_safe.cnf
> 
> That will apply when running in safe mode.

You got the point, it is a mistake to modify the file for the safe mode 
for what I need.

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

Also in this case you got the point! :)

Thanks for your reply! :)

^Bart