Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

disable mysql strict mode per cagefs user

Discussion in 'Database Discussion' started by MichaelLoungeIT, May 21, 2019.

  1. MichaelLoungeIT

    MichaelLoungeIT Registered

    Joined:
    May 21, 2019
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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?
     
  2. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,454
    Likes Received:
    178
    Trophy Points:
    193
    Location:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    mtindor likes this.
  3. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    6,124
    Likes Received:
    474
    Trophy Points:
    233
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice