CentOS查看和修改MySQL字符集
来源:互联网 发布:周边手办数据 编辑:程序博客网 时间:2024/05/22 18:52
转载自:http://blog.csdn.net/ouitiken/article/details/23171327
客户提供了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/my.cnf
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/ |
- +--------------------------+----------------------------+
0 0
- CentOS查看和修改MySQL字符集
- CentOS查看和修改MySQL字符集
- mysql查看和修改字符集的命令
- mysql查看和修改字符集的命令
- mysql查看和修改字符集的命令
- MySQL查看和修改字符集的方法
- 查看修改MySQL字符集
- 查看修改MySQL字符集
- MYSQL查看修改字符集
- 查看修改MySQL字符集
- windows + CentOS查看和修改MySQL字符集,使其支持中文
- mysql字符集查看以及修改
- mysql字符集查看以及修改
- mysql字符集查看以及修改
- MySQL字符集编码查看 修改。
- mysql查看修改字符集-转
- 在Mysql数据库中查看和修改字符集
- C语言如何查看和修改MySQL使用的字符集
- Codeforces Round #316 (Div. 2)(ABCD)
- 二元多项式
- Codeforces Round #316 (Div. 2) D. Tree Requests(DFS+状态压缩)
- Yahoo!军规详解
- 对机器学习江湖的认识
- CentOS查看和修改MySQL字符集
- org.codehaus.jackson.map.JsonMappingException: Can not deserialize
- JAVA日志系统
- linux环境变量设置方法总结(PATH/LD_LIBRARY_PATH)
- D - A very hard Aoshu problem----(2015 summer training #12(Team_Qualifying))
- 使用jsp读取HTML格式文件
- Tomcat6配置数据源
- 64Minimum Path Sum
- HDU 1017 A Mathematical Curiosity (枚举水题)