On Mac edit my.cnf file
replace
sql-mode=“STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”
with
sql-mode=“NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”
Or
run this query
SET @@global.sql_mode= ‘’;
On Mac edit my.cnf file
replace
sql-mode=“STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”
with
sql-mode=“NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”
Or
run this query
SET @@global.sql_mode= ‘’;
Thanks for sharing George.