Re: How do I permanently disable ONLY_FULL_GROUP_BY

[Peter Brawley]

The MySQL manual says "MySQL makes no guarantee about the order in which option files in the directory are read". Dunno about MariaDB.

From https://stackoverflow.com/questions/580331/determine-which-mysql-configuration-file-is-being-used ...

If you are on Linux, then start the 'mysqld' with strace, for eg strace ./mysqld.

Among all the other system calls, you will find something like:

stat64("/etc/my.cnf", 0xbfa3d7fc) = -1 ENOENT (No such file or directory)
stat64("/etc/mysql/my.cnf", {st_mode=S_IFREG|0644, st_size=4227, ...}) = 0
open("/etc/mysql/my.cnf", O_RDONLY|O_LARGEFILE) = 3