Tuesday, July 08, 2008

mysql




Installing MySQL on OS X:

A great resource is at developer.apple.com

Here's the commands I used:


wget http://mysql.serenitynet.com/Downloads/MySQL-5.0/mysql-5.0.51b.tar.gz
./configure --prefix=/usr/local/mysql --with-unix-socket-path=/usr/local/mysql/run/mysql_socket --with-mysqld-user=mysql --with-comment --with-debug
make
sudo make install
sudo /usr/local/mysql/bin/mysql_install_db --force
sudo mkdir /usr/local/mysql/run
sudo mkdir /usr/local/mysql/var
sudo find /usr/local/mysql -exec sudo chown mysql:mysql {} \;
sudo /usr/local/mysql/bin/mysqld_safe --user=mysql &
/usr/local/mysql/bin/mysqladmin -u root password 'a_very_secure_password_of_which_this_is_not'