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