MySql 在 Linux中字符集导致乱码问题的解决

1 查看字符集

show variables like 'character%';
show variables like '%char%';

看看出现的结果：

 

默认的是客户端和服务器都用了latin1，所以会乱码。

2 修改

1) 首先应该复制配置文件

 2) 进入 etc 中的配置文件中   vim /etc/my.cnf   增加设置字符集的字段

[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock
default-character-set=utf8
# The MySQL server
[mysqld]
port = 3306
character_set_server=utf8
character_set_client=utf8
collation-server=utf8_general_ci
socket = /var/lib/mysql/mysql.sock
skip-external-locking
key_buffer_size = 384M
max_allowed_packet = 1M
table_open_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
[mysql]
no-auto-rehash
default-character-set=utf8

3 重启mysql

service mysql stop;
service mysql start;

4 重新连接后重新create databse并使用新建库，然后再重新建表试试  必须新建，只有新建的库和表才生效

5 还是乱码的话就设值init_connect='SET NAMES utf8'