https://www.mywiki.cn/Hovercool/index.php?action=history&feed=atom&title=Ubuntu%E4%B8%8BMySQL%E7%9A%84%E9%85%8D%E7%BD%AE%EF%BC%8C%E4%BD%BF%E5%AE%8C%E7%BE%8E%E6%94%AF%E6%8C%81%E4%B8%AD%E6%96%87 2026-09-01T05:32:53Z 本wiki上该页面的版本历史 MediaWiki 1.45.1 https://www.mywiki.cn/Hovercool/index.php?title=Ubuntu%E4%B8%8BMySQL%E7%9A%84%E9%85%8D%E7%BD%AE%EF%BC%8C%E4%BD%BF%E5%AE%8C%E7%BE%8E%E6%94%AF%E6%8C%81%E4%B8%AD%E6%96%87&diff=777&oldid=prev 2015-05-06T08:08:23Z

<p></p> <p><b>新页面</b></p><div>安装完以后：<br /> <br /> $:mysql -u root -p<br /> <br /> 查看字符编码初始值：<br /> <br /> mysql&gt; show variables like &#039;char%&#039;;<br /> <br /> 此时应该是：<br /> <br /> +--------------------------+----------------------------+<br /> <br /> | Variable_name | Value |<br /> <br /> +--------------------------+----------------------------+<br /> <br /> | character_set_client | latin1 |<br /> <br /> | character_set_connection | latin1 |<br /> <br /> | character_set_database | latin1 |<br /> <br /> | character_set_filesystem | binary |<br /> <br /> | character_set_results | latin1 |<br /> <br /> | character_set_server | latin1 |<br /> <br /> | character_set_system | utf8 |<br /> <br /> | character_sets_dir | /usr/share/mysql/charsets/ |<br /> <br /> +--------------------------+----------------------------+<br /> <br /> 修改字符集，不然对UTF-8的支持会出问题（[http://jamwiki.org/wiki/en/%E4%B8%AD%E6%96%87 看这里]）：<br /> <br /> $:cd /etc/mysql/<br /> <br /> $:sudo gedit my.cnf<br /> <br /> 更改或加入：<br /> <br /> [mysqld]下<br /> <br /> default-character-set=utf8 <br /> <br /> *如果启动不了，提示“mysqld: unknown variable &#039;default-character-set=utf8&#039;”，则可换成：<br /> <br /> character_set_server=utf8<br /> <br /> [client]下<br /> <br /> default-character-set=utf8<br /> <br /> [server]下<br /> <br /> default-character-set=utf8，init_connect=&#039;SET NAMES utf8;&#039;<br /> <br /> 保存<br /> <br /> 重启SQL：<br /> <br /> $:sudo /etc/init.d/mysql restart<br /> <br /> 查看字符编码初始值：<br /> <br /> mysql&gt; show variables like &#039;char%&#039;;<br /> <br /> 结果应为：<br /> <br /> +--------------------------+----------------------------+<br /> <br /> | Variable_name | Value |<br /> <br /> +--------------------------+----------------------------+<br /> <br /> | character_set_client | utf8 |<br /> <br /> | character_set_connection | utf8 |<br /> <br /> | character_set_database | utf8 |<br /> <br /> | character_set_filesystem | binary |<br /> <br /> | character_set_results | utf8 |<br /> <br /> | character_set_server | utf8 |<br /> <br /> | character_set_system | utf8 |<br /> <br /> | character_sets_dir | /usr/share/mysql/charsets/ |<br /> <br /> +--------------------------+----------------------------+<br /> <br /> 最后，创建DB时最好指明字符属性<br /> <br /> $:create database database-name character set utf8</div>

Hovercool