Disable ONLY_FULL_GROUP_BY
xxxxxxxxxx
SET sql_mode = ''
xxxxxxxxxx
mysql > SET SESSION sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
xxxxxxxxxx
Solution 1: Remove ONLY_FULL_GROUP_BY from mysql console
mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
Solution 2: Remove ONLY_FULL_GROUP_BY from phpmyadmin
1. Open phpmyadmin & select localhost
2. Click on menu Variables & scroll down for sql mode
3. Click on edit button to change the values & remove ONLY_FULL_GROUP_BY & click on save.
xxxxxxxxxx
Find file my.ini (C:\ProgramData\MySQL\MySQL Server 8.0\my.ini)
Open as Administratior with text editor.
Find sql-mode and replace with:
sql-mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"