linux下mysql中文乱码
登录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
3collation-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 | +--------------------------+----------------------------+ |
参考链接:
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