After upgrading to Mavericks (os X 10.9) my install of MySQL never wanted to work properly. While it may not have been necessary, I chose to uninstall MySQL and then reinstall, with the latest version. It turns out it was much simpler than the several hours lost on troubleshooting the existing installation.
Note: This removed all of my local MySQL databases, which was OK with me, but if that’s a problem for you, back those up first.
Completely uninstall MySQL. Note: Make a copy of /etc/my.cnf if there are some settings that you’d like to add back in.
Follow the uninstall steps here:
And then follow the MySQL installation steps here: