{"id":1241,"date":"2016-09-19T02:55:16","date_gmt":"2016-09-18T18:55:16","guid":{"rendered":"http:\/\/cn.hostease.com\/xueyuan\/?p=1241"},"modified":"2016-09-19T02:55:16","modified_gmt":"2016-09-18T18:55:16","slug":"centos7%e4%b8%8bmysql5-6%e4%bf%ae%e6%94%b9%e9%bb%98%e8%ae%a4%e7%bc%96%e7%a0%81","status":"publish","type":"post","link":"https:\/\/cn.hostease.com\/xueyuan\/jishu\/shujuku\/centos7%e4%b8%8bmysql5-6%e4%bf%ae%e6%94%b9%e9%bb%98%e8%ae%a4%e7%bc%96%e7%a0%81\/","title":{"rendered":"CentOS7\u4e0bMySQL5.6\u4fee\u6539\u9ed8\u8ba4\u7f16\u7801"},"content":{"rendered":"<h3 id=\"\u89e3\u51b3\u529e\u6cd5\">\u89e3\u51b3\u529e\u6cd5\uff1a<\/h3>\n<blockquote><p>CentOS7\u4e0b\u4fee\u6539MySQL\u6570\u636e\u5e93\u5b57\u7b26\u7f16\u7801\u4e3aUTF-8\uff0cUTF-8\u5305\u542b\u5168\u4e16\u754c\u6240\u6709\u56fd\u5bb6\u9700\u8981\u7528\u5230\u7684\u5b57\u7b26\uff0c\u662f\u56fd\u9645\u7f16\u7801\u3002<\/p><\/blockquote>\n<h3 id=\"\u5177\u4f53\u64cd\u4f5c\">\u5177\u4f53\u64cd\u4f5c\uff1a<\/h3>\n<h4 id=\"\u8fdb\u5165mysql\u63a7\u5236\u53f0\">1\u3001\u8fdb\u5165MySQL\u63a7\u5236\u53f0<\/h4>\n<pre><code class=\"hljs nginx\"><span class=\"hljs-attribute\">mysql<\/span>  -u root -p<\/code><\/pre>\n<p>\u8f93\u5165\u5bc6\u7801<\/p>\n<p>\u67e5\u770b\u5f53\u524dmysql\u8fd0\u884c\u72b6\u6001<\/p>\n<pre><code class=\"hljs fortran\">mysql&gt;<span class=\"hljs-keyword\">status<\/span><\/code><\/pre>\n<p><a href=\"https:\/\/cn.hostease.com\/xueyuan\/wp-content\/uploads\/2016\/09\/mysql.jpg\" rel=\"attachment wp-att-1242\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1242\" src=\"https:\/\/cn.hostease.com\/xueyuan\/wp-content\/uploads\/2016\/09\/mysql-300x135.jpg\" alt=\"mysql\" width=\"300\" height=\"135\" srcset=\"https:\/\/cn.hostease.com\/xueyuan\/wp-content\/uploads\/2016\/09\/mysql-300x135.jpg 300w, https:\/\/cn.hostease.com\/xueyuan\/wp-content\/uploads\/2016\/09\/mysql-768x345.jpg 768w, https:\/\/cn.hostease.com\/xueyuan\/wp-content\/uploads\/2016\/09\/mysql.jpg 842w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>\u5176\u4e2d<code>server<\/code>\u548c<code>db<\/code>\u539f\u4e0d\u662f<code>utf-8<\/code>\uff1b\u9ed8\u8ba4\u7f16\u7801\u662f<code>latin1<\/code>\u3002<\/p>\n<h4 id=\"\u4fee\u6539mysql\u914d\u7f6e\u6587\u4ef6\">2.\u4fee\u6539mysql\u914d\u7f6e\u6587\u4ef6<\/h4>\n<p>\u9ed8\u8ba4\u4f4d\u7f6e\uff1a<code>\/etc\/my.cnf<\/code><br \/>\n`<code>ssh vim \/etc\/my.cnf<\/code><\/p>\n<p>\u56fe\u7247\u662f\u6211\u6dfb\u52a0\u8bbe\u7f6e\u540e\u7684\u3002<\/p>\n<ul>\n<li>\u6211\u7684mysql\u6ca1\u6709[client]\u8fd9\u4e2a\u5b57\u6bb5\uff0c\u9996\u5148\u6dfb\u52a0\u4e0a\uff0c\u5728[client]\u6bb5\u589e\u52a0\u4e0b\u9762\u4ee3\u7801default-character-set=utf8(\u7f51\u4e0a\u8fd8\u6709\u63d0\u5230\u5176\u4ed6\u7684\u8bbe\u7f6e\u8bed\u53e5\uff0c\u662f\u4ee5\u524d\u7684\u7248\u672c\uff0c\u73b0\u5728\u4e0d\u7528\u4e86)<\/li>\n<li>\u5728[mysqld]\u6bb5\u589e\u52a0\u4e0b\u9762\u7684\u4ee3\u7801<\/li>\n<li><a href=\"https:\/\/cn.hostease.com\/xueyuan\/wp-content\/uploads\/2016\/09\/mysql.jpeg\" rel=\"attachment wp-att-1243\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1243\" src=\"https:\/\/cn.hostease.com\/xueyuan\/wp-content\/uploads\/2016\/09\/mysql-300x96.jpeg\" alt=\"mysql\" width=\"300\" height=\"96\" srcset=\"https:\/\/cn.hostease.com\/xueyuan\/wp-content\/uploads\/2016\/09\/mysql-300x96.jpeg 300w, https:\/\/cn.hostease.com\/xueyuan\/wp-content\/uploads\/2016\/09\/mysql.jpeg 578w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/li>\n<\/ul>\n<p>character-set-server=utf8<\/p>\n<p>collation-server=utf8_general_ci<\/p>\n<p>:wq! #\u4fdd\u5b58\u9000\u51fa<\/p>\n<pre class=\"ssh\"><code class=\"hljs nginx\"><span class=\"hljs-attribute\">systemctl<\/span> restart mysql.service <span class=\"hljs-comment\">#\u91cd\u542fMySQL<\/span><\/code><\/pre>\n<ul>\n<li>\u67e5\u770b\u5f53\u524dmysql\u8fd0\u884c\u72b6\u6001<\/li>\n<\/ul>\n<p>mysql&gt;status<\/p>\n<p>\u6b64\u65f6\u6240\u6709\u7f16\u7801\u5e94\u8be5\u90fd\u662fUTF-8<\/p>\n<h4 id=\"\u53c2\u6570\u8bf4\u660e\">\u53c2\u6570\u8bf4\u660e\uff1a<\/h4>\n<p>haracter_set_client\uff1a\u5ba2\u6237\u7aef\u8bf7\u6c42\u6570\u636e\u7684\u5b57\u7b26\u96c6\u3002<\/p>\n<p>character_set_connection\uff1a\u4ece\u5ba2\u6237\u7aef\u63a5\u6536\u5230\u6570\u636e\uff0c\u7136\u540e\u4f20\u8f93\u7684\u5b57\u7b26\u96c6\u3002<\/p>\n<p>character_set_database\uff1a\u9ed8\u8ba4\u6570\u636e\u5e93\u7684\u5b57\u7b26\u96c6\uff0c\u65e0\u8bba\u9ed8\u8ba4\u6570\u636e\u5e93\u5982\u4f55\u6539\u53d8\uff0c\u90fd\u662f\u8fd9\u4e2a\u5b57\u7b26\u96c6\uff1b\u5982\u679c\u6ca1\u6709\u9ed8\u8ba4\u6570\u636e\u5e93\uff0c\u4f7fcharacter_set_server\u6307\u5b9a\u7684\u5b57\u7b26\u96c6\uff0c\u6b64\u53c2\u6570\u65e0\u9700\u8bbe\u7f6e\u3002<\/p>\n<p>character_set_filesystem\uff1a\u628a\u64cd\u4f5c\u7cfb\u7edf\u4e0a\u6587\u4ef6\u540d\u8f6c\u5316\u6210\u6b64\u5b57\u7b26\u96c6\uff0c\u5373\u628acharacter_set_client\u8f6c\u6362character_set_filesystem\uff0c\u9ed8\u8ba4binary\u5373\u53ef\u3002<\/p>\n<p>character_set_results\uff1a\u7ed3\u679c\u96c6\u7684\u5b57\u7b26\u96c6\u3002<\/p>\n<p>character_set_server\uff1a\u6570\u636e\u5e93\u670d\u52a1\u5668\u7684\u9ed8\u8ba4\u5b57\u7b26\u96c6\u3002<\/p>\n<p>character_set_system\uff1a\u8fd9\u4e2a\u503c\u603b\u662futf8\uff0c\u4e0d\u9700\u8981\u8bbe\u7f6e\uff0c\u5b58\u50a8\u7cfb\u7edf\u5143\u6570\u636e\u7684\u5b57\u7b26\u96c6\u3002<\/p>\n<div id=\"MySignature\">So do it,and change it,no regret!<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u89e3\u51b3\u529e\u6cd5\uff1a CentOS7\u4e0b\u4fee\u6539MySQL\u6570\u636e\u5e93\u5b57\u7b26\u7f16\u7801\u4e3aUTF-8\uff0cUTF-8\u5305\u542b\u5168\u4e16\u754c\u6240\u6709\u56fd\u5bb6\u9700\u8981\u7528\u5230\u7684\u5b57 &#8230; <a title=\"CentOS7\u4e0bMySQL5.6\u4fee\u6539\u9ed8\u8ba4\u7f16\u7801\" class=\"read-more\" href=\"https:\/\/cn.hostease.com\/xueyuan\/jishu\/shujuku\/centos7%e4%b8%8bmysql5-6%e4%bf%ae%e6%94%b9%e9%bb%98%e8%ae%a4%e7%bc%96%e7%a0%81\/\" aria-label=\"\u9605\u8bfb CentOS7\u4e0bMySQL5.6\u4fee\u6539\u9ed8\u8ba4\u7f16\u7801\">\u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":1,"featured_media":1242,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[10],"tags":[38,45],"class_list":["post-1241","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-shujuku","tag-linux","tag-mysql"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/cn.hostease.com\/xueyuan\/wp-content\/uploads\/2016\/09\/mysql.jpg","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/1241","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/comments?post=1241"}],"version-history":[{"count":1,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/1241\/revisions"}],"predecessor-version":[{"id":1244,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/1241\/revisions\/1244"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/media\/1242"}],"wp:attachment":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/media?parent=1241"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/categories?post=1241"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/tags?post=1241"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}