How to set up MySQL local server from scratch
While I am familiar with conventional databases (in particular FileMaker Pro for 20 years or more) I haven't got a clue how to set up the MySQL server on my Mac. I've downloaded and installed MySQL 5.5.9 for oxs 10.6 and MySQL_Startupitem. I've downloaded the MySQL Workbench. I didn't get any errors installing any of them. However, when I try to get it working via the Workbench, I get setup errors and I have NO idea what they mean. For starters, I find it really frustrating that I can't keep the Workbench Help Doc open while doing the setup. The Help Doc opens in a 2nd tab in the Workbench viewer and nothing I try can get it out of there, so I can switch back and forth.
Anyway, as far as I can tell, I've got the values correct for a New Server Instance (localhost, Standard TCP/IP, Port 3306, username root) according to the help file. However, when I hit Continue I get errors:
"Could not connect to MySQL server:
Lost connection to MySQL server at 'reading initial communication packet', system error: 61
You may continue if the server is simply not running."
I hit continue (as it says I can) and it came up with another error: "File /etc/my.cnf doesn't exist"
What on earth could that mean? I tried searching the Workbench manual but it came up with nothing. The Read Me file which came with the MySQL download seems to be for an old version and the paths it gives for where files are stored don't seem to be viable on my system. I searched the file for "my.cnf" and there is no reference to it at all.
Unfortunately my brain is TOTALLY literal and without perfect step-by-step instructions, I'm hooped. Can someone please point me to where I can find "instructions for dummies" for getting the MySQL server to work locally? I have the sitepoint book Simply SQL by Rudy Limeback and that's where I got the info about installing the MySQL server software but the docs for the software are just totally confusing me.
Any help will be greatly appreciated.