查找mysqld所在位置

which mysqld

结果显示：
/usr/sbin/mysqld

找到mysqld服务所用配置文件

 /usr/sbin/mysqld --verbose --help | grep -A 1 "Default options"

结果显示：
Default options are read from the following files in the given order:
/etc/mysql/my.cnf ~/.my.cnf /usr/etc/my.cnf

修改配置文件 vim /etc/mysql/my.cnf

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8

重启mysql

service mysql restart