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!

How change MySQL strict mode to null mode

Discussion in 'E-mail Discussion' started by Derek Lee, Sep 29, 2016.

  1. Derek Lee

    Derek Lee Registered

    Joined:
    Sep 29, 2016
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Malaysia
    cPanel Access Level:
    Website Owner
    Hi
    I need to turn off MySQL strict mode to for couple of application to work properly. We have change it before unfortunately once the MySQL server restart the sql mode is again set to strict mode. , in that case again the site will not save any data or process the data. Please advise how to change the MySQL mode
    System is as follows :
    WHM 58.0 (build31)
    Centos 6.8
    MySQL 5.6.3

    Thank you
    Derek
     
  2. ruzbehraja

    ruzbehraja Well-Known Member

    Joined:
    May 19, 2011
    Messages:
    392
    Likes Received:
    11
    Trophy Points:
    68
    cPanel Access Level:
    Root Administrator
     
    dortgendizayn and cPanelMichael like this.
  3. Derek Lee

    Derek Lee Registered

    Joined:
    Sep 29, 2016
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Malaysia
    cPanel Access Level:
    Website Owner
    Hi Ruzbehraja,

    Thank you for the info
     
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,249
    Likes Received:
    1,940
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    I'm happy to see the information in that post helped. Let us know if you have any additional questions.

    Thank you.
     
    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