I am running MySQL 5.1 from package on Mac OSX 10.6. I am trying running: sudo /usr/local/mysql/bin/mysqld --skip-grant --user root --datadir=/usr/local/mysql/data

This error is preventing me from starting the database and importing the timezone information or doing anything else. I've tried clean installing with no luck.

Any suggestions?

migrated from stackoverflow.com Nov 10 '11 at 8:05

This question came from our site for professional and enthusiast programmers.


Named timezones are usable when they exist in your mysql database. In your case it seems that you don't have them there, so you can use offset relatives to UTC e.g: '+07:00' or '-04:00' or '+00:00'.


You're probably looking for Etc/UTC. Correct the relevant setting in your MySQL config.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy