{"id":649,"date":"2021-03-06T02:50:00","date_gmt":"2021-03-05T18:50:00","guid":{"rendered":"https:\/\/wp.winter-weng.cc\/work\/?p=649"},"modified":"2021-03-07T03:18:05","modified_gmt":"2021-03-06T19:18:05","slug":"%e4%b8%bb%e6%a9%9f%e7%92%b0%e5%a2%83%e6%9b%b4%e6%96%b0%e5%af%a6%e9%8c%84-5-wp-%e7%af%87","status":"publish","type":"post","link":"https:\/\/wp.winter-weng.cc\/work\/?p=649","title":{"rendered":"\u4e3b\u6a5f\u74b0\u5883\u66f4\u65b0\u5be6\u9304 (5) \u2013 WP \u7bc7"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_75 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"\u986f\u793a\/\u96b1\u85cf\u5167\u5bb9\u76ee\u9304\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/wp.winter-weng.cc\/work\/?p=649\/#1_mySQL_8_%E9%81%87%E5%88%B0%E5%AF%86%E7%A2%BC%E9%A9%97%E8%AD%89%E5%95%8F%E9%A1%8C\" >1. mySQL 8 \u9047\u5230\u5bc6\u78bc\u9a57\u8b49\u554f\u984c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/wp.winter-weng.cc\/work\/?p=649\/#2_%E4%B8%8A%E5%82%B3%E6%AA%94%E6%A1%88%E5%A4%A7%E5%B0%8F%E4%BB%A5%E5%8F%8A%E9%80%A3%E7%B7%9A%E6%99%82%E9%96%93%E9%99%90%E5%88%B6\" >2. \u4e0a\u50b3\u6a94\u6848\u5927\u5c0f\u4ee5\u53ca\u9023\u7dda\u6642\u9593\u9650\u5236<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/wp.winter-weng.cc\/work\/?p=649\/#3_%E5%95%9F%E7%94%A8%E5%A4%9A%E7%AB%99%E9%BB%9E\" >3. \u555f\u7528\u591a\u7ad9\u9ede<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/wp.winter-weng.cc\/work\/?p=649\/#4_%E5%B0%87%E8%B3%87%E6%BA%90%E7%A7%BB%E5%8B%95%E5%88%B0_S3\" >4. \u5c07\u8cc7\u6e90\u79fb\u52d5\u5230 S3<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/wp.winter-weng.cc\/work\/?p=649\/#5_%E4%BF%AE%E6%AD%A3%E8%B3%87%E6%96%99\" >5. \u4fee\u6b63\u8cc7\u6599<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/wp.winter-weng.cc\/work\/?p=649\/#%E5%8F%83%E8%80%83%E8%B3%87%E6%96%99%EF%BC%9A\" >\u53c3\u8003\u8cc7\u6599\uff1a<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/wp.winter-weng.cc\/work\/?p=649\/#%E4%B8%BB%E6%A9%9F%E7%92%B0%E5%A2%83%E6%9B%B4%E6%96%B0%E5%AF%A6%E9%8C%84%EF%BC%9A\" >\u4e3b\u6a5f\u74b0\u5883\u66f4\u65b0\u5be6\u9304\uff1a<\/a><\/li><\/ul><\/nav><\/div>\n\n<p>\u4e00\u958b\u59cb\u539f\u672c\u6253\u7b97\u4ee5 nginx + wp-fpm \u7684\u5f62\u5f0f\u5efa\u7acb\u8d77 wordpress\uff0c\u4f46\u7531\u65bc\u5c0d\u65bc nginx \u5404\u7a2e\u8a2d\u5b9a\u9084\u662f\u4e00\u77e5\u534a\u89e3\uff0c\u96d6\u7136\u53ef\u4ee5\u6210\u529f\u5efa\u7acb\u8d77\u4f86\uff0c\u4f46\u662f\u5f8c\u7e8c\u8981\u67b6\u8d77\u591a\u7ad9\u9ede\u4f7f\u7528\u7684\u6642\u5019\uff0c\u6703\u56e0\u70ba\u5c0e\u5411\u554f\u984c\u800c\u7121\u6cd5\u6b63\u78ba\u9032\u5165\u591a\u7ad9\u9ede\u7684\u7db2\u7ad9\u3002\u4e26\u4e14\u56e0\u70ba\u7d50\u69cb\u4e0a\u591a\u4e86\u4e00\u5c64 proxy \u8b93\u72c0\u6cc1\u8b8a\u5f97\u66f4\u8907\u96dc\uff0c\u7136\u5f8c\u6211\u5c31\u5931\u6557\u4e86 XD\u3002\u7d30\u7bc0\u5c31\u4e0d\u5beb\u592a\u591a\u4e86\uff0c\u514d\u5f97\u6709\u4eba\u641c\u5c0b\u5230\u76f8\u95dc\u8cc7\u8a0a\u537b\u5f97\u4e0d\u5230\u7b54\u6848\u3002<\/p>\n\n\n\n<p>wordpress \u883b\u5e38\u6703\u6709\u4e00\u4e9b\u8a2d\u5b9a\u554f\u984c\uff0c\u96d6\u7136\u4e5f\u7b97\u662f\u8001\u751f\u5e38\u8ac7\u4e86\uff0c\u4f46\u9084\u662f\u7559\u500b\u7d00\u9304\u4ee5\u4f9b\u4e4b\u5f8c\u53c3\u8003\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_mySQL_8_%E9%81%87%E5%88%B0%E5%AF%86%E7%A2%BC%E9%A9%97%E8%AD%89%E5%95%8F%E9%A1%8C\"><\/span>1. mySQL 8 \u9047\u5230\u5bc6\u78bc\u9a57\u8b49\u554f\u984c<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u9032\u5230\u6a5f\u5668\u4e2d\u589e\u52a0\u9a57\u8b49\u65b9\u5f0f\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">docker exec -it db bash\nmysql -u root -p\nuse mysql;\nALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_%E4%B8%8A%E5%82%B3%E6%AA%94%E6%A1%88%E5%A4%A7%E5%B0%8F%E4%BB%A5%E5%8F%8A%E9%80%A3%E7%B7%9A%E6%99%82%E9%96%93%E9%99%90%E5%88%B6\"><\/span>2. \u4e0a\u50b3\u6a94\u6848\u5927\u5c0f\u4ee5\u53ca\u9023\u7dda\u6642\u9593\u9650\u5236<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u5728 wordpress \u7684 <strong>\/var\/www\/html<\/strong> \u76ee\u9304\u4e0b\u589e\u52a0<strong> php.ini<\/strong>\uff0c\u8a18\u61b6\u9ad4\u9650\u5236\u5efa\u8b70\u4e0d\u8981\u958b\u592a\u5927\uff0c\u4e0d\u7136\u53ef\u80fd\u50b3\u6a94\u6848\u50b3\u5230\u6b7b\u6a5f\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">file_uploads = On\nmemory_limit = 128M\nupload_max_filesize = 64M\npost_max_size = 64M\nmax_execution_time = 600<\/pre>\n\n\n\n<p>\u56e0\u70ba\u9084\u6703\u5148\u7d93\u904e\u9996\u9801\u624d proxy \u904e\u4f86\uff0c\u9996\u9801\u7684 nginx <strong>default.conf<\/strong> \u4e5f\u9700\u8981\u52a0\u4e0a\u4ee5\u4e0b\u8a2d\u5b9a\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">client_max_body_size       128M;\nproxy_connect_timeout       300;\nproxy_send_timeout          300;\nproxy_read_timeout          300;\nsend_timeout                300;<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_%E5%95%9F%E7%94%A8%E5%A4%9A%E7%AB%99%E9%BB%9E\"><\/span>3. \u555f\u7528\u591a\u7ad9\u9ede<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u7de8\u8f2f wordpress \u6839\u76ee\u9304\u4e0b\u7684 <strong>wp-config.php<\/strong>\uff0c\u52a0\u5165\u4ee5\u4e0b\u8a2d\u5b9a\u958b\u555f\u591a\u7ad9\u9ede\u529f\u80fd\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">define('WP_ALLOW_MULTISITE', true);<\/pre>\n\n\n\n<p>\u9032\u5165 wordpress \u7684\u7ba1\u7406\u5f8c\u53f0\uff0c\u5c31\u6703\u770b\u5230\u9078\u55ae\u8a2d\u5b9a\u4e2d\u591a\u4e86\u591a\u7ad9\u9ede\u53ef\u4ee5\u9078\uff0c\u7cfb\u7d71\u6703\u544a\u8a34\u4f60\u8981\u5982\u4f55\u589e\u52a0\u8a2d\u5b9a\u3002<\/p>\n\n\n\n<p>(1) \u5728 <strong>wp-config.php<\/strong> \u52a0\u5165\u4ee5\u4e0b\u8a2d\u5b9a\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">define('MULTISITE', true);\ndefine('SUBDOMAIN_INSTALL', false);\ndefine('DOMAIN_CURRENT_SITE', 'wp.winter-weng.cc');\ndefine('PATH_CURRENT_SITE', '\/');\ndefine('SITE_ID_CURRENT_SITE', 1);\ndefine('BLOG_ID_CURRENT_SITE', 1);<\/pre>\n\n\n\n<p>(2) \u4fee\u6539 <strong>\/var\/www\/html\/.htaccess<\/strong><\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">RewriteEngine On\nRewriteRule .* - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization}]\nRewriteBase \/\nRewriteRule ^index\\.php$ - [L]\n\n# add a trailing slash to \/wp-admin\nRewriteRule ^([_0-9a-zA-Z-]+\/)?wp-admin$ $1wp-admin\/ [R=301,L]\n\nRewriteCond %{REQUEST_FILENAME} -f [OR]\nRewriteCond %{REQUEST_FILENAME} -d\nRewriteRule ^ - [L]\nRewriteRule ^([_0-9a-zA-Z-]+\/)?(wp-(content|admin|includes).*) $2 [L]\nRewriteRule ^([_0-9a-zA-Z-]+\/)?(.*\\.php)$ $2 [L]\nRewriteRule . index.php [L]<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4_%E5%B0%87%E8%B3%87%E6%BA%90%E7%A7%BB%E5%8B%95%E5%88%B0_S3\"><\/span>4. \u5c07\u8cc7\u6e90\u79fb\u52d5\u5230 S3<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u7576 wordpress \u4f7f\u7528\u4e45\u4e86\uff0cwp-content \u6703\u8b8a\u5f97\u76f8\u7576\u80a5\u5927\uff0c\u56e0\u6b64\u6211\u60f3\u5c07\u8cc7\u6e90\u6a94\u6539\u70ba\u4e0a\u50b3\u81f3 AWS S3\u3002<\/p>\n\n\n\n<p>(1) \u9996\u5148\u5148\u81f3 AWS \u7684 IAM \u4f9d\u7167\u4ee5\u4e0b\u6b65\u9a5f\u5efa\u7acb\u4f7f\u7528\u8005\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"509\" height=\"386\" src=\"https:\/\/rukiawinter-wordpress.s3.ap-northeast-1.amazonaws.com\/wp-content\/uploads\/sites\/3\/2021\/03\/07021223\/iam1.jpg\" alt=\"\" class=\"wp-image-651\" srcset=\"https:\/\/rukiawinter-wordpress.s3.ap-northeast-1.amazonaws.com\/wp-content\/uploads\/sites\/3\/2021\/03\/07021223\/iam1.jpg 509w, https:\/\/rukiawinter-wordpress.s3.ap-northeast-1.amazonaws.com\/wp-content\/uploads\/sites\/3\/2021\/03\/07021223\/iam1-300x228.jpg 300w\" sizes=\"auto, (max-width: 509px) 100vw, 509px\" \/><figcaption>\u65b0\u589e\u4f7f\u7528\u8005<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"986\" height=\"494\" src=\"https:\/\/rukiawinter-wordpress.s3.ap-northeast-1.amazonaws.com\/wp-content\/uploads\/sites\/3\/2021\/03\/07021239\/iam2.jpg\" alt=\"\" class=\"wp-image-652\" srcset=\"https:\/\/rukiawinter-wordpress.s3.ap-northeast-1.amazonaws.com\/wp-content\/uploads\/sites\/3\/2021\/03\/07021239\/iam2.jpg 986w, https:\/\/rukiawinter-wordpress.s3.ap-northeast-1.amazonaws.com\/wp-content\/uploads\/sites\/3\/2021\/03\/07021239\/iam2-300x150.jpg 300w, https:\/\/rukiawinter-wordpress.s3.ap-northeast-1.amazonaws.com\/wp-content\/uploads\/sites\/3\/2021\/03\/07021239\/iam2-768x385.jpg 768w, https:\/\/rukiawinter-wordpress.s3.ap-northeast-1.amazonaws.com\/wp-content\/uploads\/sites\/3\/2021\/03\/07021239\/iam2-816x409.jpg 816w, https:\/\/rukiawinter-wordpress.s3.ap-northeast-1.amazonaws.com\/wp-content\/uploads\/sites\/3\/2021\/03\/07021239\/iam2-400x200.jpg 400w\" sizes=\"auto, (max-width: 986px) 100vw, 986px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"999\" height=\"581\" src=\"https:\/\/rukiawinter-wordpress.s3.ap-northeast-1.amazonaws.com\/wp-content\/uploads\/sites\/3\/2021\/03\/07021252\/iam3.jpg\" alt=\"\" class=\"wp-image-653\" srcset=\"https:\/\/rukiawinter-wordpress.s3.ap-northeast-1.amazonaws.com\/wp-content\/uploads\/sites\/3\/2021\/03\/07021252\/iam3.jpg 999w, https:\/\/rukiawinter-wordpress.s3.ap-northeast-1.amazonaws.com\/wp-content\/uploads\/sites\/3\/2021\/03\/07021252\/iam3-300x174.jpg 300w, https:\/\/rukiawinter-wordpress.s3.ap-northeast-1.amazonaws.com\/wp-content\/uploads\/sites\/3\/2021\/03\/07021252\/iam3-768x447.jpg 768w, https:\/\/rukiawinter-wordpress.s3.ap-northeast-1.amazonaws.com\/wp-content\/uploads\/sites\/3\/2021\/03\/07021252\/iam3-816x475.jpg 816w\" sizes=\"auto, (max-width: 999px) 100vw, 999px\" \/><\/figure>\n\n\n\n<p>\u5b8c\u6210\u4e4b\u5f8c\uff0c\u5728\u9019\u4e00\u6b65\u5207\u8a18\u8981\u5c07\u91d1\u9470\u5132\u5b58\u8d77\u4f86\uff0c\u5982\u679c\u932f\u904e\u5c31\u53ea\u80fd\u91cd\u65b0\u518d\u751f\u6210\u4e86\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1000\" height=\"483\" src=\"https:\/\/rukiawinter-wordpress.s3.ap-northeast-1.amazonaws.com\/wp-content\/uploads\/sites\/3\/2021\/03\/07021302\/iam4.jpg\" alt=\"\" class=\"wp-image-654\" srcset=\"https:\/\/rukiawinter-wordpress.s3.ap-northeast-1.amazonaws.com\/wp-content\/uploads\/sites\/3\/2021\/03\/07021302\/iam4.jpg 1000w, https:\/\/rukiawinter-wordpress.s3.ap-northeast-1.amazonaws.com\/wp-content\/uploads\/sites\/3\/2021\/03\/07021302\/iam4-300x145.jpg 300w, https:\/\/rukiawinter-wordpress.s3.ap-northeast-1.amazonaws.com\/wp-content\/uploads\/sites\/3\/2021\/03\/07021302\/iam4-768x371.jpg 768w, https:\/\/rukiawinter-wordpress.s3.ap-northeast-1.amazonaws.com\/wp-content\/uploads\/sites\/3\/2021\/03\/07021302\/iam4-816x394.jpg 816w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<p>(2) \u81f3 S3 \u958b\u555f\u65b0\u7684\u5132\u5b58\u8caf\u9ad4<\/p>\n\n\n\n<p>\u7167\u8457\u6b65\u9a5f\u8a2d\u5b9a\u5c31\u53ef\u4ee5\u4e86\uff0c<strong>\u5132\u5b58\u8caf\u9ad4\u7684\u300c\u5c01\u9396\u516c\u958b\u5b58\u53d6\u300d\u8a2d\u5b9a<\/strong>\u8a18\u5f97\u8981\u8a2d\u5b9a\u70ba\u516c\u958b\u3002<\/p>\n\n\n\n<p>\u65b0\u589e\u597d\u4e4b\u5f8c\uff0c\u5efa\u7acb\u8cc7\u6599\u593e <strong>wp-content<\/strong> \u4ee5\u53ca\u4e0b\u5c64\u7684 <strong>uploads<\/strong>\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5_%E4%BF%AE%E6%AD%A3%E8%B3%87%E6%96%99\"><\/span>5. \u4fee\u6b63\u8cc7\u6599<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u6b64\u6b21\u4e3b\u6a5f\u7684\u66f4\u65b0\uff0c\u4e5f\u8b93\u539f\u672c\u5099\u4efd\u8cc7\u6599\u51fa\u73fe domain \u5c0d\u4e0d\u4e0a\u7684\u554f\u984c\uff0c\u5305\u542b\u5716\u7247\u8cc7\u6e90\u8981\u63db\u6210 S3 \u7684\u7db2\u5740\u90fd\u53ef\u4ee5\u900f\u904e\u4ee5\u4e0b\u65b9\u5f0f\u4fee\u6b63\u8cc7\u6599\u3002<\/p>\n\n\n\n<p>\u7576\u7136\u4fee\u6b63\u8cc7\u6599\u6709\u5f88\u591a\u7a2e\u65b9\u5f0f\uff0c\u5982\u679c\u4e0d\u719f\u6089\u6307\u4ee4\u4e5f\u53ef\u4ee5\u76f4\u63a5\u7de8\u8f2f\u5099\u4efd\u8cc7\u6599\u6a94\u6848\uff0c\u6216\u662f\u900f\u904e Sequel Pro \u7b49\u5de5\u5177\u8f14\u52a9\u3002<\/p>\n\n\n\n<p>\u9032\u5165\u8cc7\u6599\u5eab\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">docker exec -it db bash\nmysql -u root -p<\/pre>\n\n\n\n<p>\u5c07\u820a\u7db2\u5740\u66f4\u65b0\u70ba\u65b0\u7db2\u5740\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">UPDATE wp_options SET option_value = replace(option_value, 'http:\/\/www.oldurl', 'http:\/\/www.newurl') WHERE option_name = 'home' OR option_name = 'siteurl';\n\nUPDATE wp_posts SET guid = replace(guid, 'http:\/\/www.oldurl','http:\/\/www.newurl');\n\nUPDATE wp_posts SET post_content = replace(post_content, 'http:\/\/www.oldurl', 'http:\/\/www.newurl');\n\nUPDATE wp_postmeta SET meta_value = replace(meta_value,'http:\/\/www.oldurl','http:\/\/www.newurl');<\/pre>\n\n\n\n<p>\u56e0\u70ba\u8cc7\u6e90\u5df2\u7d93\u653e\u7f6e\u5728 S3\uff0c\u672c\u5730\u4e0d\u6703\u6709\u7559\u6a94\uff0c\u5982\u679c\u8cc7\u6599\u6c92\u6709\u6e05\u4e7e\u6de8\uff0c\u9032\u5230\u5a92\u9ad4\u5eab\u6703\u770b\u5230\u7834\u5716\uff0c\u53ef\u57f7\u884c\u4ee5\u4e0b\u6307\u4ee4\u522a\u9664\u5a92\u9ad4\u5eab\u7684\u8cc7\u6599\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">DELETE FROM `wp_posts` WHERE `post_type` = \"attachment\";\nDELETE FROM `wp_postmeta` WHERE `meta_key` = \"_wp_attached_file\";\nDELETE FROM `wp_postmeta` WHERE `meta_key` = \"_wp_attachment_metadata\";<\/pre>\n\n\n\n<p>\u8a2d\u5b9a\u5b8c\u6210\u5f8c\u7d42\u65bc\u53ef\u4ee5\u958b\u5fc3\u5beb\u4f5c\u5566\uff5e<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%8F%83%E8%80%83%E8%B3%87%E6%96%99%EF%BC%9A\"><\/span>\u53c3\u8003\u8cc7\u6599\uff1a<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Increase Media File Maximum Upload Size in WordPress Step by Step Guide<br><a rel=\"noreferrer noopener\" href=\"https:\/\/www.cloudways.com\/blog\/increase-media-file-maximum-upload-size-in-wordpress\/\" target=\"_blank\">https:\/\/www.cloudways.com\/blog\/increase-media-file-maximum-upload-size-in-wordpress\/<\/a><\/li><li>WORDPRESS \u4e0a\u50b3\u5716\u7247\u6642\u51fa\u73fe\u932f\u8aa4 \u300c\u7531\u65bc\u4f3a\u670d\u5668\u7e41\u5fd9\u6216\u6c92\u6709\u8db3\u5920\u7684\u8cc7\u6e90\uff0c\u56e0\u6b64\u7121\u6cd5\u5b8c\u6210\u5716\u7247\u5f8c\u671f\u8655\u7406\u3002\u4e0a\u50b3\u8f03\u5c0f\u5c3a\u5bf8\u7684\u5716\u7247\u6703\u6709\u6240\u6539\u5584\u300d\u89e3\u6c7a\u65b9\u6cd5<br><a rel=\"noreferrer noopener\" href=\"https:\/\/www.tedlin.tw\/2021\/02\/5940\" target=\"_blank\">https:\/\/www.tedlin.tw\/2021\/02\/5940<\/a><\/li><li>WP Offload S3 Lite \u5916\u639b\u4f86\u5132\u5b58 WordPress \u5a92\u9ad4\u5eab<br><a href=\"https:\/\/yungke.me\/wp-offload-s3-lite-wordpress-media-library\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/yungke.me\/wp-offload-s3-lite-wordpress-media-library\/<\/a><\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E4%B8%BB%E6%A9%9F%E7%92%B0%E5%A2%83%E6%9B%B4%E6%96%B0%E5%AF%A6%E9%8C%84%EF%BC%9A\"><\/span>\u4e3b\u6a5f\u74b0\u5883\u66f4\u65b0\u5be6\u9304\uff1a<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ol class=\"wp-block-list\" id=\"block-5d87fc04-e736-4000-b30c-1e9f94c82607\"><li><a rel=\"noreferrer noopener\" href=\"https:\/\/wp.winter-weng.cc\/work\/?p=627\" target=\"_blank\">\u4e3b\u6a5f\u74b0\u5883\u66f4\u65b0\u5be6\u9304 (1) &#8211; \u524d\u60c5\u63d0\u8981\u7bc7<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/wp.winter-weng.cc\/work\/?p=630\" target=\"_blank\">\u4e3b\u6a5f\u74b0\u5883\u66f4\u65b0\u5be6\u9304 (2) \u2013 Docker \u7bc7<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/wp.winter-weng.cc\/work\/?p=639\" target=\"_blank\">\u4e3b\u6a5f\u74b0\u5883\u66f4\u65b0\u5be6\u9304 (3) \u2013 DNS \u53ca\u8f49\u5c0e\u7bc7<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/wp.winter-weng.cc\/work\/?p=645\" target=\"_blank\">\u4e3b\u6a5f\u74b0\u5883\u66f4\u65b0\u5be6\u9304 (4) \u2013 SSL \u7bc7<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/wp.winter-weng.cc\/work\/?p=649\" target=\"_blank\">\u4e3b\u6a5f\u74b0\u5883\u66f4\u65b0\u5be6\u9304 (5) \u2013 WP \u7bc7<\/a><\/li><li><a rel=\"noreferrer noopener\" href=\"https:\/\/wp.winter-weng.cc\/work\/?p=656\" target=\"_blank\">\u4e3b\u6a5f\u74b0\u5883\u66f4\u65b0\u5be6\u9304 (6) \u2013 \u5b8c\u7d50\u7bc7<\/a><\/li><\/ol>\n","protected":false},"excerpt":{"rendered":"<p>\u4e00\u958b\u59cb\u539f\u672c\u6253\u7b97\u4ee5 nginx + wp-fpm \u7684&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"pgc_sgb_lightbox_settings":"","footnotes":""},"categories":[11],"tags":[],"class_list":["post-649","post","type-post","status-publish","format-standard","hentry","category-11"],"_links":{"self":[{"href":"https:\/\/wp.winter-weng.cc\/work\/index.php?rest_route=\/wp\/v2\/posts\/649","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wp.winter-weng.cc\/work\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wp.winter-weng.cc\/work\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wp.winter-weng.cc\/work\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wp.winter-weng.cc\/work\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=649"}],"version-history":[{"count":5,"href":"https:\/\/wp.winter-weng.cc\/work\/index.php?rest_route=\/wp\/v2\/posts\/649\/revisions"}],"predecessor-version":[{"id":678,"href":"https:\/\/wp.winter-weng.cc\/work\/index.php?rest_route=\/wp\/v2\/posts\/649\/revisions\/678"}],"wp:attachment":[{"href":"https:\/\/wp.winter-weng.cc\/work\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=649"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wp.winter-weng.cc\/work\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=649"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wp.winter-weng.cc\/work\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=649"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}