Re: How do I permanently disable ONLY_FULL_GROUP_BY
Posted by: Peter Brawley
Date: March 31, 2022 11:04AM

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

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.