linux mysql 设置utf-8解决中文无法插入问题

需要修改的文件

/etc/mysql/conf.d/mysql.cnf

/etc/mysql/mysql.conf.d/mysqld.cnf

步骤

修改配置文件

vi /etc/mysql/conf.d/mysql.cnf

修改成如下

[mysql]
default-character-set=utf8

vi /etc/mysql/mysql.conf.d/mysqld.cnf

找到 [mysqld]
增加一行： character-set-server=utf8
修改后如下

[mysqld]
#
# * Basic Settings
#
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql

character-set-server=utf8

skip-external-locking

重启mysql服务

 systemctl restart mysql.service

或者

service mysql restart

补充说明

修改配置后 创建的数据库字符编码默认都是utf-8