"My question is has anyone tried to install MySQL on there OS X box?
I just finished.
"How hard was it?"
Like most Linux/Unix installs I've done, it was not easy. I am very technical when it comes to the Mac, and I can follow instructions, but I found that the answers that the manual, and others, provided did not work on Mac OS X.
"What is the best advice you can give for a dynamic newbee?"
Besides "Run away, run as fast as you can"?
When you go to the main mysql site, follow the link to the Mac binary. Download and install it according to the instructions provided. Follow all of the instructions to the letter. And, when you figure out that it still does not work, do this:
(You may have to enter in the full path to each of the bin/script files, if you did not add the mysql directory to your path.)
To start the daemon, type "sudo safe_mysqld" at the shell prompt. Then enter the administrator's password (probably the same one you use when you install software).
Then, to start mysql, type "mysql --local-infile -u root -p DATABASENAME", and then enter the mysql password you set in the instructions. This is the part that took me forever to figure out. You will get Access Denied errors if you do not use the "-u root -p" options. You will get an error when you try to import data from a text file if you do not use the "--local-infile" option. There are very few places that have all of this info...I looked in several different places to find it. Now, it is on webmasterworld.com!
To shutdown the daemon (after exiting mysql), type "mysqladmin -uroot -p shutdown" and then enter the mysqladmin password.
That is about all I know other than to search on google.com for any errors you get. Be sure to include "mac" in the search, or you will get things related to other platforms.