{"id":19087,"date":"2015-12-10T06:38:44","date_gmt":"2015-12-09T22:38:44","guid":{"rendered":"https:\/\/2blog.ilc.edu.tw\/25793\/2015\/12\/10\/%e4%bf%ae%e6%ad%a3-mysql-server-%e5%95%9f%e5%8b%95%e5%be%8c%e5%9c%a8-log-%e4%b8%ad%e9%a1%af%e7%a4%ba%e7%9a%84%e8%ad%a6%e5%91%8a%e8%a8%8a%e6%81%af\/"},"modified":"2015-12-10T06:38:44","modified_gmt":"2015-12-09T22:38:44","slug":"%e4%bf%ae%e6%ad%a3-mysql-server-%e5%95%9f%e5%8b%95%e5%be%8c%e5%9c%a8-log-%e4%b8%ad%e9%a1%af%e7%a4%ba%e7%9a%84%e8%ad%a6%e5%91%8a%e8%a8%8a%e6%81%af","status":"publish","type":"post","link":"https:\/\/2blog.ilc.edu.tw\/25793\/2015\/12\/10\/%e4%bf%ae%e6%ad%a3-mysql-server-%e5%95%9f%e5%8b%95%e5%be%8c%e5%9c%a8-log-%e4%b8%ad%e9%a1%af%e7%a4%ba%e7%9a%84%e8%ad%a6%e5%91%8a%e8%a8%8a%e6%81%af\/","title":{"rendered":"\u4fee\u6b63 MySQL Server \u555f\u52d5\u5f8c\u5728 log \u4e2d\u986f\u793a\u7684\u8b66\u544a\u8a0a\u606f"},"content":{"rendered":"<p>\u5728 MySQL Server \u555f\u52d5\u5f8c\u7684 <span style=\"color: #0000ff;\">\/var\/log\/mysqld.log<\/span> \u4e2d\u767c\u73fe\u6709\u4e0b\u5217\u7684\u8b66\u544a\u8a0a\u606f<br \/><span style=\"color: #0000ff;\">151202\u00a0 4:23:49 [Warning] &#8216;&#8211;default-character-set&#8217; is deprecated and will be removed in a future release. Please use &#8216;&#8211;character-set-server&#8217; instead.<\/span><br \/><span style=\"color: #0000ff;\">151202\u00a0 4:23:49 [Warning] &#8216;&#8211;default-collation&#8217; is deprecated and will be removed in a future release. Please use &#8216;&#8211;collation-server&#8217; instead.<\/span><\/p>\n<p>\u89e3\u6c7a\u65b9\u5f0f\uff1a[@more@]\u4fee\u6539 <span style=\"color: #0000ff;\">\/etc\/my.cnf<\/span> \u8a2d\u5b9a\u6a94<br \/># <span style=\"color: #ff0000;\">vim \/etc\/my.cnf<\/span><br \/><span style=\"color: #ff0000;\">character-set-server=utf8<\/span><br \/><span style=\"color: #ff0000;\">collation-server=utf8_general_ci<\/span><br \/><span style=\"color: #ff0000;\">init-connect=&#8217;SET NAMES utf8&#8242;<\/span><br \/><span style=\"color: #0000ff;\"># default-character-set=utf8<\/span><br \/><span style=\"color: #0000ff;\"># default-collation=utf8_general_ci<\/span><\/p>\n<p>\u91cd\u65b0\u555f\u52d5 MySQL Server<br \/>#<span style=\"color: #ff0000;\"> \/etc\/init.d\/mysqld restart<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5728 MySQL Server \u555f\u52d5\u5f8c\u7684 \/var\/log\/mysqld.log \u4e2d\u767c\u73fe\u6709\u4e0b\u5217\u7684\u8b66\u544a\u8a0a\u606f1512 &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/2blog.ilc.edu.tw\/25793\/2015\/12\/10\/%e4%bf%ae%e6%ad%a3-mysql-server-%e5%95%9f%e5%8b%95%e5%be%8c%e5%9c%a8-log-%e4%b8%ad%e9%a1%af%e7%a4%ba%e7%9a%84%e8%ad%a6%e5%91%8a%e8%a8%8a%e6%81%af\/\" class=\"more-link\">\u95b1\u8b80\u5168\u6587<span class=\"screen-reader-text\">\u3008\u4fee\u6b63 MySQL Server \u555f\u52d5\u5f8c\u5728 log \u4e2d\u986f\u793a\u7684\u8b66\u544a\u8a0a\u606f\u3009<\/span><\/a><\/p>\n","protected":false},"author":55,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[117,116],"tags":[],"class_list":["post-19087","post","type-post","status-publish","format-standard","hentry","category-c-78462","category-c-78461"],"meta_key":{"_pingme":["1"],"_encloseme":["1"],"lt_post_id":["618204"]},"_links":{"self":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/19087"}],"collection":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/users\/55"}],"replies":[{"embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/comments?post=19087"}],"version-history":[{"count":0,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/posts\/19087\/revisions"}],"wp:attachment":[{"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/media?parent=19087"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/categories?post=19087"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/2blog.ilc.edu.tw\/25793\/wp-json\/wp\/v2\/tags?post=19087"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}