MySQL on Mac osx 10.5

At the time of this writing i have removed MySQL 5.1 and have gone back to 5.0.x - due to having lots of problems. I thought I'd make some notes, that might help people out.

1. Firstly install the server and then the startup item.

2. Then create a .profile within your home directory, if it doesn't already exist.

3. edit and include the following ->


# MySQL Commands
# - points to server for use
alias mysql=/usr/local/mysql/bin/mysql
alias mysqladmin=/usr/local/mysql/bin/mysqladmin

# - controls startups
alias start_mysql="/Library/StartupItems/MySQLCOM/MySQLCOM start"
alias stop_mysql="/Library/StartupItems/MySQLCOM/MySQLCOM stop"

4. Reload .profile file (from within the particular user directory)->

. ./.profile

NB. Please note security issues will need to dealt with separately.




Bg