Disable ONLY_FULL_GROUP_BY - 7-Views

If you want to disable this from Ubuntu 18+ please follow following details.

Go To Command Prompt

cd /etc/mysql/conf.d
sudo nano disable_strict_mode.cnf

and add following Snippet

[mysqld]
sql_mode=STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

save and then restart and mysql. it will work.

read more