Disabling MySQL Strict Mode on OS X

Another useful tidbit for someone (or possibly my future self).

MySQL did not like the default value for my datetime fields when running an import command.

`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'

To resolve the issue, I had to do a few things, the first is enabling MySQL commands from the terminal. I usually use Navicat Premium as it's got a great UI and with all my bookmarked connections I can visually switch between them at will. Should the need arise, you can enable the mysql command from your terminal using the following;

$ echo 'export PATH=/usr/local/mysql/bin:$PATH' >> ~/.bash_profile $ . ~/.bash_profile

That should enable MySQL, so now to log in and fix the issue; which is that MySQL by default has strict mode enabled.

$ mysql -u{username} -p $ set sql_mode=NO_ENGINE_SUBSTITUTION; set global sql_mode=NO_ENGINE_SUBSTITUTION;

Voila! No more import issues.


A tech native with 20 years of experience across the digital space. Darryl is an evangelist for the power and disruption of blockchain technologies and fosters a passion for bringing ever greater utility and adoption to the masses.

Copyright © 2016-2023 Bonbon Group Ltd. All Rights Reserved.