Mariadb 10.2 – Disabling Strict Mode

On my install, as well as an /etc/my.cnf , I found a /usr/my.cnf file that is read after the /etc/my.cnf

I added the line

sql_mode=""

as the last line of the /usr/my.cnf file and restarted sql, and safe mode was disabled, and this configuration has survived all reboots and updates so far.

I probably should note that the answers regarding 10.2 that I have been reading suggest that a different format should be used to disable strict mode (that doesn’t actually seem to exist any more) in the cnf files eg

sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

but I haven’t tried it on 10.1 (if it isn’t broken don’t fix it)