One of the most common questions I get is related to the location of the my.cnf file (or my.ini).
The question comes in few variants:
- I am setting the option xyz in my.cnf but it does not seem to work?
- I can set the option xyz using. /mysql --zyx=abc but when I am placing it in my.cnf it does not take any effect?
- I have my.cnf in /etc and on in /usr/local/mysql/etc/ which one should I use?
- Where the f@&% is my my.cnf file !?!?
In MySQL the answer for the above questions are a little confusing.
