Take the 2-minute tour ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

I have a clean installation of Snow Leopard on a MacBook and I want to get a MySQL Server running on it. I downloaded and installed the .dmg file provided by the homepage of MySQL and installed it. I did not yet try to start the server. I installed Workbench and configured it to localhost (standard settings). Now Workbench keeps telling me, that it could not find the file /etc/my.cnf. I was able to start the MySQL-Server from within Workbench, though. Now **Workbench wants to add a /etc/my.cnf file. Shall I proceed or is the file somewhere else already?

locate my.cnf tells me

/usr/local/mysql-5.5.13-osx10.6-x86_64/mysql-test/include/default_my.cnf
/usr/local/mysql-5.5.13-osx10.6-x86_64/mysql-test/suite/federated/my.cnf
/usr/local/mysql-5.5.13-osx10.6-x86_64/mysql-test/suite/rpl/my.cnf

Is it possible, that it is one of those? I don't want to mess the configuration up by creating a new my.cnf so I hope for an inspiration by some expert. Thanks!

share|improve this question
add comment

1 Answer 1

up vote 3 down vote accepted

Feel free to copy one of the example files into the /etc directory or make your own. You won't have any problems until you ever want to have more than one version of mysql installed and running - then you can set up shell variables to keep things apart - but for the short run - one file in one place would be good. So let the Workbench make /etc/my.cnf and the other files will probably be ignored since Workbench looks to be telling you it looks only in /etc.

share|improve this answer
    
I assume by example files you mean, the files I listed above (after the locate command)? Another question: Do I understand it right, that the content of /etc/conf (assuming it exists) can be modifyed by Workbench? –  Aufwind Jun 10 '11 at 17:48
    
Yes to example files and Yes - I believe so. I don't have any of the files loaded on my mac to inspect - but as long as the user running the Workbench can create the file (or edit it once it's in place) Mac OS X won't prevent you from editing the file in /etc (which really is a link to /private/etc) As far as Mac - there is nothing special about MySql or the workbench so you might need to ask in the power users forum if no-one here has specific knowledge of that mysql tool. –  bmike Jun 10 '11 at 17:51
    
I will ask in the power user forum for this explicit detail. And thanks for your answer(s) so far. –  Aufwind Jun 10 '11 at 17:53
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.