Upgrade to MariadDB 10.2

schatzman

• July 04, 2018 02:49

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

• 

  cPanelLauren

  • July 04, 2018 19:25

  hi @schatzman You will be able to disable strict mode should you want to. Please see the thread below for how to do this

  0
• 

  AndrewN

  • July 04, 2018 19:59

  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 [~]#

  0

Please sign in to leave a comment.