Mac OS X Lion and MySQL Startup

By Xeon Xai  

After installing Mac OS X Lion and updated my PHP extensions, as well as installing the newest MySQL, I found that when I tried to use MySQL, it wasn’t working. Seems that MySQL wouldn’t start up do to owner settings.

MySQL was previously installed in Snow Leopard with file ownership set to mysql:wheel, which worked fine in Snow Leopard. In Lion it failed to start.

In Terminal, run the following:

sudo chown -R mysql:mysql data

After running this, and starting up MySQL in the System Preferences panel, everything worked again.

Notice, that your “data” folder is the MySQL data folder where it stores the database files. My is located at “/usr/local/mysql-data/data” so that I don’t have to worry about upgrades and moving the folder. Your location may vary.

Hope this helps anyone else.

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Post a Comment

Your email is never shared. Required fields are marked *