How to Resolve - error 1055: sql_mode=only_full_group_by

How to Resolve - error 1055: sql_mode=only_full_group_by

  • 05 Mar, 2025
  • Technology

How to Resolve - error 1055: sql_mode=only_full_group_by



1. Take file backup
cp -p /etc/mysql/my.cnf /etc/mysql/my.cnf.backup2



2. cd /etc/mysql
vi my.cnf (Edit file)


Add the below line at the end of the file

[mysqld]
sql_mode = NO_ENGINE_SUBSTITUTION



save file



4. start MySQL service

sudo systemctl start mysql


5. stop MySQL service

sudo systemctl stop mysql


6. restart MySQL service

sudo systemctl restart mysql


7. Check MySQL Service Status

sudo systemctl status MySQL