I just installed MySQL Server and MySQL Workbench on a clean Snow Leopard MacBook. I hooked up Workbench with the server and was able to start the MySQL Server from within the Workbench. I enter the Administration menue of MySQL Workbench it tells me there is no /etc/my.cnf. And if I click on Option File on the left side in the Workbench it tells me, that it will generate a my.cnf file after hitting Apply.
Now I see many configuration possibilitys. Is there a documentation for that? The best I could find was this MySQL-Dev-Page, but it does not help much.
Even better would be an explanatory default file, which I could adapt, since I am no expert with MySQL and I only want to use python sqlalchemy and django with the MySQL Server as localhost.
Every hint is appreciated.
Best Answer
You many need to take a look at the comprehensive list of all Server Variables. Some of them you can change for the duration of your session, some you may change with the SET GLOBAL command, and other options may require a restart of MySQL.
Here is the list of all options. This will also show which options can be used in option files.