mysql5.6 mac修改编码设置_mac系统mysql5.6.17修改字符集

在mysql官网上下载最新的mysql for MacOS 5.6.17(dmg版本)安装过程中没有发现让选择字符集的位置,安装成功以后

mysql> show variables like '%char%';

+--------------------------+--------------------------------------------------------+

| Variable_name            | Value                                                  |

+--------------------------+--------------------------------------------------------+

| character_set_client     | utf8                                                   |

| character_set_connection | utf8                                                   |

| 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.5.23-osx10.6-x86_64/share/charsets/ |

+--------------------------+--------------------------------------------------------+

发现character_set_database和character_set_server依然是latin1的字符集

在网上搜索方法,都说

sudo cp /usr/local/mysql/support-files/my-medium.cnf /etc/my.cnf

经测试发现/usr/local/mysql/support-files下没有my-medium.cnf

所以需要自己在/etc下创建一个my.cnf

在创建的my.cnf中添加

[client]

default-character-set=utf8

[mysqld]

character-set-server=utf8

保存发现mysql启动不了了

后来经过查找在my.cnf中添加如下

[client]

default-character-set = utf8

[mysqld]

default-storage-engine = INNODB

character-set-server = utf8

collation-server = utf8_general_ci

保存后启动mysql,发现正常启动

mysql> show variables like '%char%';

+--------------------------+--------------------------------------------------------+

| 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.6.17-osx10.7-x86_64/share/charsets/ |

+--------------------------+--------------------------------------------------------+

8 rows in set (0.00 sec)

字符集已修改完毕

在网上搜索都没有很明确的答案,记录一下,欢迎MacOS大手拍砖,鄙人MacOS小白,第一次玩MacOS mysql

分享到：

2014-05-28 09:20

浏览 914

分类:互联网

评论