I am trying to disable the MySQL/MariaDB strict mode in the variable sql_mode. But it doesnt work. My my.cnf in section [mysqld] got this line:sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTIONBut it doesnt take effect. If I log into the database as root use and execute the following command it works fine:SET GLOBAL sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION;So, how I can make this change persistent?
Disabling strict mode does not take effect from the config file
mysql;sql;mariadb