linux mysql 乱码

cd /etc/mysql 

sudo vi my.cnf 

[client]添加 

default-character-set=utf8

[mysqld_safe] 

default-character-set=utf8 

[mysqld] 

character_set_server=utf8 
init_connect='SET NAMES utf8'

[mysql] 

default-character-set=utf8 

重启 

sudo /etc/init.d/mysql restart 

如果启动出现错误 

cd /var/log/mysql 

tail -f error.log查看错误消息