frustrating mysql issue after upgrading to 5.6

Bashed

Well-Known Member
Dec 18, 2013
139
4
68
cPanel Access Level
Root Administrator
Upgraded MySQL from 5.5 to 5.6

Found out that "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION" becomes standard in MySQL 5.6 (not even in my.cnf file). So, in my.cnf I added:

sql_mode="TRADITIONAL" and restarted mysql. Didn't fix the issue. Also tried this, same.
sql_mode="TRADITIONAL,NO_AUTO_CREATE_USER"

EDIT: JUST FOUND A FIX.

There is a my.cnf in /usr/my.cnf that had the strict enabled rule. I changed it to:

sql_mode=NO_ENGINE_SUBSTITUTION
 
Last edited:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,910
2,213
363
I am happy to see you were able to find a solution. Thank you for updating us with the outcome.