springboot 数据库中文乱码

1：编辑器本身编码

2：数据库设置

3：字段设置

4：数据库配置文件

spring.datasource.url = jdbc:mysql://localhost:3306/ggg

库名后需要加

?useUnicode=true&characterEncoding=UTF-8

5：数据库编码查询

show variables like 'char%'

发现character_set_server的编码是latin1

对/etc/my.cnf 进行修改

[client] # 新增客户端的编码default-character-set=utf8[mysql] # 新增客户端的编码，缺省default-character-set=utf8[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 = 2Mdatadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sock# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0# Recommended in standard MySQL setupsql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES # 新增 关于character_set_server的编码设置init-connect='SET NAMES utf8'character-set-server = utf8[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid

这里在mysql中新增了如下记录，来初始化设置mysql数据库服务器的编码：

init-connect='SET NAMES utf8'character-set-server = utf8

然后，重新启动mysql服务：

systemctl restart mysql