1.检查自己数据库编码
# mysql -uroot -proot
# show VARIABLES like 'char%';
![](https://img.haomeiwen.com/i2743275/aed00e544adf23d4.png)
2.更改Client和Server编码都是UTF-8
# vim /etc/my.cnf.d/server.cnf
在server.cnf中[mysqld]添加如下代码
init-connect='SET NAMES utf8'
character-set-server = utf8
![](https://img.haomeiwen.com/i2743275/109f93534d06e671.png)
重启MariaDB即可
# systemctl restart mariadb
如果已经添加为服务
# service mysqld restart
网友评论