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.
I inserted the timezone in 50-mysqld_safe.cnf
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.
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 297 |
Nodes: | 16 (2 / 14) |
Uptime: | 103:57:14 |
Calls: | 6,660 |
Calls today: | 2 |
Files: | 12,209 |
Messages: | 5,335,167 |