MySQL broken by 10.3.9?
I noticed today that my MySQL install seemed to have broken. I was getting an error when I tried to post a new entry via Ecto, and after poking around a bit I discovered that any query involving the mysql database (such as a site search) produced the same error:
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Further investigation seemed to indicate this was a permissions problem. The only thing I've installed recently has been the OS X 10.3.9 update, so I'm guessing it happened then. After much googling I found the fix.
Change directory to your mysql directory:
cd /usr/local/mysql
And enter this change ownership command:
sudo chown -R mysql data/
And voila! Everything works again.
Related entries
Upgrade to Tiger, PHP and MySQL broken - 27 April 2005Postfix broken ... again - 22 March 2004
Sponsors