设置mysql数据库使用utf8编码

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;