ubuntu Mysql 5.7 Incorrect string value

现象描述

插入中文后，出现Incorrect string value…的错误

mysql> show variables like ‘character%’; 查看MySQL当前编码格式。

Variable_name	Value
character_set_client	utf8
character_set_connection	utf8
character_set_database	utf8
character_set_filesystem	binary
character_set_results	utf8
character_set_server	utf8
character_set_system	utf8
character_sets_dir	/usr/share/mysql/charsets/

• 除了character_set_filesystem,character_sets_dir其他都为utf8.

• 修改Mysql的配置文件my.cnf，此文件一般在/etc/mysql文件夹下
  增加下文内容：

[client]
default-character-set=utf8

[mysqld]
character-set-server=utf8

• 保存退出，重启服务