1.建立my.cnf文件复制到根目录的/etc下面
2.然后在my.cnf文件下加入
[mysql]
default-character-set=utf8
[mysqld]
character-set-server=utf8
default-storage-engine=INNODB
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
3.重启mysql
##启动MySQL服务
sudo /usr/local/MySQL/support-files/mysql.server start
##停止MySQL服务
sudo /usr/local/mysql/support-files/mysql.server stop
##重启MySQL服务
sudo /usr/local/mysql/support-files/mysql.server restart