Level 23
@ScottBaxter You can do it on your database.php definitions. Check out this post from Matt Stauffer's blog, shows all the options:
https://mattstauffer.co/blog/strict-mode-and-other-mysql-customizations-in-laravel-5-2
2 likes
Apr 22, 2016
2
Level 3
Set SET sql_mode on Homestead
Hi Guys,
Hope you're well, I was wondering if it's possible to set the sql_mode on homestead?
I need to specifically disable 'ONLY_FULL_GROUP_BY'.
Thanks, Scott
Level 1
@ScottBaxter You can do it on your database.php definitions. Check out this post from Matt Stauffer's blog, shows all the options:
https://mattstauffer.co/blog/strict-mode-and-other-mysql-customizations-in-laravel-5-2
Thanks, thats solved it for me too.
This article from sitepoint can also be helpful to someone https://www.sitepoint.com/quick-tip-how-to-permanently-change-sql-mode-in-mysql/
Please or to participate in this conversation.