在mac中修改mysql的sql_mode

最新推荐文章于 2024-07-03 03:19:35 发布

hp15

最新推荐文章于 2024-07-03 03:19:35 发布

阅读量1.6k

点赞数 1

分类专栏： mac 文章标签： mysql mac

本文链接：https://blog.csdn.net/haponchang/article/details/104628752

版权

在mac环境中遇到MySQL5.7报错'Expression #11 of SELECT list is not in GROUP BY clause...'，原因是系统缺少my-default.cnf配置文件。解决方法是创建新的my.cnf文件，在/etc目录下使用sudo vim编辑，设置sql_mode，保存并退出，然后重启MySQL服务。

摘要由CSDN通过智能技术生成

项目中报错“Expression #11 of SELECT list is not in GROUP BY clause and。。。 ”

后查出是mac的问题，MySQL5.7之后针对mac端，并且没有my-default.cnf的用户，需要调整配置信息。

修改期间必须关闭mysql

我们要在/etc下新建my.cnf
$ cd /etc
$ sudo vim my.cnf

my.cnf文件如下

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL

[client]
default-character-set=utf8

[mysqld]
log-error=/usr/local/mysql/data/mysqld.log
# skip-grant-tables
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: lo