Changing sql mode


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

  # ------------------------------------------------------------
  # MySQL Database
  # ------------------------------------------------------------
    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?


sql_mode = ""


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

Before applying any config:

Applying config:

sql_mode =

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