Cannot connect: Time zone tables don't appear to be loaded in MySQL

  • 9 January 2015
  • 2 replies

  • Anonymous
  • 0 replies

One of our users had difficulty getting mysql_tzinfo_to_sql to work on his Ubuntu install. He found this mysql convert_tz command returns NULL post on Stackoverflow to be helpful.

Essentially, the post describes an extra line break in mysql_tzinfo that needs to be removed manually. It looks like a fairly straightforward fix.

2 replies

Userlevel 3

If you are on MariaDB:

Thank you, Sir.