关于mysql导入数据中文乱码问题解析

================mysql5.7改编码为utf8=========

网上很多都是直接改/etc/mysql/my.cnf文件配置

但是有些mysql5.7在改了/etc/mysql/my.cnf后不能正常启动

另一种方法：修改 /etc/mysql/mysql.conf.d/mysqld.cnf

#cd /etc/mysql/mysql.conf.d
#vim mysqld.cnf
末尾加入
character-set-server=utf8
collation-server=utf8_general_ci
skip-character-set-client-handshake
重启mysql:
#cd /etc/init.d/

#service mysql restart

mysql -u root -p

检查：

show variables like 'character%';

+--------------------------+----------------------------+
| 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/ |
+--------------------------+----------------------------+

完成

只有新创建的库才支持utf8。