mysql client乱码解决

mysql client cmd操作的时候出现了中文乱码，增删改查都受到了影响。我的解决方式如下

1.SHOW VARIABLES LIKE 'CHAR%';

mysql> SHOW VARIABLES LIKE 'CHAR%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | latin1                     | 
| character_set_connection | latin1                     | 
| character_set_database   | latin1                     | 
| character_set_filesystem | binary                     | 
| character_set_results    | latin1                     | 
| character_set_server     | latin1                     | 
| character_set_system     | utf8                       | 
| character_sets_dir       | /usr/share/mysql/charsets/ | 
+--------------------------+----------------------------+

2.改变字符集

set character_set_connection=gbk;

set character_set_*=gbk;

把所有的上述的Variable_name的value值

以上的修改是临时的修改

php 操作数据库中文乱码问题

$connection=mysql_connect ($localhost, $username, $password);
mysql_query('SET NAMES utf8'); //防止乱码
$db_selected = mysql_select_db($database, $connection);
if (!$db_selected) {
  die ('Can\'t use db : ' . mysql_error());
}