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!

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

Discussion in 'Database Discussion' started by DingoBlue, Mar 13, 2018.

  1. DingoBlue

    DingoBlue Member

    Joined:
    Dec 3, 2010
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Root Administrator
    I am using on a VPS service:
    WHM 68.0.30
    MySQL 5.6.38
    php 7.1.15

    I have root access in WHM.

    I host several sites, all in a cagefs environment. Most use MySQL and currently all are set to strict mode (sql_mode='NO_ENGINE_SUBSTITUTION').

    For 1 account, I would like to change this to:
    sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

    I understand that where at all possible Strict Mode should be left as the MySQL default as to do otherwise has some risk of db corruption if the users code is not what it should be.

    Is it possible to change strict mode for a single account? If it is, how can I accomplish this? I assure you I have tried but cannot get it to "take". I have edited my.cnf within cagefs/sitexxx/etc but no effect.

    Any assistance greatly appreciated.
    Regards
     
    #1 DingoBlue, Mar 13, 2018
  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,890
    Likes Received:
    91
    Trophy Points:
    78
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hi,

    No, that is no possible. Isolation of my.cnf is not yet implemented. Only application isolation has been accomplished thus far and not the database server isolation..
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 24x7server, Mar 14, 2018
  3. DingoBlue

    DingoBlue Member

    Joined:
    Dec 3, 2010
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    51
    cPanel Access Level:
    Root Administrator
    Hi 24x7server, thank you for that information. Iwas afraid that was going to be the answer as I don't like compromising users if I can avoid it.

    Regards
     
    #3 DingoBlue, Mar 14, 2018
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,005
    Likes Received:
    2,123
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    I'm glad to see the earlier post helped to answer your question. Let us know if you require any additional assistance.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelMichael, Mar 14, 2018
(You must log in or sign up to post here.)
Loading...
Similar Threads - disable mysql strict
  1. MichaelLoungeIT

    disable mysql strict mode per cagefs user

    MichaelLoungeIT, May 21, 2019 at 4:16 AM, in forum: Database Discussion
    Replies:
    2
    Views:
    36
    cPanelLauren
    May 21, 2019 at 11:18 AM
  2. kiopeed

    SOLVED Disable MySQL Strict Mode?

    kiopeed, May 27, 2018, in forum: Database Discussion
    Replies:
    10
    Views:
    10,046
    kiopeed
    May 30, 2018
  3. 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:
    262
    cPanelMichael
    Oct 3, 2018
  4. Skin

    SOLVED MySQLMyMonLite Error 3167 feature is disabled?

    Skin, Jun 18, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    591
    Skin
    Jun 19, 2018
  5. hicom

    SOLVED UPCP Failure on a server with Mysql Disabled

    hicom, Nov 9, 2017, in forum: General Discussion
    Replies:
    7
    Views:
    873
    cPanelMichael
    Dec 18, 2017

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