Windows Mysql乱码

新建一份my.ini，并添加以下内容后重启服务

[mysqld]
character-set-server=utf8
[mysql]
default-character-set=utf8

作用

mysqld用途为修改服务器相关编码character_set_database、character_set_server设置为utf8

mysql用途为修改客户端相关编码character_set_client、character_set_connection、character_set_results设置为utf8

查看mysql编码

mysql> 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       | D:\mysql-5.6.20-winx64\share\charsets\ |
+--------------------------+----------------------------------------+
8 rows in set (0.05 sec)

导入sql数据依旧是乱码

将sql文件用记事本打开，保存编码为utf8，再source导入即可。