mysql中文乱码设置

查看编码集

 show variables like '%char%';

修改编码集

set character_set_server=utf8;
set character_set_database=utf8;
set global character_set_database=utf8;
set global character_set_server=utf8;

进入配置文件后修改

vim /etc/my.cnf 

[mysqld]
character-set-server=utf8
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8

:wq保存退出

重新进入mysql命令行

mysql -u root -p