mysql 乱码
来源:互联网 发布:易网网络传媒有限公司 编辑:程序博客网 时间:2024/04/29 04:19
修改乱码最终需要达到所有编码均为utf8的目的,如最下图。
默认登录mysql之后show variables like ‘%character%’, 出现
mysql> show variables like 'character%';+--------------------------+-----------------------------------------------------------+
| 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/local/mysql-5.0.51a-linux-i686/share/mysql/charsets/ |
+--------------------------+-----------------------------------------------------------+
1. 找到mysql的配置文件,拷贝到etc目录下,第一步很重要
[root@xatarena /]# find / -name "*.cnf"
[root@xatarena /]# cp /usr/local/mysql-5.0.51a-linux-i686/support-files/my-large.cnf /etc/my.cnf
[root@xatarena /]# vi /etc/my.cnf
找到[client] 添加:
找到[mysqld] 添加:
//默认字符集为utf8
default-character-set=utf8
//设定连接mysql数据库时使用utf8编码,以让mysql数据库为utf8运行
init_connect='SET NAMES utf8'
[root@xatarena /]# sudo ./etc/init.d/mysql stop
Shutting down MySQL. [确定]
[root@xatarena /]# sudo ./etc/init.d/mysql start
Starting MySQL [确定]
在查询一下:
mysql> show variables like 'character%';
+--------------------------+-----------------------------------------------------------+
| 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/local/mysql-5.0.51a-linux-i686/share/mysql/charsets/
- PHP乱码?Mysql乱码?
- MySql乱码
- MySql乱码
- mysql 乱码
- MySql乱码
- MySQL乱码
- Mysql 乱码
- mysql 乱码
- mysql 乱码
- mysql 乱码
- mysql 乱码
- mysql 乱码
- Mysql乱码
- mysql 乱码
- Mysql乱码
- mysql 乱码
- mysql乱码
- mysql--乱码
- Ubuntu_ubuntu显示分辨率设置
- 8种常见的Java不规范代码
- 大家都来看看这个随机发牌的小程序代码。给出一点改进的建议,或者能找出点瑕疵,,呵呵
- 红尘恋歌
- SQLite数据库基本操作
- mysql 乱码
- DNS“递归与缓存分离”架构评测
- sakai安装步骤
- 超级程序员神话
- 泛型
- 易语言获取外网ip源码
- 酒弄人生
- 请大家看看这个随机发牌的小程序,希望给出点建议或者挑出点瑕疵
- dns 性能测试 dnsperf