• 设置字符集为utf-8

1. /etc/mysql/conf.d/mysql.cnf 文件添加

default-character-set=utf8

2. /etc/mysql/mysql.conf.d/mysqld.cnf 文件添加

character-set-server=utf8

• 配置sql_mode，兼容MySQL5.5

1. /etc/mysql/mysql.conf.d/mysqld.cnf 文件添加

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

• 重启服务器生效，设置完成重启后后再创建数据库和表