I'm trying to disable ONLY_FULL_GROUP_BY, NO_ZERO_IN_DATE, NO_ZERO_DATE in MAMP PRO mysql. I've changed my.cnf in mysql templates, restart mysql server but unfortunately it's still the same. So, what i'm doing wrong? How to fix?
To disable ONLY_FULL_GROUP_BY in MySQL, remove ONLY_FULL_GROUP_BY from the sql-mode setting in the MySQL configuration file, /etc/my. cnf . This file can only be modified via SSH as the root user or WHM >> Terminal. ONLY_FULL_GROUP_BY cannot be disabled for a single account or database.
If the ONLY_FULL_GROUP_BY SQL mode is enabled (which it is by default), MySQL rejects queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are neither named in the GROUP BY clause nor are functionally dependent on them.
Run this command: mysql > SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); Another way to turn it off is that to find and modify the config file my. cnf .
Just faced this issue today. I'll leave an answer for the record. It's based in this article.
On MAMP PRO go to File > Edit Template > MySQL.
In the editor, find [mysqld] line. Beneath that line add the following:
sql_mode=STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
(applied to this particular question)
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
(this is what I actually used)
where to place the code
Cheers and keep coding.
You're using double quotes in your example. Use single quotes
sql_mode = ''
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With