Execute query statement in local query successful online server query failure!!

Exception information

Error code:  1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'like.like_blog_merge.account_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_byCopy the code

Methods a

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';
Copy the code
FLUSH PRIVILEGES; // Refresh the databaseCopy the code

The query can be normal, but after restarting the service will still occur!!

Way 2

Find the/etc/mysql/conf. D/mysql CNF, paste the following content in the file at the bottom, restart can!!!!!!

[mysqld] sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBST ITUTIONCopy the code

House watch order!!

Systemctl restart mysql // Restart mysql systemctlstartMysql // Start mysql systemctlstopMysql // Stop mysql systemctlstatusMysql // Check the current status of mysqlCopy the code