disable mysql strict mode per cagefs user

MichaelLoungeIT

Registered
May 21, 2019
4
0
1
Switzerland
cPanel Access Level
DataCenter Provider
This topic was picked up a few years back, but its no longer possible to respond there, so a little bump.

Back then, cpanel statet, that currently its not possible to change a my.cnf config per cagefs user and is only globally possible.

Has that changed in the meantime? As CageFS matured a bit, maybe it's now possible to disable mysql_mode="" for an individual cagefs user?
 

GOT

Get Proactive!
PartnerNOC
Apr 8, 2003
1,755
316
363
Chesapeake, VA
cPanel Access Level
DataCenter Provider
Given the way mysql works, I don't think that would ever be possible. Until/if mysql starts supporting different config files for different users and really, mysql is not even directly aware what system user is making a query outside of the mysql user itself.

Its not really terrible to disable strict mode server wide. Its not a security issue.
 
  • Like
Reactions: mtindor

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,295
1,273
313
Houston
I do not believe that is possible still, and agree with @GOT, its unlikely that it would ever possible based on the way MySQL functions. You might want to check in with the folks at CloudLinux to confirm though, you can do that in their forums here: CloudLinux - Main | New template
 

MichaelLoungeIT

Registered
May 21, 2019
4
0
1
Switzerland
cPanel Access Level
DataCenter Provider
isnt this possible with cagefs? so far every cagefs user has its own my.cnf
but this settings doenst seem to have any effect?

as an example..
there is a file in
/var/cagefs/xx/username/etc/my.cnf

i'd like to turn off innodb_strict_mode only for one client, and not serverwide