linux显示mysql中文乱码_linux-记录mysql中文乱码问题

差点被中文搞崩了,写了一个进程,评论功能,结果中文根本无法识别,记录一下中文乱码的问题

查看默认字符集

#mysql -u root - p

#(输入密码)

mysql> show variables like 'character_set%';

可以看到你的编码..我全是utf-8结果还是乱码了.

结果还是会导致中文乱码,

最后发现,其实是需要去修改 /etc/my.cnf的配置文件才可以

在mysqld上面加入[client]标签.插入character-set-server=utf8 而不是 default-character-set=utf8

在mysqld标签中插入character-set-server=utf8 而不是 default-character-set=utf8

否则会报：Starting MySQL...The server quit without updating PID file [失败]lib/mysql/localhost.localdomain.pid).异常

最后在插入[mysql]default-character-set=utf8

# For advice on how to change settings please see

# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

[client]

character-set-server=utf8

[mysqld]

character-set-server=utf8

#

# Remove leading # and set to the amount of RAM for the most important data

# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

# innodb_buffer_pool_size = 128M

#

# Remove leading # to turn on a very important data integrity option: logging

# changes to the binary log between backups.

# log_bin

#

# Remove leading # to set options mainly useful for reporting servers.

# The server defaults are faster for transactions and fast SELECTs.

# Adjust sizes as needed, experiment to find the optimal values.

# join_buffer_size = 128M

# sort_buffer_size = 2M

# read_rnd_buffer_size = 2M

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

# Recommended in standard MySQL setup

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[mysql]

default-character-set=utf8

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

default-character-set=utf8

重新启动mysql服务器

一、启动方式

1、使用 service 启动：service mysqld start

2、使用 mysqld 脚本启动：/etc/inint.d/mysqld start

3、使用 safe_mysqld 启动：safe_mysqld&

二、停止

1、使用 service 启动：service mysqld stop

2、使用 mysqld 脚本启动：/etc/inint.d/mysqld stop

3、 mysqladmin shutdown

三、重启

1、 使用 service 启动：service mysqld restart

完成