Hasan Setiawan

A config after MYSQL upgrade

Noo, I got some issue after upgrading mysql to the latest version 5.7.17

Well the issue is about restricted grouping, so I figuring out the problems and it's all abut that. You can try to disable the only_full_group_by setting by executing the following:

              
                  mysql>
                  set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
                  mysql>
                  set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';