修改mysql字符集(乱码解决方案)

1. 修改my.cnf 
vi /etc/my.cnf 
在[client]下添加 
default-character-set=utf8 
在[mysqld]下添加 
default-character-set=utf8 

2.查看字符集设置 
mysql> show variables like 'character_set_%'; 
+--------------------------+----------------------------+ 
| Variable_name             | Value                       | 
+--------------------------+----------------------------+ 
| character_set_client      | utf8                        | 
| character_set_connection | utf8                        | 
| character_set_database    | utf8                        | 
| character_set_filesystem | binary                      | 
| character_set_results     | utf8                        | 
| character_set_server      | utf8                        | 
| character_set_system      | utf8                        | 
| character_sets_dir        | /usr/share/mysql/charsets/ | 
+--------------------------+----------------------------+ 
通过MySQL命令行修改: 
mysql> set character_set_client=utf8; 
Query OK, 0 rows affected (0.00 sec) 
mysql> set character_set_connection=utf8; 
Query OK, 0 rows affected (0.00 sec) 
mysql> set character_set_database=utf8; 
Query OK, 0 rows affected (0.00 sec) 
mysql> set character_set_results=utf8; 

3. 修改数据库的字符集 
    mysql>use mydb 
   mysql>alter database mydb character set utf-8;