If you have control of the server and you are running legacy code you can’t easily change, you can adjust the SQL mode of the server and remove “only_full_group_by” either for the duration of boot, by running the query
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));'
or by adding
sql_mode='' to your my.cnf file.
Obviously its better to change your code if you have the possibility, but if not, this will disable that warning.
For reference, if you go the route of adding
sql_mode=''to your my.cnf file, be sure to add this line under a new line with the
[mysqld]heading. For example:
sql_mode = ''. Otherwise, you’ll get an error when attempting to restart
Job for mysql.service failed because the control process exited with error code.