1.在mysql的配置文件my.ini中添加：

[mysqld]
port  = 3306
socket  = /tmp/mysql.sock
character-set-server=utf8
character-set-filesystem = utf8
[client]
password = your password
port  = 3306
socket  = /tmp/mysql.sock
default-character-set=utf8  

特别注意：mysql的默认配置文件是my-default.ini，一定要复制一份改成my.ini，在my.ini里配置，否则配置不会和生效。

2.配置之后,使用命令 show variables like ‘character%’;查看效果

mysql>  show variables like 'character%';
+--------------------------+----------------------------------------------------+
| Variable_name            | Value                                              |
+--------------------------+----------------------------------------------------+
| character_set_client     | utf8                                               |
| character_set_connection | utf8                                               |
| character_set_database   | utf8                                               |
| character_set_filesystem | utf8                                               |
| character_set_results    | utf8                                               |
| character_set_server     | utf8                                               |
| character_set_system     | utf8