linux下mysql中文乱码

Author Avatar
ieayoio 9月 19, 2016
  • 在其它设备中阅读本文章

登录mysql执行

1
mysql> show variables like 'character%';

发现编码有些不是utf-8

修改/etc/mysql/my.cnf，网上说的是/etc/my.cnf但是没在这个位置找到

然后在[client]中添加

1
default-character-set=utf8

[mysql]中添加

1
default-character-set=utf8

[mysqld]中添加

1
2
3
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8

保存退出

停止mysql服务

1
sudo service mysql stop

再启动mysql服务

1
sudo service mysql start

查看状态

1
sudo service mysql status

登录mysql再执行
mysql> show variables like ‘character%’;

看到编码已经被改变

1
mysql> show variables like 'character%';

1
2
3
4
5
6
7
8
9
10
11
12
13
+--------------------------+----------------------------+
| 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/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

参考链接：

http://www.ha97.com/5359.html

http://www.111cn.net/sys/linux/53209.htm

http://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/

ieayoio博客园：linux下mysql中文乱码

该博文来自于ieayoio的博客：ieayoio’s blog

本文链接：http://www.ieayoio.com/2016/09/19/linux下mysql中文乱码/