1、复制mysql下的my-default.cnf 到 etc下
sudo cp /usr/local/mysql-5.7.17-macos10.12-x86_64/support-files/my-default.cnf /etc/my.cnf
2、编辑etc/my.cnf
sudo vi /etc/my.cnf
3、设置sql_model
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
4重启mysql
试试一试吧 我装的是mysql 5.7