linux查看mysql数据库的编码集,查看和修改MySql6.0数据库编码(Linux版本)

首先查看安装好的mysql编码，Mysql提供命令查看环境参数的工具。

[root@localhost ~]# /usr/local/bin/mysqladmin variables

这样就列出了很多参数，不过我们只找和字符编码有关的参数说明

| 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/share/mysql/charsets/         |

| collation_connection            | latin1_swedish_ci                        |

| collation_database              | latin1_swedish_ci                        |

| collation_server                | latin1_swedish_ci                        |

上面这些才是和mysql字符编码有关的。

可以看到默认mysql编码是latin1，那么我们下面就对它修改成我们想要的。

==========================================

下面是修改成utf8编码过程(如果要修改gbk，把utf8换成gbk就可以)

在/etc目录下的my.cnf文件(此文件相当于windows中的.ini文件)

使用 vi 进去修改  vi /etc/my.cnf

找到在[mysqld]这一行下面，加入一句default-character-set=utf8即可！

保存退出 然后 重启 mysql 就可以了。很简单吧 呵呵

一般，如果你是编译安装mysql ，建议你像我下面的做法

cp /usr/local/share/mysql/mysql.server /etc/init.d/mysqld

mysql 关闭的命令为：/etc/init.d/mysqld stop

mysql 启动的命令为：/etc/init.d/mysqld start

我们再查看修改后的字符参数

#/usr/local/bin/mysqladmin variables

可以该命令列出的参数中参数如

| 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/share/mysql/charsets/         |

| collation_connection            | utf8_general_ci                          |

| collation_database              | utf8_general_ci                          |

| collation_server                | utf8_general_ci                          |

全部已经改成uft8，则配置编码方式为utf8成功！

好了，查看和修改 mysql 数据库编码就演示到这里