My MySQL Notes

#faveDB lel

Important when working with the DB is to get the timezones right when using LocalDate in Java. How to see MySQL timezone
How to change the time zone in linux
Your timezone should be the same on the Application Server as on the Database Server. Otherwise there might be date glitching when using LocalDate or other Date / Time classes without offset.

-- to configure timezone for mysql (must be root) (example for germany, as UTC+02:00)
SET GLOBAL time_zone = '+2:00';
MySQL, as a default has the timezone of the server it is running on. I encountered problems with mysql server where the server it was running on had "CEST" timezone. The mysql java driver did not recognize the timezone 'CEST'. In this case, it helped to adjust the jdbc url, as shown here:
Fix
jdbc:mysql://IP:PORT/DB_NAME?serverTimezone=Europe/Berlin"