mysql解压版修改字符编码_（ 解压缩版 免安装版 或 zip版 ）如何修改mysql5.6.24 字符编码...

1、当我们把zip文件格式解压到指定目录后，并且完成基本环境配置后，打开mysql 5.6.24会发现名为【my-default.ini】的文件。我们用记事本打开该文件会发现并没有【default-character-set = xxx】或者【character_set_server=xxx】，怎么回事呢？网上给出的许多方法都是直接修改这句话的xxx为utf8，不急，下面请看第二步：

2、复制该文件，并且命名为【my.ini】，这样根目录下就有两个.ini文件了，一个是my-default.ini，一个是my.ini 。接下来我们只需修改my.ini里面的内容就行了。请看第三步：

3、修改【my.ini】,

在[mysqld]下面添加 character_set_server=utf8，注意是【utf8】不是【utf-8】而且后面没有任何标点符号；

在【sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES】这句话后面再添加三行：

[client]

port=3306

default-character-set=utf8

4、经过以上三步就ok了。保存后重启服务器，登陆后在命令行输入：【show variables like 'char%';】可查看默认字符集如下图所示：

5、我的【my.ini】代码，红色代码区为修改之处

：my.ini文件following。

1 # For advice on how to change settings please see2 # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

3 # *** DO NOT EDIT THIS FILE. It's a template which will be copied to the

4 # *** default location during install, and will be replaced ifyou5 # ***upgrade to a newer version of MySQL.6

7 [mysqld]8

9 # Remove leading # and set to the amount of RAM forthe most important data10 # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.11 # innodb_buffer_pool_size =128M12

13 # Remove leading # to turn on a very important data integrity option: logging14 # changes to the binary log between backups.15 # log_bin16

17 # These are commonly set, remove the # and set asrequired.18 basedir = D:\mysql-5.6.24-winx6419 datadir = D:\mysql-5.6.24-winx64\data20 port = 3306

21 # server_id =.....22 character_set_server=utf823

24 # Remove leading # to set options mainly useful forreporting servers.25 # The server defaults are faster fortransactions and fast SELECTs.26 # Adjust sizes asneeded, experiment to find the optimal values.27 # join_buffer_size =128M28 # sort_buffer_size =2M29 # read_rnd_buffer_size =2M30

31 sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES32

33 [client]34 port=3306

35 default-character-set=utf8