2 Replies Latest reply on Apr 15, 2020 8:55 AM by Sunny kichloo

    How configure my.cnf in mysql5.7 with: SET GLOBAL sql_mode = sys.list_drop(@@sql_mode, 'ONLY_FULL_GROUP_BY');

    4221600
    4221600 Apr 6, 2020 4:19 PM

      Hi,

       

      I have to drop this property from variable sql_mode.

       

      In mysql client I execute:

      SET GLOBAL sql_mode = sys.list_drop(@@sql_mode, 'ONLY_FULL_GROUP_BY');

       

      When I try editing in my.cnf file (and restart the service) I realize that this configuration is not taken this change,

       

      I tried with many options in my.cnf like:

       

      1. sql_mode = "STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
      2. sql_mode = "NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
      3. sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
      4. sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
      5. sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

       

      Anybody know what's happend?, thanks a lot.