mysql
小妖的黑色城堡
这个作者很懒,什么都没留下…
展开
-
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated.
因为要按照各Jenkins+sonar的自动化部署加监测的环境,之前使用的mysql5.1不支持sonar,所以重新装了mysql5.7版本,但是安装之后项目报错[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated.上网查了下找到解决办法,分享一下:htt...原创 2018-03-30 13:30:10 · 411 阅读 · 0 评论 -
java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist 解决方法
新安装了mysql5.7版本:报错权限问题,授权给 root 所有sql 权限mysql> grant all privileges on *.* to root@"%" identified by ".";mysql> flush privileges;转载 2018-03-30 13:31:18 · 4298 阅读 · 1 评论