The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How change MySQL strict mode to null mode

Discussion in 'E-mail Discussions' 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:
    383
    Likes Received:
    7
    Trophy Points:
    18
    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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page