How to disable default sql mode(“ONLY_FULL_GROUP_BY”) in mysql 5.7
First, Check what is your current sql mode and output will be as below. Then, open the “/etc/mysql/my.cnf” and add the following line without “ONLY_FULL_GROUP_BY” into the [mysqld] section. Restart the mysql.