mysql51 mysql macports lion | pragmatic startup

Install the packages
1. sudo port install mysql51 mysql51-server
Initialize the db
1. sudo -u _mysql /opt/local/lib/mysql51/bin/mysql_install_db
Make mysql51 the default
1. sudo port select mysql mysql51
Run the daemon
1. cd /opt/local ; sudo /opt/local/lib/mysql51/bin/mysqld_safe &
Check to see its working by running mysql -uroot which should bring you into the interactive mysql shell as root user
Setup
1. /opt/local/lib/mysql51/bin/mysql_secure_installation

Other Notes:

For MySQL51, running cd /opt/local/mysql-test ; perl mysql-test-run.pl results in an error Can’t open perl script “mysql-test-run.pl”: No such file or directory. This is a reported bug.
Using zsh, running which mysql results in mysql: aliased to nocorrect mysql. To see the path. If you’re having problems getting mysql command to work, try this solution.
If you’re running into this error while connecting to MySQL Work Bench or Sequel Pro, MySQL said: Lost connection to MySQL server at ‘reading initial communication packet’, system error: 61, the fix is to comment out skip-networking in the my.cnf or macports-default.cnf file found at /opt/local/etc/mysql51

pragmatic startup