Read your Installing MySQL on Lion https://discussions.apple.com/docs/DOC-3082
Really helpful. Couple of questions - we need a mysql user and group and don't want to use server app to creat them. Or could but I need to know the exact permissions that should be set.
You shouldn't have to do anything. There is already a _mysql user on the system. There are lots of similar, locked accounts ready in case they are needed. Run "dscl . list /users" for a list of them.
1. When we set the mysql install to chown and chgrp mysql it sets it to _mysql - which I believe is single user mode only.
You shouldn't have to do that. There is no single user mode in MySQL. The server runs under the unprivileged _mysql user but any client with credentials and connectivity to the server can connect.
2. We didn't read your excellent document prior to doing the install and did install the preference pane and startup tool. But we also installed mysql workbench.
Are we ok here if we just don't load the preference pane or should we delete it and go with your recommendations?
It's not that important. It just bugs me when people wait until something breaks in order to fix it. That is why Apple publicly deprecates these things that it wants to get rid of. Then, 5 or 6 years later, Apple gets rid of it and people scream bloody murder.
The problem with MySQL is that its licensing scheme and recent takeover by Oracle dissuade me from spending the two hours to build a decent Preference Pane. MySQL's long term prospects are pretty poor. It's fast, easy to use, easy to setup, and not long for the world. Apple has already moved on to PostreSQL and perhaps the rest of us shoudl too. The PostreSQL Mac installer needs even more help. Perhaps that is where I should put my two hours.
No need to do anything now, of course. Just something to keep in mind for when the time comes to move on.