Building notes, projects, and occasional rants

Tweaks to MySQL installation

After you install one of the MySQL packages available for the Mac, there are some steps that you should do.

First, make sure your MySQL installation knows about time zones. This is important if you want to run your MySQL in the UTC time zone.

To update the mysql database time zone tables, do:

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

Type the password at the prompt (hit enter if you don't have one yet).

And then make sure all your date/datetime fields use the Highlander-timezone. Edit my.cnf and add:


Second, make sure your server is using UTF-8 everywhere. Add to my.cnf:



Third, set mysql to strict SQL:


Finally, make sure you use InnoDB by default:


There are probably more tweaks to make your MySQL saner. This are the one I feel comfortable recommending.