disable mysql strict mode per cagefs user

[MichaelLoungeIT]

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]

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.

 

[cPanelLauren]

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]

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