Problem with removing HomeBrew MySQL 5.6 strict mode on MacOSX High Sierra

I was having a stressful day to solve this, doing the answer on stackoverflow and editing my.cnf on this path does nothing on my system: /usr/local/opt/mysql@5.6/support-files/my-default.cnf /usr/local/etc/my.cnf (by copying from above path) So, here’s the correct path: /usr/local/Cellar/mysql@5.6/5.6.38/my.cnf Remove that damn STRICT_TRANS_TABLES from the sql_mode line will remove the strict mode. Hope this help anyone […]

Read more