mac下修改mysql sql_mode的方法

558 阅读1分钟

mac下遇到sql_mode报错,解决办法。

修改mysql数据库遇到类似问题:

[Err] 1055 - Expression #1 of ORDER BY clause is not 
in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ'
 which is not functionally dependent on columns in GROUP BY clause; 
this is incompatible with sql_mode=only_full_group_by

解决办法:

cd ~/etc/ sudo vim my.cnf

my.cnf:

[client] default-character-set=utf8

[mysqld] log-error=/usr/local/mysql/data/mysqld.log

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

解决~