一、前言

为什么MySQL中存储中文会乱码？

本篇文章解决办法适用范围？

Linux下的mysql 5.6+版本

其他版本未尝试过，不敢保证可行

二、MySQL编码设置

1、查看MySQL字符编码#登录mysql

mysql -u rrot -p

#在mysql中查询字符编码设置

mysql> show variables like '%char%';

+--------------------------------------+----------------------------+

| Variable_name | Value |

+--------------------------------------+----------------------------+

| character_set_client | utf8 |

| character_set_connection | utf8 |

| character_set_database | latin1 |

| character_set_filesystem | binary |

| character_set_results | utf8 |

| character_set_server | latin1 |

| character_set_system | utf8 |

| character_sets_dir | /usr/share/mysql/charsets/ |

| validate_password_special_char_count | 1 |

+--------------------------------------+----------------------------+

如果character_set_database = latin1那说明确实是字符编码造成的乱码问题

2、查找配置文件位置whereis my.cnf

3、修改配置文件

具体请看#修改1，#修改2

# For advice on how to change settings please see

# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

#修改1：增加client配置

[client]

default-character-set=utf8mb4

[mysqld]

#

# Remove leading # and set to the amount of RAM for the most important data

# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

# innodb_buffer_pool_size = 128M

#

# Remove leading # to turn on a very important data integrity option: logging

# changes to the binary log between backups.

# log_bin

#

# Remove leading # to set options mainly useful for reporting servers.

# The server defaults are faster for transactions and fast SELECTs.

# Adjust sizes as needed, experiment to find the optimal values.

# join_buffer_size = 128M

# sort_buffer_size = 2M

# read_rnd_buffer_size = 2M

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

#修改2：增加mysqld配置

#charset

character-set-server=utf8mb4

collation-server=utf8mb4_general_ci

4、重启mysql服务#重启后配置即可生效

systemctl restart mysqld

三、备注相关阅读