After upgrading to MySQL 5.5 from the Remi-DB (CentOS 6) we've been getting an issue where every reboot our SQL server will set itself back to strict mode:
mysql> SELECT @@GLOBAL.sql_mode;
+--------------------------------------------+
| @@GLOBAL.sql_mode |
+--------------------------------------------+
| STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |
+--------------------------------------------+
Then I run the command:
mysql> SET GLOBAL sql_mode="";
Query OK, 0 rows affected (0.00 sec)
And that works fine for the session, but on restart this change is lost (I've also tried setting "SET SESSION" sqlmode as well.
I'd also like to note that I've tried this in the my.cnf
files as well.
The only viable solution is to code an init file to run the SET GLOBAL sql_mode
on restart but that's cumbersome, annoying, and unreasonable, there's got to be a way to make this work right off the bat.
I've tried a reinstall of the SQL server to no avail. (I did however pull back in the data from a backup of course as this is a production server.)