I have an issue where I need to set the binlog format to MIXED every time I restart my MariaDB for Nextcloud.
I have BINLOG_FORMAT = MIXED set in the custom.cnf file, but every single time I restart the database container I have to reset the global binlog format.
Any ideas where to begin?
EDIT: Ah, turns out it was a permissions issue (isn't everything?).
FWIW, the error I was getting in the MariaDB log was:
"Warning: World-writable config file '/etc/mysql/conf.d/custom.cnf' is ignored"
Fix that seems to have worked: sudo chmod 0644 /mnt/user/appdata/mariadb/custom.cnf