my favorite

2010/01/10

mysql5 client/server on Leopard

1. install macport

2. sudo port install mysql5 +server
3. sudo port install mysql5-server
# A startup item has been generated that will aid in
# starting mysql5-server with launchd. It is disabled
# by default. Execute the following command to start it,
# and to cause it to launch at startup:
#
# sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist
4. sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist
5. sudo -u _mysql mysql_install_db5 (installing mysql5 system tables)
6. mysqladmin5 -u root password 'NEW_PASW' (to change your password to NEW_PASW)

finally, we could rails a project with mysql db connection by typing
rails -d mysql proj
we must verify if /opt/local/var/run/mysql5/mysqld.sock exists : )


No comments:

BIO

Taipei, GuTing, Taiwan

huang47 | personal

huang47 | personal