http://bugzilla.suse.com/show_bug.cgi?id=857349 http://bugzilla.suse.com/show_bug.cgi?id=857349#c3 Kristyna Streitova changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #3 from Kristyna Streitova --- Regarding a comment 0: ====================== Sorry for a late answer. However according to my tests this problem should be fixed now in openSUSE 13.1 and 13.2. What I tried: 1) install mysql-community-server 2) start mysql 3) show the current sql_mode value: mysql> show variables like 'sql_mode'; +---------------+--------------------------------------------+ | Variable_name | Value | +---------------+--------------------------------------------+ | sql_mode | STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION | +---------------+--------------------------------------------+ 1 row in set (0.00 sec) 4) edit /etc/my.cnf - remove sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES - set sql_mode="" 5) restart mysql 6) show the current sql_mode value: mysql> show variables like 'sql_mode'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | sql_mode | | +---------------+-------+ 1 row in set (0.00 sec) So it seems that although the /usr/my.cnf file is created, it doesn't override /etc/my.cnf anymore. Therefore I'm marking this bug as fixed. If you encounter any further issues, please reopen this bug or file a new one. Thank you. -------------------------------------------------------------------------------- Regarding a comment 2: ====================== This is a different problem from the one in the initial comment. It looks like the same issue as the one in bug 842264. Which is fixed now. However if you encounter any other problems please file a new bug for it or reopen the corresponding bug. Thank you -- You are receiving this mail because: You are on the CC list for the bug.