mysql中文乱码解决--5.7.2

1 数据库乱码如下：

 

初始安装mysql后，character_set_server 值是Latin1.导致存入数据库的中文显示？？乱码。

解决方法就是修改my.ini文件

如下：[mysqld]下加以下配置

# server_type=3
[mysqld]

# The next three options are mutually exclusive to SERVER_PORT below.
# skip-networking
# enable-named-pipe
# shared-memory

# shared-memory-base-name=MYSQL

# The Pipe the MySQL Server will use
# socket=MYSQL

# The TCP/IP Port the MySQL Server will listen on
port=3306

character-set-server=utf8mb4
collation-server=utf8mb4_general_ci

 

3 有人可能会问找不到my.ini文件呀？那么默认安装到C盘时路径如下：

C:\ProgramData\MySQL\MySQL Server 5.7\my.ini