LINUX数据库取出来的中文乱码或者变成问号?？

拼搏现实的明天。 2023-07-07 14:00 37阅读 0赞

# 1.登录mysql #

mysql -u root -p

# 2.如果出现以下情况，则取出来的中文就会乱码或者变成问号 #

show variables like '%char%';

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5ODk4MTkx_size_16_color_FFFFFF_t_70]

# 3.service mysql stop关闭mysql，vim /etc/my.cnf,在mysqld下添加如下一行代码 #

character_set_server= utf8

![在这里插入图片描述][20200224092445887.png]  
**若/etc/my.cnf不存在，则将/usr/local/mysql/support-files/my-default.cnf复制到/etc/my.cnf**

cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf

# 4.重新启动mysql #

service mysql start

**登录mysql**

mysql -u root -p

**再次查看,所出现一下情况则成功了：**

show variables like '%char%';

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5ODk4MTkx_size_16_color_FFFFFF_t_70 1]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5ODk4MTkx_size_16_color_FFFFFF_t_70 2]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5ODk4MTkx_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200224092157276.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5ODk4MTkx,size_16,color_FFFFFF,t_70
[20200224092445887.png]: https://img-blog.csdnimg.cn/20200224092445887.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5ODk4MTkx_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200224094134836.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5ODk4MTkx,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5ODk4MTkx_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200224094218416.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM5ODk4MTkx,size_16,color_FFFFFF,t_70