解决Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre一路踩过的坑，包括mysql启动问题

傷城~ 2023-06-15 04:57 5阅读 0赞

错误日志：

\[Err\] 1055 - Expression \#1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hema\_app.a.iid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql\_mode=only\_full\_group\_by

首先说下环境:

linux sentos7 + mysql5.7

出现的原因：[https://blog.csdn.net/qq\_34707744/article/details/78031413][https_blog.csdn.net_qq_34707744_article_details_78031413]

参考解决的方式：[https://blog.csdn.net/li1325169021/article/details/78344083][https_blog.csdn.net_li1325169021_article_details_78344083]

上面两个地址是我参考的。

本来在自己本地允许的sql没问题在Linux下就报错了。

linux的mysql中查询：select @@global.sql\_mode

结果为：

ONLY\_FULL\_GROUP\_BY,STRICT\_TRANS\_TABLES,NO\_ZERO\_IN\_DATE,NO\_ZERO\_DATE,ERROR\_FOR\_DIVISION\_BY\_ZERO,NO\_AUTO\_CREATE\_USER,NO\_ENGINE\_SUBSTITUTION

网上说去除ONLY\_FULL\_GROUP\_BY，然后再set进去，执行：

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的配置文件。

接下来就是重启mysql。

好了，踩坑之路开始。

linux的mysql关闭启动等命令：[https://www.cnblogs.com/cuiguangpeng/p/9888879.html][https_www.cnblogs.com_cuiguangpeng_p_9888879.html]

关闭mysql：service mysql stop

关闭没问题，接下来是启动：service mysql start

然后报错：

Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

意思就是我启动的方式不对，然后我去查资料，说让我找到mysql.server文件然后添加到etc/init.d文件夹下。

参考资料：

[https://blog.csdn.net/imliuqun123/article/details/83347081][https_blog.csdn.net_imliuqun123_article_details_83347081]

[https://zhidao.baidu.com/question/1244046803721553819.html][https_zhidao.baidu.com_question_1244046803721553819.html]

然后当我执行find ./\* -name mysql.server的时候什么也没查询出来，然后我发现自己所在的目录不对，需要回到根目录查询。

然后根目录查询，又报错了：

[find: ‘/run/user/1000/gvfs’: 权限不够 的解决办法][find_ _run_user_1000_gvfs_ _]

我也是醉了，我root都没权限，然后继续找资料：

[https://www.cnblogs.com/chenmingjun/p/10311983.html][find_ _run_user_1000_gvfs_ _]

官方说这是一个**bug\[bug\#615848\]**，原因是**FUSE文件系统和权限不配**的问题，全局搜索时碰到它就会退出报错。  
其实这个目录是空的，查不查都没关系。所以，以下解决方式比较简粗暴：

umount /run/user/1000/gvfs    // 卸载该文件
    rm -rf /run/user/1000/gvfs    // 删除该文件

然后再启动还是报错：

Mysql启动错误：Please read "Security" section of the manual to find out how to run mysqld as root!

继续查资料：

[https://www.jianshu.com/p/6f054faf04a4][https_www.jianshu.com_p_6f054faf04a4]

启动方式不对，设置root用户为启动用户。

加入启动参数--user=\[username\]  
配置my.cnf，加入user=mysql意思是使用用户名mysql运行mysqld服务器

然后执行命令：

mysqld --user=mysql --explicit_defaults_for_timestamp

然后再执行：

service mysqld status

总算是好了。好凌乱啊。。。。

运维的活真心作死啊。。。。。

[https_blog.csdn.net_qq_34707744_article_details_78031413]: https://blog.csdn.net/qq_34707744/article/details/78031413
[https_blog.csdn.net_li1325169021_article_details_78344083]: https://blog.csdn.net/li1325169021/article/details/78344083
[https_www.cnblogs.com_cuiguangpeng_p_9888879.html]: https://www.cnblogs.com/cuiguangpeng/p/9888879.html
[https_blog.csdn.net_imliuqun123_article_details_83347081]: https://blog.csdn.net/imliuqun123/article/details/83347081
[https_zhidao.baidu.com_question_1244046803721553819.html]: https://zhidao.baidu.com/question/1244046803721553819.html
[find_ _run_user_1000_gvfs_ _]: https://www.cnblogs.com/chenmingjun/p/10311983.html
[https_www.jianshu.com_p_6f054faf04a4]: https://www.jianshu.com/p/6f054faf04a4

解决Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre一路踩过的坑，包括mysql启动问题

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column

相关 MySQL报错“Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre”解决方法

相关解决Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre一路踩过的坑，包括mysql启动问题

相关 mysql遇见Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre的问题

相关 Docker安装MySQL遇见Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre的问题

相关【MySQL】Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 异常解决

相关 mysql遇见Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre的问题

相关 MySQL：错误Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregate

相关解决MySQL报错Expression #1 of SELECT list is not in GROUP BY clause and contains nonag...

相关 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregate