mysqlsql-mode

MySQL: Setting sql_mode permanently


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.


Solution

  • Add this to your my.cnf file (or my.ini if you're using windows):

    sql_mode="TRADITIONAL"
    

    and restart the server