mysql --help | grep 'Default options' -A 1
查看mysql配置文件默认位置若没有配置文件,拷贝创建一个
sudo cp /usr/local/mysql/support-files/my-small.cnf /etc/my.cnf
修改my.cnf
[client]
default-character-set=utf8
[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci
进入:mysql -u root -p
查看编码
show variables like 'character%';