MySQL: Setting sql_mode permanently
mysql, sql-mode
Solution
Add this to your my.cnf file (or my.ini if you're using windows):
sql_mode="TRADITIONAL"
and restart the server
Problem
Via the MySQL command line client, I am trying to set the global mysql_mode: ``` SET GLOBAL sql_mode = TRADITIONAL; ``` This works for the current session, but after I restart the server, the sql_mode goes back to its default: '', an empty string. How can I permanently set sql_mode to TRADITIONAL? If relevant, the MySQL is part of the WAMP package. Thank you.