100字范文,内容丰富有趣,生活中的好帮手!
100字范文 > centos查看mysql信息_CentOS查看和修改MySQL字符集

centos查看mysql信息_CentOS查看和修改MySQL字符集

时间:2020-03-08 07:55:06

相关推荐

centos查看mysql信息_CentOS查看和修改MySQL字符集

客户提供了MySQL的环境,但是不支持中文,

通过以下命令查看了MySQL的字符集

连接上mysql服务,输入以下命令

mysql>show variables like 'character_set%';

显示如下:

+--------------------------+----------------------------+

| Variable_name | Value |

+--------------------------+----------------------------+

| character_set_client | latin1 |

| character_set_connection | latin1 |

| character_set_database | latin1 |

| character_set_filesystem | binary |

| character_set_results | latin1 |

| character_set_server | latin1 |

| character_set_system | utf8 |

| character_sets_dir | /usr/share/mysql/charsets/ |

+--------------------------+----------------------------+

为了让MySQL支持中文,需要把字符集改变成UTF8,

方法如下:

1. 打开etc/f

2. 修改成如下内容,保存

[client]

port=3306

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

default-character-set=utf8

[mysqld]

datadir=/var/lib/mysql

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

user=mysql

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

symbolic-links=0

character-set-server=utf8

[mysql]

no-auto-rehash

default-character-set=utf8

[mysqld_safe]

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

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

3. 重启mysql服务:service mysqld restart

再次查看mysql编码,已经更新成如下信息

+--------------------------+----------------------------+

| 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/ |

+--------------------------+----------------------------+

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。