On Thu, Mar 28, 2019 at 8:06 AM <[email protected]> wrote: > I had to do the following: > > > > 1) mysql_tzinfo_to_sql /usr/share/zoneinfo/|mysql -u root mysql -p > > 2) From within MySQL: *SET* *GLOBAL* time_zone = 'America/New_York'; > > > > > > Then everything seemed to work. > > >
I think you may still need to set default_time_zone in my.cnf for this to persist across restarts of MariaDB. I don't believe SET GLOBAL persists. - Mike
