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"mysql > SET SESSION sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));SET sql_mode = ''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.