disable mysql strict mode per cagefs user

MichaelLoungeIT

• May 21, 2019 04:16

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

  • May 21, 2019 12:46

  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.

  0
• 

  cPanelLauren

  • May 21, 2019 16:18

  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

  0
• 

  MichaelLoungeIT

  • February 14, 2020 09:49

  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

  0

Please sign in to leave a comment.