Changing sql mode

#1

The only way I’ve got this to work is by changing the docker command:

  # ------------------------------------------------------------
  # MySQL Database
  # ------------------------------------------------------------
  mysql:
    image: devilbox/mysql:${MYSQL_SERVER}
    hostname: mysql

    # Set sql mode manually
    command: mysqld --sql_mode=""

Tried changing the mysql_mode in devilbox/cfg/mariadb-10.3/devilbox-custom.cnf but for some reason it has no effect, any ideas why?

[mysqld]
;key_buffer_size=16M

sql_mode = ""

[mysqldump]
;quick
#2

I’ve just tried it on my machine and it seems like you need to omit the quotes.

Before applying any config:

Applying config:

[mysqld]
sql_mode =

So there’s no need to alter docker-compose.yml