Turn off Strict_trans_tables for one account?

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,296
1,266
313
Houston
Hi @gizmo80

strict_trans_tables is a mode which is set on connection/globally and not really able to be disabled per account the documentation on modes may be useful MySQL :: MySQL 5.7 Reference Manual :: A.3 MySQL 5.7 FAQ: Server SQL Mode

I did also come across the following which may provide a way to do this but I won't guarantee it -https://dba.stackexchange.com/questions/31447/how-can-i-set-a-default-session-sql-mode-for-a-given-user

the method is very custom and could cause unknown issues.


Thanks!