{"id":3863,"date":"2019-08-30T16:54:23","date_gmt":"2019-08-30T08:54:23","guid":{"rendered":"https:\/\/www.choubb.com\/?p=3863"},"modified":"2020-11-20T12:13:05","modified_gmt":"2020-11-20T04:13:05","slug":"%e5%8d%9a%e5%ae%a2%e5%9b%9e%e6%9d%a5%e4%ba%86","status":"publish","type":"post","link":"https:\/\/www.choubb.com\/?p=3863","title":{"rendered":"\u535a\u5ba2\u56de\u6765\u4e86"},"content":{"rendered":"\n<p class=\"has-vivid-red-color has-text-color\"><strong>\u5341\u5e74<\/strong>,\u8be5\u6362\u4e86.<\/p>\n\n\n\n<p>\u5171\u4eab\u4e3b\u673a\u762b\u75ea\u4e86\u4e24\u5929,\u4e00\u60ca\u4e4b\u4e0b,\u5f00\u59cb\u642c\u5bb6. \u5148\u5b66docker compose, \u518d\u594b\u6218lemp\u5206\u522b\u5b89\u88c5.\u65e0\u8bbadocker\u8fd8\u662flemp\u5355\u88c5,\u90fd\u4e0d\u590d\u6742,\u5b66\u4e60\u4e00\u4e9blinux,docker,vim\/nano\u548cnginx\/mysql\/wordpress\u7684\u77e5\u8bc6\u540e, \u57fa\u672c\u4e00\u8e74\u800c\u6210.\u56f0\u96be\u7684\u662f\u5b57\u7b26\u4e32&#8230;<\/p>\n\n\n\n<p>\u7ecf\u8fc720\u5929\u65f6\u65ad\u65f6\u7eed\u7684\u94bb\u7814, \u7ec8\u4e8e\u6210\u529f,\u6478\u51fa\u4e00\u6761\u81ea\u5df1\u7684\u8def: \u5b57\u7b26\u4e32\u548c\u5b57\u7b26\u5e8f\u6709\u591a\u4e2a\u5c42\u9762, \u8fd9\u4e9b\u90fd\u4e0d\u91cd\u8981,\u91cd\u8981\u7684\u662f\u539fdb\u548cserver\u662f\u4ec0\u4e48\u6837, \u65b0\u7684\u670d\u52a1\u5668\u548c\u8bbe\u7f6e\u7167\u65e7\u5373\u53ef.\u8bf4\u8d77\u6765\u7b80\u5355, \u8d70\u8fc7\u6765\u5168\u662f\u5751\u554a.<\/p>\n\n\n\n<p>\u7b80\u8ff0\u7ed3\u679c:<\/p>\n\n\n\n<p>\u539fDB\u5728\u5171\u4eab\u4e3b\u673a, \u53ea\u80fdphpmysql\u7b80\u5355\u7684\u64cd\u4f5c, \u6700\u7ec8\u63a2\u660e\u670d\u52a1\u5668\u662futf8mb4\u7684\u8bbe\u7f6e,\u4e5f\u662fdefualt\u7684\u8bbe\u7f6e,\u4ffa\u90a3\u4e2a\u53e4\u8001\u7684mysql5.6( \u5386\u7ecfhost provider\u5347\u7ea7), \u670d\u52a1\u5668\u4e5f\u662futf8mb4\u7684\u8bbe\u7f6e,  \u6570\u636e\u5e93\u5374\u662f\u4e2a\u6050\u9f99\u82aflatin1, \u6570\u636e\u8868\u56e0\u6b64\u6709\u4e24\u79cd, \u57fa\u672c\u4e0a\u5173\u952e\u7684\u8868\u90fd\u662flatin1, \u4e00\u4e9b\u540e\u6765\u7684plugin\u7684\u8868\u662futf8.\u5982\u56fe:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.choubb.com\/ftp:\/\/ftp.choubb.com\/pic\/2019\/08\/\u5c4f\u5e55\u5feb\u7167-2019-08-30-16.39.05.png\" alt=\"\" class=\"wp-image-3864\" width=\"504\" height=\"339\"\/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.choubb.com\/ftp:\/\/ftp.choubb.com\/pic\/2019\/08\/\u5c4f\u5e55\u5feb\u7167-2019-08-30-16.39.55-1024x379.png\" alt=\"\" class=\"wp-image-3865\" width=\"508\" height=\"187\" srcset=\"https:\/\/www.choubb.com\/ftp:\/\/ftp.choubb.com\/pic\/2019\/08\/\u5c4f\u5e55\u5feb\u7167-2019-08-30-16.39.55-1024x379.png 1024w, https:\/\/www.choubb.com\/ftp:\/\/ftp.choubb.com\/pic\/2019\/08\/\u5c4f\u5e55\u5feb\u7167-2019-08-30-16.39.55-600x222.png 600w, https:\/\/www.choubb.com\/ftp:\/\/ftp.choubb.com\/pic\/2019\/08\/\u5c4f\u5e55\u5feb\u7167-2019-08-30-16.39.55-768x284.png 768w\" sizes=\"auto, (max-width: 508px) 100vw, 508px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.choubb.com\/ftp:\/\/ftp.choubb.com\/pic\/2019\/08\/\u5c4f\u5e55\u5feb\u7167-2019-08-30-16.40.31-1024x525.png\" alt=\"\" class=\"wp-image-3866\" width=\"510\" height=\"261\" srcset=\"https:\/\/www.choubb.com\/ftp:\/\/ftp.choubb.com\/pic\/2019\/08\/\u5c4f\u5e55\u5feb\u7167-2019-08-30-16.40.31-1024x525.png 1024w, https:\/\/www.choubb.com\/ftp:\/\/ftp.choubb.com\/pic\/2019\/08\/\u5c4f\u5e55\u5feb\u7167-2019-08-30-16.40.31-600x308.png 600w, https:\/\/www.choubb.com\/ftp:\/\/ftp.choubb.com\/pic\/2019\/08\/\u5c4f\u5e55\u5feb\u7167-2019-08-30-16.40.31-768x394.png 768w\" sizes=\"auto, (max-width: 510px) 100vw, 510px\" \/><\/figure><\/div>\n\n\n\n<p>\u6210\u529f\u5927\u6cd5:<\/p>\n\n\n\n<p>MySQL\u670d\u52a1\u5668cnf\u4e0d\u505a\u4ec0\u4e48\u5b57\u7b26\u7ec4\u548c\u5b57\u7b26\u5e8f\u7684\u5b9a\u4e49, default\u8d77\u670d\u52a1\u5668. create Database\u65f6\u52a0\u5165\u5b57\u7b26\u7ec4\u548c\u5b57\u7b26\u5e8f\u7684latin1 \u7684\u8bbe\u5b9a.<\/p>\n\n\n\n<p>\u8001\u670d\u52a1\u5668\u7528phpmyadmin\u5bfc\u51fa,\u5bfc\u51fa\u9875\u9762\u4fdd\u7559utf8\u7684\u8bbe\u5b9a.\u65b0\u6570\u636e\u5e93\u5bfc\u5165, \u540c\u6837\u4fdd\u6301utf8\u7684\u8bbe\u7f6e,\u5bfc\u51fa\u5bfc\u5165\u9875\u9762\u6240\u6709\u8bbe\u7f6e\u90fd\u4e0d\u53d8\u52a8.<\/p>\n\n\n\n<p>\u6309\u7167\u8001\u670d\u52a1\u5668\u7684wp-config.php\u7684\u8bbe\u5b9a, \u5b57\u7b26\u7ec4\u548c\u5b57\u7b26\u5e8f\u90fd\u662f\u7a7a\u7684,\u4e0d\u8bbe\u5b9a\u503c.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.choubb.com\/ftp:\/\/ftp.choubb.com\/pic\/2019\/08\/\u5c4f\u5e55\u5feb\u7167-2019-08-30-16.49.16-1024x341.png\" alt=\"\" class=\"wp-image-3867\" width=\"511\" height=\"170\" srcset=\"https:\/\/www.choubb.com\/ftp:\/\/ftp.choubb.com\/pic\/2019\/08\/\u5c4f\u5e55\u5feb\u7167-2019-08-30-16.49.16-1024x341.png 1024w, https:\/\/www.choubb.com\/ftp:\/\/ftp.choubb.com\/pic\/2019\/08\/\u5c4f\u5e55\u5feb\u7167-2019-08-30-16.49.16-600x200.png 600w, https:\/\/www.choubb.com\/ftp:\/\/ftp.choubb.com\/pic\/2019\/08\/\u5c4f\u5e55\u5feb\u7167-2019-08-30-16.49.16-768x256.png 768w, https:\/\/www.choubb.com\/ftp:\/\/ftp.choubb.com\/pic\/2019\/08\/\u5c4f\u5e55\u5feb\u7167-2019-08-30-16.49.16.png 1140w\" sizes=\"auto, (max-width: 511px) 100vw, 511px\" \/><\/figure><\/div>\n\n\n\n<p>\u4ece\u53e4\u8001\u5171\u4eab\u4e3b\u673a\u8fc1\u79fbmysql\/wordpress\u7684\u4e2d\u6587\u4e71\u7801\u95ee\u9898\u5c31\u6b64\u89e3\u51b3.ya!<\/p>\n\n\n\n<p>\u4e00\u5929\u540e\u53c8\u8bb0: \u642d\u5efalemp\u73af\u5883\u65f6\u51e0\u4e4e\u9009\u62e9\u4e86lnmp\u4e00\u952e\u5b89\u88c5\u5305, \u505a\u4e86\u4e9b\u57fa\u7840\u8c03\u67e5\u540e,\u770b\u52305,6\u5e74\u524d\u7684\u535a\u5ba2\u8ba8\u8bba\u4e86\u5176\u5b89\u5168\u95ee\u9898, \u9042\u5f03\u4e4b. \u867d\u655d\u5e1a,\u4e43\u81ea\u73cd\u4e5f.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5341\u5e74,\u8be5\u6362\u4e86. \u5171\u4eab\u4e3b\u673a\u762b\u75ea\u4e86\u4e24\u5929,\u4e00\u60ca\u4e4b\u4e0b,\u5f00\u59cb\u642c\u5bb6. \u5148\u5b66docker compose, \u518d\u594b\u6218lemp\u5206\u522b\u5b89\u88c5.\u65e0\u8bbadocker\u8fd8\u662flemp\u5355\u88c5,\u90fd\u4e0d\u590d\u6742,\u5b66\u4e60\u4e00\u4e9blinux,docker,vim\/nano\u548cnginx\/mysql\/wordpress\u7684\u77e5\u8bc6\u540e, \u57fa\u672c\u4e00\u8e74\u800c\u6210.\u56f0\u96be\u7684\u662f\u5b57\u7b26\u4e32&#8230; \u7ecf\u8fc720\u5929\u65f6\u65ad\u65f6\u7eed\u7684\u94bb\u7814, \u7ec8\u4e8e\u6210\u529f,\u6478\u51fa\u4e00\u6761\u81ea\u5df1\u7684\u8def: \u5b57\u7b26\u4e32\u548c\u5b57\u7b26\u5e8f\u6709\u591a\u4e2a\u5c42\u9762, \u8fd9\u4e9b\u90fd\u4e0d\u91cd\u8981,\u91cd\u8981\u7684\u662f\u539fdb\u548cserver\u662f\u4ec0\u4e48\u6837, \u65b0\u7684\u670d\u52a1\u5668\u548c\u8bbe\u7f6e\u7167\u65e7\u5373\u53ef.\u8bf4\u8d77\u6765\u7b80\u5355, \u8d70\u8fc7\u6765\u5168\u662f\u5751\u554a. \u7b80\u8ff0\u7ed3\u679c: \u539fDB\u5728\u5171\u4eab\u4e3b\u673a, \u53ea\u80fdphpmysql\u7b80\u5355\u7684\u64cd\u4f5c, \u6700\u7ec8\u63a2\u660e\u670d\u52a1\u5668\u662futf8mb4\u7684\u8bbe\u7f6e,\u4e5f\u662fdefualt\u7684\u8bbe\u7f6e,\u4ffa\u90a3\u4e2a\u53e4\u8001\u7684mysql5.6( \u5386\u7ecfhost provider\u5347\u7ea7), \u670d\u52a1\u5668\u4e5f\u662futf8mb4\u7684\u8bbe\u7f6e, \u6570\u636e\u5e93\u5374\u662f\u4e2a\u6050\u9f99\u82aflatin1, \u6570\u636e\u8868\u56e0\u6b64\u6709\u4e24\u79cd, \u57fa\u672c\u4e0a\u5173\u952e\u7684\u8868\u90fd\u662flatin1, \u4e00\u4e9b\u540e\u6765\u7684plugin\u7684\u8868\u662futf8.\u5982\u56fe: \u6210\u529f\u5927\u6cd5: MySQL\u670d\u52a1\u5668cnf\u4e0d\u505a\u4ec0\u4e48\u5b57\u7b26\u7ec4\u548c\u5b57\u7b26\u5e8f\u7684\u5b9a\u4e49, default\u8d77\u670d\u52a1\u5668. create Database\u65f6\u52a0\u5165\u5b57\u7b26\u7ec4\u548c\u5b57\u7b26\u5e8f\u7684latin1 \u7684\u8bbe\u5b9a. \u8001\u670d\u52a1\u5668\u7528phpmyadmin\u5bfc\u51fa,\u5bfc\u51fa\u9875\u9762\u4fdd\u7559utf8\u7684\u8bbe\u5b9a.\u65b0\u6570\u636e\u5e93\u5bfc\u5165, \u540c\u6837\u4fdd\u6301utf8\u7684\u8bbe\u7f6e,\u5bfc\u51fa\u5bfc\u5165\u9875\u9762\u6240\u6709\u8bbe\u7f6e\u90fd\u4e0d\u53d8\u52a8. \u6309\u7167\u8001\u670d\u52a1\u5668\u7684wp-config.php\u7684\u8bbe\u5b9a,<a class=\"moretag\" href=\"https:\/\/www.choubb.com\/?p=3863\">Read More&#8230;<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[201,15],"tags":[72,70,1692,1693,71,69,1685,66,157,3351],"class_list":["post-3863","post","type-post","status-publish","format-standard","hentry","category-201","category-15","tag-collation","tag-latin1","tag-lemp","tag-lnmp","tag-mysql","tag-utf8","tag-vps","tag-wordpress","tag-157","tag-3351"],"_links":{"self":[{"href":"https:\/\/www.choubb.com\/index.php?rest_route=\/wp\/v2\/posts\/3863","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.choubb.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.choubb.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.choubb.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.choubb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3863"}],"version-history":[{"count":4,"href":"https:\/\/www.choubb.com\/index.php?rest_route=\/wp\/v2\/posts\/3863\/revisions"}],"predecessor-version":[{"id":6225,"href":"https:\/\/www.choubb.com\/index.php?rest_route=\/wp\/v2\/posts\/3863\/revisions\/6225"}],"wp:attachment":[{"href":"https:\/\/www.choubb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3863"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.choubb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3863"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.choubb.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3863"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}