Does anyone know if there is a way to confirm if any my.cnf file is being read by MySQL?
I only have the one my.cnf on the machine (and there are no my.ini files) which I have in /etc/my.cnf.
When I run
./mysqld --help --versbose, it doesn't give me the variable I have set in the file, so my assumption was it wasn't loading it or that it was loading a different file.
I tested this by setting my.cnf to 777 and running the command again, this time I get a warning saying the file won't be loaded because it is world writeable.
Is this enough to imply the my.cnf has been loaded and perhaps there is an error in it, causing the variables not to be set or is there some other way of knowing for sure what (if any) my.cnf file is loaded?