Disable ONLY_FULL_GROUP_BY

Question

I accidentally enabled ONLY_FULL_GROUP_BY mode like this: ``` SET sql_mode = 'ONLY_FULL_GROUP_BY'; ``` How do I disable it?

Accepted Answer

Solution 1: Remove ONLY_FULL_GROUP_BY from mysql console

```
mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
```

you can read more here

Be aware that this setting is NOT persistent across restarts, then use

```
mysql > SET PERSIST sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
```

Solution 2: Remove ONLY_FULL_GROUP_BY from phpmyadmin

- Open phpmyadmin & select localhost

- Click on menu Variables & scroll down for sql mode

- Click on edit button to change the values & remove ONLY_FULL_GROUP_BY & click on save.

Solution