1、查看sql_mode
1 2 3 |
select @@sql_mode show variables like '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
2、停止Mysql服务:
1 |
root@localhost:/etc/mysql/mysql.conf.d# service mysql stop |
3、去掉ONLY_FULL_GROUP_BY,重新设置值。
1 |
root@localhost:/etc/mysql/mysql.conf.d# nano mysqld.cnf |
输入或复制以下内容:
1 |
sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES |
重新加载mysql配置文件:
1 |
root@localhost:/etc/mysql/mysql.conf.d# service apparmor reload |
重启Mysql:
1 |
root@localhost:/etc/mysql/mysql.conf.d# service mysql start |