Turn off Mysql Strict Mode

psytanium

• March 04, 2017 04:23

Hello, After I migrated to a new VPS server, some websites started to show sql errors. I discovered I have to turn off Strict Mode. Strick Mode can be turned off only from SSH ? or is it available in cPanel settings ? Should I edit the file etc/my.cnf only or /usr/my.cnf too ? Should I changed sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES to 1 - sql_mode ="" 2 - sql_mode ='' 3 - sql_mode="NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" ? Thank you

• 

  SysSachin

  • March 05, 2017 13:50

  Hello, Please try with the following steps. 1) Edit /etc/my.cnf and add
  [mysqld] sql_mode="TRADITIONAL,NO_AUTO_CREATE_USER"
  2)verified that the mode was previously set
  root@000 [~]# mysql -e 'select @@GLOBAL.sql_mode;' +-------------------+ | @@GLOBAL.sql_mode | +-------------------+ | | +-------------------+
  3) Restart MySQL
  root@000[~]# /scripts/restartsrv mysql Waiting for mysql to restart...............finished.
  4) Check MySQL
  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
• 

  cPanelMichael

  • March 06, 2017 15:05

  Hello, You may also want to verify that /usr/my.cnf does not exist on the system, as it will overwrite your /etc/my.cnf file settings. If it does exist, try disabling this file and restarting MySQL:
  mv /usr/my.cnf /usr/my.cnf.backup1 /scripts/restartsrv_mysql
  Thank you.

  0

Please sign in to leave a comment.