Mysql5 in OSX

Install mac ports

Install Mysql:
freddy@new-host-2:~$ port list | grep mysql5
mysql5 @5.0.67 databases/mysql5
mysql5-devel @5.1.28-rc databases/mysql5-devel
freddy@new-host-2:~$ port install mysql5

• First run this command in your terminal to install the MySQL 5 package:
  
sudo port install mysql5 +server

• Second load the MySQL server by running the following command: (Note: Mac OS X Tiger and above use launchd for starting programs, and this command is worth getting familiar with. In this case the startup configuration file was created for us when we installed MySQL 5.)
  
sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist

• Third figure out the path for your server socket. It should be /opt/local/var/run/mysql5/mysqld.sock but verify this by running this command:
  
mysql_config5 --socket
/opt/local/var/run/mysql5/mysqld.sock

• Fourth you want to create a shortcut to the MySQL socket so that PHP, Ruby on Rails, Python, and your other languages can access it. These commands should make MySQL work for PHP and Ruby on Rails:
  
sudo ln -s /opt/local/var/run/mysql5/mysqld.sock /tmp/mysql.sock
sudo mkdir /var/mysql
sudo ln -s /opt/local/var/run/mysql5/mysqld.sock /var/mysql/mysql.sock

• Fifth you will need to shut down the MySQL server for now. Run this command:
  
sudo launchctl unload -w /Library/LaunchDaemons/org.macports.mysql5.plist

• Sixth you need to setup the root user and the default MySQL database. Sometimes called the grant tables. To do this run this command:
  
sudo /opt/local/lib/mysql5/bin/mysql_install_db --user=mysql

• And last you’ll need to start up the MySQL server and then login and change the root password.
  
sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist
mysql5 -u root
UPDATE mysql.user SET Password = PASSWORD('password') WHERE User = 'root';
FLUSH PRIVILEGES;
quit

• Now you should be able to login using your new password.
  
mysql5 -u root -p


That’s it you’re all setup with MySQL on Mac OS X.