![](https://img-blog.csdnimg.cn/20201014180756757.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
9随遇而安
这个作者很懒,什么都没留下…
展开
-
can‘t connect to local mysql server through socket ‘/tmp/mysql.sock‘
连接mysql报如下错误: can't connect to local mysql server through socket '/tmp/mysql.sock' (2) 网上一系列说该文件丢失什么的都不靠谱,最后发现是mysql根本没启动 mac中可以通过页面启动mysql,但是发现怎么启动都不行 网上搜了一把mysql启动错误日志也没看到什么错误信息,日志目录:/usr/local/mysql/data/mysqld.local.err 最后找到原因是权限问题,解决办法是执行以下命.原创 2021-06-30 16:50:50 · 135 阅读 · 0 评论 -
mysql:sql_mode=“only_full_group_by”
select name,gmt_created from db_test group by name数据库里调用如上sql,结果出错,显示“SELECT list is not in GROUP BY clause and contains nonaggregated column” 意思是让我改成select name,gmt_created from db_test group by name原创 2017-06-20 14:13:25 · 453 阅读 · 0 评论