fix ubuntu and mysql timezone

README.md

fix ubuntu timezone

sudo dpkg-reconfigure tzdata

fix mysql timezone

If you're struggling with the error:

Error saying “server time zone value 'EDT' is unrecognized…” when trying to make connection to MySQL

1 - update zone info

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql -p

2 - update mysql configuration

mysql -uUSER -p
SELECT @@global.time_zone;
SET time_zone='America/Sao_Paulo';
SET @@global.time_zone = '+3:00';
SET @@session.time_zone = "+3:00";

3 - check server current timezone

timedatectl ref

still with some error? maybe it will be a sync problem, follow this steps

apt install ntp ntpdate
ntpdate pool.ntp.org
hwclock --systohc

ref