to the mysqld-section in your mysql-config on this server and restart mysqld afterwards

Click to expand...

However I did that and even restarted the server:

Code:

[email protected]:~# cat /etc/mysql/mariadb.conf.d/50-server.cnf
#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#
# this is read by the standalone daemon and embedded servers
[server]
# this is only for the mysqld standalone daemon
[mysqld]
sql-mode="NO_ENGINE_SUBSTITUTION"
#
# * Basic Settings