How to enable mysql strict mode in virtualmin

How do I enable mysql strict mode in virtualmin on centos 7 ?



Howdy -- hmm, I'm not too familiar with that setting, but doing some research, I see information on it here:

How to enable it depends on your needs and the needs of your application, but based on the above documentation it sounds like it's a matter of setting the sql_mode parameter to either " STRICT_ALL_TABLES" or "STRICT_TRANS_TABLES".

That can be done by editing the my.cnf file in /etc/, and adding a line something like this:


And then restart MySQL.