Sunday, March 06, 2011

Installing MySQL on Mac OS

Follow the following steps to install and configure MySQL on Mac OS
Set the permissions
sudo chgrp -R mysql /usr/local/mysql 

Starting mysql is accomplished with:

sudo /usr/local/mysql/bin/mysqld_safe --user=mysql &

Now you can run through some of the basic tests — but first, go ahead and secure the database by adding a password for the database “root” user, as follows:

/usr/local/mysql/bin/mysqladmin -u root password sniggle
/usr/local/mysql/bin/mysql -u root