在linux中mysql显示中文乱码

先设置好系统的编码LANG=zh_CN.UTF-8(或者修改.bashrc)

 

mysql> show variables like 'character_set_%'; 

+--------------------------+----------------------------------------------------+
| Variable_name            | Value                                              |
+--------------------------+----------------------------------------------------+
| character_set_client     | latin1                                             |
| character_set_connection | latin1                                             |
| character_set_database   | utf8                                               |
| character_set_filesystem | binary                                             |
| character_set_results    | latin1                                             |
| character_set_server     | utf8                                               |
| character_set_system     | utf8                                               |
| character_sets_dir       | /home/users/v_liujun01/local/mysql/share/charsets/ |
+--------------------------+----------------------------------------------------+

然后将latin1的值全部改为utf8

mysql> set character_set_client=utf8;

mysql> set character_set_connection=utf8

mysql> set character_set_results=utf8;

在查看中文就正常了