Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

4221600Apr 6 2020 — edited Apr 15 2020

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.

Comments

Post Details

Added on Apr 6 2020
2 comments
2,932 views