mysql -u xxx -p
mysql> show variable like '%char%';
mysql> statusvi /etc/mysql/my.cnf
[client]
port = 3306
default-character-set = utf8
[mysqld]
character-set-server = utf8
init_connect = 'SET NAMES utf8'
[mysql]
default-character-set = utf8restart mysql
sudo /etc/init.d/mysql restart