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!

Upgrade to MariadDB 10.2

Discussion in 'Database Discussion' started by schatzman, Jul 4, 2018.

  1. schatzman

    schatzman Member

    Joined:
    Apr 9, 2017
    Messages:
    23
    Likes Received:
    2
    Trophy Points:
    3
    Location:
    europe
    cPanel Access Level:
    Website Owner
    hello

    im thinking about upgrading to MraiaDB 10.2 , im getting a warning strict mode will be enabled by default. Is it possible to turn off strict mode after upgrade? as i have many applications that dont support strict mode..

    thanks
    Matan
     
  2. cPanelLauren

    cPanelLauren Forums Analyst
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    2,721
    Likes Received:
    186
    Trophy Points:
    143
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    schatzman likes this.
  3. AndrewN

    AndrewN Member

    Joined:
    May 26, 2018
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Please try with the following steps.

    1) Edit /etc/my.cnf and add
    Code:
    [mysqld]
    sql_mode="TRADITIONAL,NO_AUTO_CREATE_USER"

    2)verified that the mode was previously set
    Code:
    root@000 [~]# mysql -e 'select @@GLOBAL.sql_mode;'
    +-------------------+
    | @@GLOBAL.sql_mode |
    +-------------------+
    | |
    +-------------------+

    3) Restart MySQL
    Code:
    root@000[~]# /scripts/restartsrv mysql
    Waiting for mysql to restart...............finished.

    4) Check MySQL
    Code:
    root@000 [~]# mysql -e 'select @@GLOBAL.sql_mode;'
    +-------------------------------------------------------------------------------------------------------------------------------+
    | @@GLOBAL.sql_mode |
    +-------------------------------------------------------------------------------------------------------------------------------+
    | STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER |
    +-------------------------------------------------------------------------------------------------------------------------------+
    root@000 [~]#
     
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