<span class="line"><span class="keyword">cd /usr/local/mysql/support-<span class="keyword">files<br /><span class="line">sudo <span class="keyword">cp my.<span class="keyword">cnf /etc/my.<span class="keyword">cnf<br /></span></span></span></span></span></span></span>
查看文件的读写权限，如果为644（rw- r– r–）则改为(664) (rw- rw- r–)
如果改为(666)(rw- rw- rw-)则修改以后配置文件不会生效
<span class="line">1<br /></span> |
<span class="line">sudo <span class="keyword">chmod <span class="number">664 /etc/<span class="keyword">my.cnf<br /></span></span></span></span> |
- my.cnf设置如下：
<span class="line">1<br /><span class="line">2<br /><span class="line">3<br /><span class="line">4<br /><span class="line">5<br /><span class="line">6<br /><span class="line">7<br /><span class="line">8<br /></span></span></span></span></span></span></span></span>
<span class="line">[client]<br /><span class="line">default-character-<span class="operator"><span class="keyword">set=utf8<br /><span class="line">[mysqld]<br /><span class="line"><span class="keyword">collation-<span class="keyword">server = utf8_unicode_ci<br /><span class="line">init-<span class="keyword">connect=<span class="string">‘SET NAMES utf8‘<br /><span class="line"><span class="built_in">character-<span class="keyword">set-<span class="keyword">server = utf8<br /><span class="line">[mysql]<br /><span class="line"><span class="keyword">default-<span class="built_in">character-<span class="keyword">set=utf8<br /></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span>
查看设置是否成功
在命令行输入mysql，如果提示没有命令的话，在bash或者zsh的文件里修改，我用的是zsh，设置~/.zshrc,
<span class="line">1<br /><span class="line">2<br /></span></span> |
<span class="line"><span class="built_in">export MYSQL=<span class="string">"/usr/local/mysql/bin/"<br /><span class="line"><span class="built_in">export PATH=<span class="string">"/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin:<span class="variable">$MYSQL"<br /></span></span></span></span></span></span></span> |
在命令行输入mysql,进入mysql命令行后，输入status;或者show variables like ‘%char%‘;
<span class="line">1<br /><span class="line">2<br /><span class="line">3<br /><span class="line">4<br /><span class="line">5<br /><span class="line">6<br /><span class="line">7<br /><span class="line">8<br /></span></span></span></span></span></span></span></span> |
<span class="line">|<span class="string"> character_set_client |<span class="string"> utf8 |<br /><span class="line">|<span class="string"> character_set_connection |<span class="string"> utf8 |<br /><span class="line">|<span class="string"> character_set_database |<span class="string"> utf8 |<br /><span class="line">|<span class="string"> character_set_filesystem |<span class="string"> binary |<br /><span class="line">|<span class="string"> character_set_results |<span class="string"> utf8 |<br /><span class="line">|<span class="string"> character_set_server |<span class="string"> utf8 |<br /><span class="line">|<span class="string"> character_set_system |<span class="string"> utf8 |<br /><span class="line">|<span class="string"> character_sets_dir |<span class="string"> /usr/local/mysql-5.6.30-osx10.11-x86_64/share/charsets/<br /></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span> |
如果文章对你有帮助,请去我的博客留个言吧! 我的博客
mac下mysql5.6字符集设置
标签：
本文系统来源：http://www.cnblogs.com/zengkefu/p/5634748.html
【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！