Config disable strict SQL mode for a Homebrew-installed MySQL server

disable_strict_mode_mac_homebrew.md

1. Find config file:

mysqld --help --verbose | grep my.cnf

In my case, it's locate at: /usr/local/etc/my.cnf, show content and find config directory path.

2. Create new file at this path:

/usr/local/etc/my.cnf.d/disable_strict_mode.cnf

3. Enter two lines:

[mysqld]
sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

4. Restart mysql:

brew services restart mysql

Thank you!

This helped me with mysql@5.7 and using home folder my.cnf override:

// MYSQL relax sql mode
$ touch ~/.my.cnf
$ vim ~/.my.cnf
insert this ===>>>
[mysqld]
sql_mode = ""
<<<===
$ brew services restart mysql@5.7