修改编码为gb2312

1.MySQL输入命令 【show variables like'%char%';】

出现：

ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    1
Current database: test

+--------------------------+---------------------------------------------------------------+
| Variable_name            | Value                                                         |
+--------------------------+---------------------------------------------------------------+
| character_set_client     | latin1                                                        |
| character_set_connection | latin1                                                        |
| character_set_database   | gb2312                                                        |
| character_set_filesystem | binary                                                        |
| character_set_results    | latin1                                                        |
| character_set_server     | gb2312                                                        |
| character_set_system     | utf8                                                          |
| character_sets_dir       | C:\Program Files (x86)\MySQL\MySQL Server 5.5\share\charsets\ |
+--------------------------+---------------------------------------------------------------+
8 rows in set (1.01 sec)

2.在my.ini文件下修改编码

找到MySQL安装文件中my.ini文件----找到两个目录"mysql"和"mysqld"----修改掉里面的utf8为gb2312

3.结果

show variables like'%char%';
+--------------------------+---------------------------------------------------------------+
| Variable_name            | Value                                                         |
+--------------------------+---------------------------------------------------------------+
| character_set_client     | latin1                                                        |
| character_set_connection | latin1                                                        |
| character_set_database   | gb2312                                                        |
| character_set_filesystem | binary                                                        |
| character_set_results    | latin1                                                        |
| character_set_server     | gb2312                                                        |
| character_set_system     | utf8                                                          |
| character_sets_dir       | C:\Program Files (x86)\MySQL\MySQL Server 5.5\share\charsets\ |
+--------------------------+---------------------------------------------------------------+
8 rows in set (0.00 sec)

所以我决定,重新卸载安装

后续再更