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?
Best Answer
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'.