me talking out loud

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.

1. instructions I used - http://dev.mysql.com/doc/refman/5.0/en/installing-binary.html
2. to create a group in 10.5 - use dscl. In my case ‘dscl . -create /groups/mysql’
3. to create a user in 10.5 - again use dscl. ‘dscl .-create /Users/mysql’
4. I had to make /usr/local with mkdir -m 775
5. 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
6. 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:

1. 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.
2. option 2 - is provided in the manual at http://dev.mysql.com/doc/refman/5.0/en/multiple-servers.html

Yep - I have finally ready for my trip to the MySQL User Conference in Santa Clara. MySQL and Oreilly have been incredibly generous in providing us the opportunity to attend their conference, giving us an exhibition booth and a free pass to all the sessions. With out them - we couldn’t have gone.

Anyway - for those that will be there, make sure to stop by our booth and pick yourself up a PHPWomen sticker (for your laptop, car, bag or anywhere else you can think of). Or if you just want to talk about what we are and what we are doing or the weather - that is great too. Come out and meet me!

Just a quick not to let the world know that I have started the mentor listing for testfest. It can be found at http://wiki.php.net/qa/testfest

Mentors - if I missed you please send me an email to update it or feel free to add yourself to the wiki.

Also we have moved the listing of the User Groups to the wiki so if your user group is participating and not listed - again let me know if you want to be added or add yourself to the testfest wiki page.

Edit: forgot to mark it as PHP. Ooops.

I am pleased and proud to say that come Monday - I will be working for MySQL (*sigh* - Ok Sun). I will be working for a Dream Company of mine - doing a Dream Job. Life does not get better then that.

So to everyone who kept telling me I would get the job when I swore there was no way (you know who you are) - feel free to tell me “I told you so” next time we talk - and first beer is on me when we meet.