MySql5.7WindowsUTF-8编码

以管理员身份进入Windows命令行--进入MySql/bin目录

将以下my.ini文件放入/bin目录下

1.net stop mysql停止MySql服务

2.mysqld --remove卸载MySql

先stop后Remove

3.mysqld --install重新安装MySql

4.mysqld --initialize --console初始化数据库，此时data目录下会生成LogFile等。。并且一定要记住系统自动生成的密码会在第6步用到

5.net start mysql启动MySql

先install后initialze

6.mysql -u root -p（系统自动生成的编码）

7.修改密码：ALTER USER 'root'@'localhost' IDENTIFIED BY 'newPassword';

查看mysql数据编码

登录MySQL服务，查看mysql数据库默认的编码

mysql> show variables like '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。

设置mysql数据库编码

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

做如下修改

主要看红色框里的内容

[mysqld]
character-set-server=utf8 
collation-server=utf8_general_ci 

[mysql]
default-character-set = utf8

[mysql.server]
default-character-set = utf8


[mysqld_safe]
default-character-set = utf8


[client]
default-character-set = utf8

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

C:\Windows\system32>sc delete mysql
[SC] DeleteService 成功

C:\Windows\system32>e: cd
E:\>cd E:\0Develop\mysql-5.7.15-winx64\bin

E:\0Develop\mysql-5.7.15-winx64\bin>mysqld --install mysql --defaults-file="E:\0Develop\mysql-5.7.15-winx64\my.ini"
The service already exists!
The current server installed: E:\0Develop\mysql-5.7.15-winx64\bin\mysqld MySQL

E:\0Develop\mysql-5.7.15-winx64\bin>net stop mysql
MySQL 服务正在停止..服务名无效。
请键入 NET HELPMSG 2185 以获得更多的帮助。

E:\0Develop\mysql-5.7.15-winx64\bin>mysqld --install mysql --defaults-file="E:\0Develop\mysql-5.7.15-winx64\my.ini"
Service successfully installed.
E:\0Develop\mysql-5.7.15-winx64\bin>

注意MySql install完成后