vi /etc/mysql/my.cnf
[client]default-character-set=utf8
[mysqld_safe]
default-character-set=utf8
[mysqld]
character_set_server=utf8
[mysql]
default-character-set=utf8
show variables like "%coll%";
show variables like "%char%";
set character_set_database=utf8;
set character_set_server=utf8;
set collation_database=utf8_general_ci;
set collation_server=utf8_general_ci;
show create database web;
ALTER DATABASE `web` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
show create table auth_user;
alter table auth_user convert to character set utf8;