进入mysql
mysql -u root -p
查看当前编码:
service mysql restart
打开此文件修改
sudo vim /etc/mysql/conf.d/mysql.cnf
修改之后的配置文件如下所示:
[mysql]
default-character-set=utf8
[mysqld]
character-set-server=utf8
重启数据库
service mysql restart
mysql -u root -p
service mysql restart
sudo vim /etc/mysql/conf.d/mysql.cnf
[mysql]
default-character-set=utf8
[mysqld]
character-set-server=utf8
service mysql restart