1. mac 查找my.cnf文件

      1. mysql --help --verbose | grep my.cnf

    2. 结果

      1. lant@lantmacbook /etc % mysql --help --verbose | grep my.cnf
      2.                    order of preference, my.cnf, $MYSQL_TCP_PORT,
      3. /etc/my.cnf /etc/mysql/my.cnf /usr/local/etc/my.cnf ~/.my.cnf

    3. 结果测试，发现my.cnf文件在/usr/local/etc/my.cnf路径

    4. 修改my.cnf文件，添加

      1. sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

    5. 重启mysql服务

    1. lant@lantmacbook bin % /usr/local/opt/mysql@5.7/bin/mysql.server stop
    2. lant@lantmacbook bin % /usr/local/opt/mysql@5.7/bin/mysql.server start