problem s trvalym nastavenim sql_mode na osx 10.11

Nazdar,

uz hodnu chvilku riesim problem s errorm v nette

SQLSTATE[42000]: Syntax error or access violation:
1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated
column 'my_database_name.my_table.id' which is not functionally dependent on columns
in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Mam cistu instalaciu osX 10.11 a manualne som nainstaloval apache php a mysql podla tohto navodu
https://coolestguidesontheplanet.com/…-el-capitan/

verzia apache

$ httpd -v
Server version: Apache/2.4.18 (Unix)
Server built:   Feb 20 2016 20:03:19

Mysql verzia:

Server version: 5.7.11 MySQL Community Server (GPL)

Viem ze problem je v sql mode, ktory ale neviem natrvalo nastavit..
Ked v admineri spustim tento kod, vsetko bezi spravne az do restartu mysql

SET GLOBAL sql_mode = 'NO_ENGINE_SUBSTITUTION';

Skusal som aj tieto navody
http://stackoverflow.com/…ode-in-mysql
a nastavit subor my.cnf v kazdom adresari ako je mozno vidiet nizsie.
Po kazdom som to restartol a stale nic… akoby mysql tieto subory uplne odignoroval…

$ mysql --help | grep /my
/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf

Uz som v celku zufaly a rad by som ak by ste mi pohohli :)

Robo

Editoval robovarga (10. 4. 2016 14:56)