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.