We released a small modification a few days ago that allow you to setup a custom configuration for your MySQL server, regardless of the version you run.
In order for the modifications to be used by the MySQL server, it needs to be in a
.cnf file in
*/lamp0/etc/mysql/* and the instance has to be rebooted.
There is a
custom.cnf file already in the repository with a sample sql_mode modification commented.
This feature does not allow you to override our own default settings. You can only set the options we do not explicitly set.