1，打開終端
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
在文件的
[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
然后打開文件
sudo vi /etc/mysql/conf.d/mysql.cnf
[mysql]
default-character-set=utf8?#增加這個設置
最后重啟服務就好了。
