首先,你可以现进入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
(这样便实现了了移动和重命名).重启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信息即可.
分享到:
2010-04-17 14:37
浏览 2937
分类:数据库
评论