frustrating mysql issue after upgrading to 5.6

Bashed

Bashed

Well-Known Member
Dec 18, 2013
146
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

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,268
463
I am happy to see you were able to find a solution. Thank you for updating us with the outcome.
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
A Should it be safe to migrate all accounts from MariaDB 10.3 to MySQL 8 in a shared hosting environment? Databases 5
dsteam MySQL keep down after restart Databases 4
E How to load MariaDB 10.3 on a WHM system with MySQL 8.0? Databases 2
D Upgrading from MySql 5.7 --> 8.0 Problems Databases 2
N root, mysql, mariadb.sys gone from mysql.user Databases 4
Similar threads
Should it be safe to migrate all accounts from MariaDB 10.3 to MySQL 8 in a shared hosting environment?
MySQL keep down after restart
How to load MariaDB 10.3 on a WHM system with MySQL 8.0?
Upgrading from MySql 5.7 --> 8.0 Problems
root, mysql, mariadb.sys gone from mysql.user
Top Bottom