mac 下修改mysql数据库的编码格式

首先,你可以现进入mysql ,然后输入如下命令 show variables like 'character_set_%';查看编码已经装的电脑的编码方式,

如下为我的电脑上的:

mysql> show variables like 'character_set_%';
+--------------------------+-----------------------------------------------------+
| Variable_name            | Value                                               |
+--------------------------+-----------------------------------------------------+
| character_set_client     | utf8                                                |
| character_set_connection | latin1                                              |
| character_set_database   | latin1                                              |
| character_set_filesystem | binary                                              |
| character_set_results    | utf8                                                |
| character_set_server     | latin1                                              |
| character_set_system     | utf8                                                |
| character_sets_dir       | /usr/local/mysql-5.1.45-osx10.6-x86/share/charsets/ |
+--------------------------+-----------------------------------------------------+
8 rows in set (0.00 sec)

 

(默认安装的mysql是这样的)/usr/local/mysql/support-files下将my-small.cnf 拷贝到某个地方(比如根目录下),然后修改这个文件,

在[client]下添加 default-character-set=utf8   ,然后在[mysqld]下添加：character-set-server = utf8

然后将这个文件mv到/etc/my.cnf

<!--?xml version="1.0" encoding="UTF-8" standalone="no"?-->

(这样便实现了了移动和重命名).重启mysql即可(重启命令: sudo /Library/StartupItems/MySQL/MySQL start ).

 

启动mysql

sudo /Library/StartupItems/MySQLCOM/MySQLCOM start

停止mysql

sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop

 

注意: 有时候重启好像启动不了,这时候重新启动一下mac,就ok了.(2011.5.21)

 

完了可再次用命令来查看mysql的编码方式:

mysql> show variables like 'character_set_%';
+--------------------------+-----------------------------------------------------+
| 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.1.45-osx10.6-x86/share/charsets/ |
+--------------------------+-----------------------------------------------------+
8 rows in set (0.00 sec)

ok了.

 

 

补充,在ubuntu下面,遇到此问题.解决办法一样,只是在/etc/mysql/下已经有了一个叫my.cnf的文件,我们直接在里面添加上面两天set信息即可.