This may not be obvious, you can use the MySQL 5.5 64-bit dmg installer. It works perfectly on Lion.
Now after MySQL 5.5 is running, strangely enough, you cannot simply launch terminal and type
mysql -u rootBash will complain that it can’t find mysql. So we have to help it like so:
- Use your favorite text editor to edit the file
/Users/%yourname%/.bash_profileIf this file doesn’t exist you can create it.
- Add the following line to your .bash_profile
export PATH=$PATH:/usr/local/mysql/binand save the file. Be careful editing this file exactly as above. You can render terminal unable to find all your programs if you break your $PATH.
- Quit and relaunch terminal, or type
source ~/.bash_profleand hit return to reload the changes in your profile.
- Check your $PATH by typing
echo $PATHand pressing return. You should see something like this
- Now you should be able to run
mysql -u rootwhich means there is no root password by default!
- Run this next, at the mysql prompt
GRANT ALL ON *.* TO 'root'@'localhost' IDENTIFIED BY 'your_password_here' WITH GRANT OPTION;This is how to secure your root user login.
Now, for PHP to use this connection I had to tweak my system as shown below:
- Run phpinfo() and check out the path PHP is trying to use for mysql.sock. On my new Mac Mini, it was
- From terminal, I did
sudo find / -name mysql.sock -print
- The critical line of output shows that MySQL 5.5 installs the sock to
- Now we need to create a symlink for PHP to be able to access the mysql.sock. Trouble is if you try it you’ll get an error because /var/mysql doesn’t exist. So next, do
sudo mkdir /var/mysql
- Finally, do this
sudo ln -s /private/tmp/mysql.sock /var/mysql/mysql.sock