07-27-2023, 12:26 PM
For Mac OS Mojave (10.14) Open terminal
$ sudo mkdir /usr/local/mysql-5.7.24-macos10.14-x86_64/etc
$ cd /usr/local/mysql-5.7.24-macos10.14-x86_64/etc
$ sudo nano my.cnf
Paste following:
[mysqld]
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
Shortkeys to Save & Exit nano: `Ctrl+x` and `y` and `Enter`
***Note:*** You might need to update `mysql-5.7.24-macos10.14-x86_64` in these commands, just check the correct folder name you got within `/usr/local/`
Hope it will help someone!
$ sudo mkdir /usr/local/mysql-5.7.24-macos10.14-x86_64/etc
$ cd /usr/local/mysql-5.7.24-macos10.14-x86_64/etc
$ sudo nano my.cnf
Paste following:
[mysqld]
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
Shortkeys to Save & Exit nano: `Ctrl+x` and `y` and `Enter`
***Note:*** You might need to update `mysql-5.7.24-macos10.14-x86_64` in these commands, just check the correct folder name you got within `/usr/local/`
Hope it will help someone!