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?
     
    #1 MichaelLoungeIT, May 21, 2019
  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...
    #2 GOT, May 21, 2019
    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...
    #3 cPanelLauren, May 21, 2019
(You must log in or sign up to post here.)
Loading...
Similar Threads - disable mysql strict
  1. Peter N

    STRICT MODE MySQL not disabled by default

    Peter N, Jun 10, 2019, in forum: Database Discussion
    Replies:
    1
    Views:
    108
    Infopro
    Jun 10, 2019
  2. kiopeed

    SOLVED Disable MySQL Strict Mode?

    kiopeed, May 27, 2018, in forum: Database Discussion
    Replies:
    10
    Views:
    11,091
    kiopeed
    May 30, 2018
  3. DingoBlue

    Can I disable mysql strict mode in one cagefs account only?

    DingoBlue, Mar 13, 2018, in forum: Database Discussion
    Replies:
    3
    Views:
    825
    cPanelMichael
    Mar 14, 2018
  4. paul messenich

    SOLVED [CPANEL-21494] UPCP Failure on a server with Mysql Disabled

    paul messenich, Oct 3, 2018, in forum: General Discussion
    Replies:
    1
    Views:
    298
    cPanelMichael
    Oct 3, 2018
  5. Skin

    SOLVED MySQLMyMonLite Error 3167 feature is disabled?

    Skin, Jun 18, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    654
    Skin
    Jun 19, 2018

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.
    Accept Learn More...
    Dismiss Notice