mysql5.7 编码统一utf-8

character%‘; +--------------------------+-------------------------------------------------+ | Variable_name | Value | +--------------------------+-------------------------------------------------+ | character_set_client | gbk | | character_set_connection | gbk | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | gbk | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | E:\0Develop\mysql-5.7.15-winx64\share\charsets\ | +--------------------------+-------------------------------------------------+ 8 rows in set, 1 warning (0.00 sec) mysql>

可以看出database和server都采用了latin1编码，不支持中文，我们需要把它修改为utf-8。

除了这两个，其它的如下：

| 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       | E:\0Develop\mysql-<span style="color: #800080;">5.7</span>.<span style="color: #800080;">15</span>-winx64\share\charsets\

在mysql安装目录下，将 my-default.ini 复制一分保存为 my.ini 
做如下修改：

 

主要看红色框里的内容：

<span style="color: #000000;">[mysqld]
character</span>-<span style="color: #0000ff;">set</span>-server=<span style="color: #000000;">utf8 
collation</span>-server=<span style="color: #000000;">utf8_general_ci 
[mysql]
</span><span style="color: #0000ff;">default</span>-character-<span style="color: #0000ff;">set</span> =<span style="color: #000000;"> utf8
[mysql.server]
</span><span style="color: #0000ff;">default</span>-character-<span style="color: #0000ff;">set</span> =<span style="color: #000000;"> utf8
[mysqld_safe]
</span><span style="color: #0000ff;">default</span>-character-<span style="color: #0000ff;">set</span> =<span style="color: #000000;"> utf8
[client]
</span><span style="color: #0000ff;">default</span>-character-<span style="color: #0000ff;">set</span> = utf8

然后删除你当前的mysql服务，再重新注册mysql服务 
注：一定要以管理员的权限运行dos命令，且cd到mysql安装目录下的bin目录，再注册mysql服务

C:\Windows\system32><span style="color: #000000;">sc delete mysql
[SC] DeleteService 成功
C:\Windows\system32</span>><span style="color: #000000;">e: cd
E:\</span>>cd E:\0Develop\mysql-<span style="color: #800080;">5.7</span>.<span style="color: #800080;">15</span>-<span style="color: #000000;">winx64\bin
E:\0Develop\mysql</span>-<span style="color: #800080;">5.7</span>.<span style="color: #800080;">15</span>-winx64\bin>mysqld --install mysql --defaults-file=<span style="color: #800000;">"</span><span style="color: #800000;">E:\0Develop\mysql-5.7.15-winx64\my.ini</span><span style="color: #800000;">"</span><span style="color: #000000;">
The service already exists</span>!<span style="color: #000000;">
The current server installed: E:\0Develop\mysql</span>-<span style="color: #800080;">5.7</span>.<span style="color: #800080;">15</span>-<span style="color: #000000;">winx64\bin\mysqld MySQL
E:\0Develop\mysql</span>-<span style="color: #800080;">5.7</span>.<span style="color: #800080;">15</span>-winx64\bin><span style="color: #000000;">net stop mysql
MySQL 服务正在停止..服务名无效。
请键入 NET HELPMSG </span><span style="color: #800080;">2185</span><span style="color: #000000;"> 以获得更多的帮助。
E:\0Develop\mysql</span>-<span style="color: #800080;">5.7</span>.<span style="color: #800080;">15</span>-winx64\bin>mysqld --install mysql --defaults-file=<span style="color: #800000;">"</span><span style="color: #800000;">E:\0Develop\mysql-5.7.15-winx64\my.ini</span><span style="color: #800000;">"</span><span style="color: #000000;">
Service successfully installed.
E:\0Develop\mysql</span>-<span style="color: #800080;">5.7</span>.<span style="color: #800080;">15</span>-winx64\bin>

结果

启动服务，查看编码：

C:\Windows\System32><span style="color: #000000;">net start mysql
mysql 服务正在启动 .
mysql 服务已经启动成功。
C:\Windows\System32</span>>mysql -<span style="color: #000000;">u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id </span><span style="color: #0000ff;">is</span> <span style="color: #800080;">2</span><span style="color: #000000;">
Server version: </span><span style="color: #800080;">5.7</span>.<span style="color: #800080;">15</span><span style="color: #000000;"> MySQL Community Server (GPL)
Copyright (c) </span><span style="color: #800080;">2000</span>, <span style="color: #800080;">2016</span>, Oracle and/<span style="color: #000000;">or its affiliates. All rights reserved.
Oracle </span><span style="color: #0000ff;">is</span> a registered trademark of Oracle Corporation and/<span style="color: #000000;">or its
affiliates. Other names may be trademarks of their respective
owners.
Type </span><span style="color: #800000;">‘</span><span style="color: #800000;">help;</span><span style="color: #800000;">‘</span> or <span style="color: #800000;">‘</span><span style="color: #800000;">\h</span><span style="color: #800000;">‘</span> <span style="color: #0000ff;">for</span> help. Type <span style="color: #800000;">‘</span><span style="color: #800000;">\c</span><span style="color: #800000;">‘</span><span style="color: #000000;"> to clear the current input statement.
mysql</span>> show variables like <span style="color: #800000;">‘</span><span style="color: #800000;">character%</span><span style="color: #800000;">‘</span><span style="color: #000000;">;
</span>+--------------------------+-------------------------------------------------+
| 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       | E:\0Develop\mysql-<span style="color: #800080;">5.7</span>.<span style="color: #800080;">15</span>-winx64\share\charsets\ |
+--------------------------+-------------------------------------------------+
<span style="color: #800080;">8</span> rows <span style="color: #0000ff;">in</span> <span style="color: #0000ff;">set</span>, <span style="color: #800080;">1</span> warning (<span style="color: #800080;">0.00</span><span style="color: #000000;"> sec)
mysql</span>>

数据库实例编码设置：

mysql><span style="color: #000000;"> show create database test;
</span>+----------+-----------------------------------------------------------------+
| Database | Create Database                                                 |
+----------+-----------------------------------------------------------------+
| test     | CREATE DATABASE `test` <span style="color: #008000;">/*</span><span style="color: #008000;">!40100 DEFAULT CHARACTER SET latin1 </span><span style="color: #008000;">*/</span> |
+----------+-----------------------------------------------------------------+
<span style="color: #800080;">1</span> row <span style="color: #0000ff;">in</span> <span style="color: #0000ff;">set</span> (<span style="color: #800080;">0.00</span><span style="color: #000000;"> sec)
mysql</span>> alter database test <span style="color: #0000ff;">default</span> character <span style="color: #0000ff;">set</span><span style="color: #000000;"> utf8;
Query OK, </span><span style="color: #800080;">1</span> row affected (<span style="color: #800080;">0.00</span><span style="color: #000000;"> sec)
mysql</span>><span style="color: #000000;"> show create database test;
</span>+----------+---------------------------------------------------------------+
| Database | Create Database                                               |
+----------+---------------------------------------------------------------+
| test     | CREATE DATABASE `test` <span style="color: #008000;">/*</span><span style="color: #008000;">!40100 DEFAULT CHARACTER SET utf8 </span><span style="color: #008000;">*/</span> |
+----------+---------------------------------------------------------------+
<span style="color: #800080;">1</span> row <span style="color: #0000ff;">in</span> <span style="color: #0000ff;">set</span> (<span style="color: #800080;">0.00</span><span style="color: #000000;"> sec)
mysql</span>>

参考：http://blog.csdn.net/u013474104/article/details/52486880

 

mysql5.7 编码统一utf-8

标签：