Remove ONLY_FULL_GROUP_BY on MySQL

related: MySQL Docker

By Query

Connect to mysql shell, you can use tools like mycli for this.

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

By Docker Compose

version: "3.7"
services:

  db:
    image: mysql:5.7
    ports:
      - "3306:3306"
    volumes:
      - mysqldata:/var/lib/mysql:delegated
      - "./my.cnf:/etc/mysql/conf.d/mysql.cnf"
    environment:
      - MYSQL_DATABASE=database_name
      - MYSQL_ROOT_PASSWORD=root