1.查询字符集
mysql>show variables like 'char%';
mysql>show variables like 'coll%';
2.更改my.ini文件
[client]
port=3306
[mysql]
default-character-set=utf8
# SERVER SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this
# file.
#
[mysqld]
# The TCP/IP Port the MySQL Server will listen on
port=3306
#Path to installation directory. All paths are usually resolved relative to this.
basedir="D:\Program\MySQL\MySQL Server 5.5"
#Path to the database root
datadir="D:\Program Data\MySQL\MySQL Server 5.5\data"
# The default character set that will be used when a new schema or table is
# created and no character set is defined
#default-character-set=utf8
init_connect='SET collation_connection = utf8_general_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_general_ci
3.重启服务
net stop mysql
net start mysql