Installing MySQL on Mac 10.5
Ok – I had to install MySQL on my Mac for the first time – using a tar of the binaries none the less. And it has been interesting. These are notes mostly for myself but if others find them helpful – great.
- instructions I used – http://dev.mysql.com/doc/refman/5.0/en/installing-binary.html
- to create a group in 10.5 – use dscl. In my case ‘dscl . -create /groups/mysql’
- to create a user in 10.5 – again use dscl. ‘dscl .-create /Users/mysql’
- I had to make /usr/local with mkdir -m 775
- I did not have to decompress things since the Mac did it for me – but I did have to place it in my Library dir and make the ln to it in my /usr/local dir
- DO NOT FORGET to give your root user a password and either drop the anonymous user or put a password on it!
Other notables (yes I am a server noob):
- start the deamon with ’sudo bin/mysqld_safe –user=mysql &’
- If you forget the ampersand at the end – use cntl+z to escape then use ‘bg’ to put the deamon in the background
- stop the deamon with ‘bin/mysqladmin -u root shutdown’
Other notes to self on having multiple versions available:
- option 1 – have multiple binary installs in their own folders and just change the ln.. or have multiple ln with individual names. since I do not need to have all of them running at one time – I can start and stop the deamons as I need.
- option 2 – is provided in the manual at http://dev.mysql.com/doc/refman/5.0/en/multiple-servers.html
