I want a standard way to locate mysql config directories, On linux this becomes a little easy with mysqld --help --verbose, but I am still little puzzled how to get the install directories ( that's where I suppose the my.ini file should be). I would most appreciate if we could get these search paths using a sql query statement ( show ??)
Update: I am specifically looking for a way to do it on Windows. I know so far that my.ini is kept in windows MySQL install dir, but through query how do I ascertain this location?