qq_43427354的博客

MySQL8 “1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column '字段名' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by”的详细解决办法

#查看当前系统已安装的mysql[root@localhost ~]# rpm -qa | grep -i mysqlMySQL-test-5.6.49-1.el7.x86_64MySQL-client-5.6.49-1.el7.x86_64MySQL-embedded-5.6.49-1.el7.x86_64MySQL-shared-5.6.49-1.el7.x86_64MySQL-server-5.6.49-1.el7.x86_64MySQL-devel-5.6.49-1.el7.x86_6

安装Mysql 8.0安装源[root@db ~]# sudo rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm获取https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm警告：/var/tmp/rpm-tmp.V7gbUf: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOK