{"id":3810,"date":"2026-03-22T14:04:56","date_gmt":"2026-03-22T06:04:56","guid":{"rendered":"https:\/\/yowlab.idv.tw\/wordpress\/?p=3810"},"modified":"2026-05-05T23:04:26","modified_gmt":"2026-05-05T15:04:26","slug":"wordpress-%e6%90%ac%e5%ae%b6%ef%bc%8c%e8%b3%87%e6%96%99%e5%ba%ab%e8%99%95%e7%90%86","status":"publish","type":"post","link":"https:\/\/yowlab.idv.tw\/wordpress\/?p=3810","title":{"rendered":"WordPress \u642c\u5bb6\uff0c\u8cc7\u6599\u5eab\u8655\u7406"},"content":{"rendered":"<p>\u7db2\u7ad9\u56e0\u6545\u9700\u8981\u9077\u79fb\u5230\u4e0d\u540c\u4e3b\u6a5f\u3002<br \/>\n\u539f\u4f86\u67b6\u69cb\u5728 Mariadb \u4e0a\u7684 WordPress \u8981\u5982\u4f55\u7121\u640d\u7684\u642c\u5bb6\u5462\uff1f<\/p>\n<style type=\"text\/css\">\nli.present01 {line-height:2em; background-color:#F5E5C9; padding:5px; border-radius:10px; font-weight:bold; margin:5px;}\nli.present02 {line-height:2em; background-color:#ceffbc; padding:5px; border-radius:10px; font-weight:bold; margin:5px;}\nli.present03 {line-height:1.5em; background-color:#b3dffa; padding:5px; border-radius:10px; font-weight:bold; margin:5px;}\nul.none {list-style-type:none;line-height:1.5em; padding:10px;}\nol.lower-alpha {list-style-type:lower-alpha;}\nol.lower-roman {list-style-type:lower-roman;}\nul.note {line-height:1.5em; padding:2px; font-weight:bold; font-size:0.9em;}\n.highlight01 {font-weight:bold; line-height:1.5em; background-color:#e7f49c; padding:0px 2px; border:1px; border-radius:10px;}\n.highlight02 {font-weight:bold; line-height:1.5em; background-color:#F2F26B; padding:1px 1px; border:1px;}\n.highlight03 {font-weight:bold; line-height:1.5em; background-color:#F9BF72; padding:3px 10px; border:2px; border-radius:10px;}\n.highlight04 {font-weight:bold; line-height:1.5em; background-color:#F9BF72; padding:3px 10px 0px 10px; border:0px; border-radius:3px;}\n.box01 {margin: 5px; border:1px #19130B solid; border-radius:5px; padding:10px;}\n.box02 {margin: 5px; font-weight:bold; line-height:1.5em; padding:10px; border:1px #19130B solid; border-radius:5px; float: left;}\nh3 {border:2px #000 solid; border-width:0px 0px 1px 0px; padding-width:0px 0px 3px 0px;}\nh4 {border:2px #000 solid; border-width:0px 0px 1px 0px; padding-width:0px 0px 3px 0px;}\npre { margin: 0px; padding:0px 5px; border:2px soild #000; }<\/p>\n<\/style>\n<p>\u7e3d\u9ad4\u4f86\u8aaa\uff0c\u5c31\u4ee5\u4e0b\u4e09\u90e8\u66f2\uff1a<\/p>\n<ol>\n<li class=\"present01\">\u8cc7\u6599\u5eab\u5099\u4efd<\/li>\n<pre><code>\r\n       mysqldump -u [\u8cc7\u6599\u5eab\u4f7f\u7528\u8005\u540d\u7a31] -p [WordPress\u8cc7\u6599\u5eab\u540d\u7a31] > [\u5099\u4efd\u6a94\u6848\u540d\u7a31.sql]   \r\n    <\/code><\/pre>\n<p>    \u8cc7\u6599\u5eab\u5099\u4efd\u90e8\u4efd\uff0c\u5c0d\u6211\u4f86\u8aaa\uff0c\u56e0\u70ba\u662f\u6bcf\u5929\u56fa\u5b9a\u6642\u9593\u5099\u4efd\uff0c\u6240\u4ee5\u7b97\u5b8c\u6210\u3002<\/p>\n<li class=\"present01\">\u65b0\u4e3b\u6a5f\u4e0a\u7684 Mariadb \u5b89\u88dd\u8207\u8a2d\u5b9a<\/li>\n<pre><code>\r\n\r\n    apt -y install mariadb     ## \u5b89\u88ddMariadb\r\n\r\n    sudo mysql_secure_installation   ## \u521d\u59cb\u5316\u5b89\u5168\u8a2d\u5b9a\uff0c\u522a\u9664\u9810\u8a2d\u57f7\u4e2d\u4e0d\u5fc5\u8981\u7684\u8a2d\u5b9a\r\n   (sudo mariadb_secure_installation ## \u6709\u4e9b\u7248\u672c\u662f\u9019\u500b\u6307\u4ee4) \r\n\r\n    mysql -u root -p ## \u767b\u5165 mariadb\r\n\r\n      >> CREATE USER '\u8cc7\u6599\u5eab\u4f7f\u7528\u8005\u540d\u7a31'@'localhost' IDENTIFIED BY '\u5bc6\u78bc';   ## \u7528\u9019\u500b\u4f7f\u7528\u8005\u4f86\u53d6\u4ee3 root \u64cd\u4f5c\u8cc7\u6599\u5eab\r\n      >> GRANT ALL PRIVILEGES ON *.* TO '\u8cc7\u6599\u5eab\u4f7f\u7528\u8005\u540d\u7a31'@'localhost' WITH GRANT OPTION;  ## \u8ce6\u4e88\u8a72\u4f7f\u7528\u8005\u6700\u9ad8\u6b0a\u9650\r\n      >> FLUSH PRIVILEGES;  ## \u5957\u7528\u6b0a\u9650\r\n      >> exit; ##\u96e2\u958b mariadb\r\n\r\n    mysql -u [\u8cc7\u6599\u5eab\u4f7f\u7528\u8005\u540d\u7a31]  -p    ## \u7528\u65b0[\u8cc7\u6599\u5eab\u4f7f\u7528\u8005\u540d\u7a31] \u91cd\u65b0\u767b\u5165 mariadb  \r\n\r\n      >> DROP USER 'root'@'\u4e3b\u6a5f\u540d\u7a31'; ##\u522a\u9664 root\r\n      >> CREATE DATABASE wordpress DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;  ## \u5efa\u7acb wordpress \u8cc7\u6599\u5eab\r\n      >> exit; ##\u96e2\u958b mariadb\r\n\r\n    <\/code><\/pre>\n<p>    \u8cc7\u6599\u5eab\u522a\u9664 root \u90e8\u4efd\uff0c\u4e3b\u8981\u4e5f\u662f\u56e0\u70ba \u5b89\u5168\u8003\u91cf\u3002<\/p>\n<li class=\"present01\">\u8cc7\u6599\u5eab\u532f\u5165\u5230\u65b0\u4e3b\u6a5f<\/li>\n<pre><code>\r\n       mysql -u [\u8cc7\u6599\u5eab\u4f7f\u7528\u8005\u540d\u7a31] -p [WordPress\u8cc7\u6599\u5eab\u540d\u7a31] <  [\u5099\u4efd\u6a94\u6848\u540d\u7a31.sql]   \r\n    <\/code><\/pre>\n<p>&nbsp;<\/p>\n<\/ol>\n<p>\u6b63\u5e38\u4f86\u8aaa\uff0c\u9019\u6a23\u8cc7\u6599\u5eab\u4fbf\u5df2\u5b8c\u6210\u642c\u5bb6\u3002<\/p>\n<p>&nbsp;<\/p>\n<h3>\u5e95\u4e0b\u88dc\u5145\u9047\u5230\u4e00\u4e9b\u554f\u984c\uff0c\u4ee5\u53ca\u5982\u4f55\u89e3\u6c7a\u3002<\/h3>\n<ol>\n<li class=\"present01\">[\u8cc7\u6599\u5eab\u4f7f\u7528\u8005\u540d\u7a31] \u5bc6\u78bc\u5fd8\u8a18\u4e86<\/li>\n<pre><code>\r\n       sudo systemctl stop mairadb.servicce ## \u5148\u505c\u6b62 mariadb \u904b\u4f5c\r\n\r\n       sudo mysqld_safe --skip-grant-tables --skip-networking &  ## \u4ee5\u5b89\u5168\u6a21\u5f0f\u555f\u52d5 mariadb\r\n\r\n       mysql -u [\u8cc7\u6599\u5eab\u4f7f\u7528\u8005\u540d\u7a31] -p   ## \u4ee5\u7121\u5bc6\u78bc\u65b9\u5f0f\u767b\u5165\u8cc7\u6599\u5eab\r\n\r\n         >> ALTER USER '[\u8cc7\u6599\u5eab\u4f7f\u7528\u8005\u540d\u7a31]'@'localhost' IDENTIFIED BY '[\u65b0\u5bc6\u78bc]';   ## \u66f4\u6539\u65b0\u5bc6\u78bc\r\n         >> FLUSH PRIVILEGES;  ## \u5957\u7528\u8b8a\u52d5\r\n         >> exit;  ## \u767b\u51fa\u8cc7\u6599\u5eab\r\n\r\n      sudo kill -9 $(ps aux | grep mysql | grep -v grep | awk '{print $2}')  ## \u505c\u6b62mariadb\r\n\r\n      sudo systemctl start mariadb   ## mariadb \u555f\u52d5\r\n\r\n<\/code><\/pre>\n<p>&nbsp;<\/p>\n<li class=\"present01\">\u653e\u7f6e mysql \u7684\u7a7a\u9593\u6eff\u4e86 <\/li>\n<p>    mysql \u8cc7\u6599\u5eab\u7684\u786c\u789f\u7a7a\u9593\u6eff\u4e86\uff0c\u4e0d\u5920\u7528\u4e86\uff01<\/p>\n<p>    \u6700\u5feb\u7684\u89e3\u6c7a\u65b9\u5f0f\uff0c\u4fbf\u662f\u642c\u5230\u8db3\u5920\u7a7a\u9593\u7684\u76ee\u9304\u5e95\u4e0b\uff0c\u4f8b\u5982\uff1a \/home\/var\/lib\/mysql \u3002<\/p>\n<pre><code>\r\n       sudo systemctl stop mairadb.servicce ## \u5148\u505c\u6b62 mariadb \u904b\u4f5c\r\n\r\n       sudo mkdir -p \/home\/var\/lib\/mysql ## \u5efa\u7acb\u76ee\u9304\r\n\r\n       sudo chown -Rf mysql:mysql \/home\/var\/lib\/mysql  ## \u8a2d\u5b9a\u76ee\u9304\u4f7f\u7528\u8005\u8207\u6b0a\u9650\r\n       sudo chmod -Rf 700 \/home\/var\/lib\/mysql  \r\n\r\n       sudo rsync -avz \/var\/lib\/mysql  \/home\/var\/lib\/  ## \u642c\u79fb\u76ee\u9304\r\n       sudo ls -l \/home\/var\/lib\/  ## \u6aa2\u67e5\u76ee\u9304\u6b0a\u9650\r\n\r\n       \u5c07\u4ee5\u4e0b\u52a0\u5165 \/etc\/fstab \uff0c\u7136\u5f8c\u639b\u8f09\u8d77\u4f86\r\n       <span class=\"highlight01\">\/home\/var\/lib\/mysql    \/var\/lib\/mysql    none    bind    0 0 <\/span>\r\n\r\n       sudo systemctl daemon-reload\r\n       sudo mount -a\r\n\r\n       sudo systemctl start mariadb   ## mariadb \u555f\u52d5\r\n\r\n    <\/code><\/pre>\n<p>&nbsp;<\/p>\n<p>     \u4ee5\u4e0a \/etc\/fstab \u4f5c\u6cd5\uff0c\u76ee\u7684\u662f\u8b93\u7cfb\u7d71\u5728\u958b\u6a5f\u6642\u81ea\u52d5\u57f7\u884c\u76ee\u9304\u639b\u8f09\u3002<\/p>\n<p>     \u5404\u6b04\u4f4d\u7684\u8a73\u7d30\u610f\u7fa9\u5982\u4e0b\uff1a<\/p>\n<ul>\n<li>\/home\/var\/lib\/mysql (\u4f86\u6e90\u76ee\u9304)\uff1a<\/li>\n<p>        \u8cc7\u6599\u5be6\u969b\u5b58\u653e\u7684\u65b0\u4f4d\u7f6e\u3002<\/p>\n<li>\/var\/lib\/mysql (\u639b\u8f09\u9ede)\uff1a<\/li>\n<p>        \u7cfb\u7d71\u8207\u61c9\u7528\u7a0b\u5f0f(\u4f8b\u5982\uff1aMariadb)\u9810\u671f\u8981\u8b80\u53d6\u8cc7\u6599\u7684\u539f\u59cb\u820a\u4f4d\u7f6e\u3002<\/p>\n<li>none (\u6a94\u6848\u7cfb\u7d71\u985e\u578b)\uff1a<\/li>\n<p>        \u56e0\u70ba\u662f\u5c07\u76ee\u9304\u639b\u8f09\u5230\u53e6\u4e00\u500b\u76ee\u9304\uff0c\u800c\u975e\u639b\u8f09\u5be6\u969b\u7684\u78c1\u789f\u5206\u5272\u5340\uff0c\u6240\u4ee5\u4e0d\u9069\u7528\u7279\u5b9a\u7684\u6a94\u6848\u7cfb\u7d71\u683c\u5f0f\uff08\u5982 ext4\uff09\uff0c\u586b\u5beb none\u3002<\/p>\n<li>bind (\u639b\u8f09\u9078\u9805)\uff1a<\/li>\n<p>        \u9019\u662f\u9019\u884c\u8a2d\u5b9a\u7684\u6838\u5fc3\u95dc\u9375\u3002bind \u7684\u4f5c\u7528\u662f\u5c07\u4e00\u500b\u5df2\u7d93\u5b58\u5728\u65bc\u6a94\u6848\u7cfb\u7d71\u4e2d\u7684\u76ee\u9304\uff08\u5b50\u6a39\uff09\u300c\u93e1\u50cf\u300d\u6216\u300c\u7d81\u5b9a\u300d\u5230\u53e6\u4e00\u500b\u639b\u8f09\u9ede\u4e0a\u3002<\/p>\n<p>        \u70ba\u4f55\u4e0d\u7528\u8edf\u9023\u7d50 (ln -s)\uff1f <\/p>\n<p>        \u8edf\u9023\u7d50\u53ea\u662f\u4e00\u500b\u6307\u6a19\u6a94\u6848\uff0c\u67d0\u4e9b\u5b89\u5168\u6a5f\u5236\uff08\u5982 vsftpd \u7684 chroot\u3001AppArmor\u3001SELinux\uff09\u6703\u62d2\u7d55\u6216\u7121\u6cd5\u6b63\u78ba\u89e3\u6790\u8edf\u9023\u7d50\u6240\u6307\u5411\u7684\u5be6\u969b\u8def\u5f91\u3002\u800c bind mount \u5728\u4f5c\u696d\u7cfb\u7d71\u6838\u5fc3\u5c64\u7d1a\u6703\u8b93\u9019\u5169\u500b\u8def\u5f91\u770b\u8d77\u4f86\u5b8c\u5168\u7b49\u540c\u65bc\u540c\u4e00\u500b\u5be6\u9ad4\u76ee\u9304\uff0c\u5b8c\u7f8e\u6b3a\u9a19\u7a0b\u5f0f\uff0c\u89e3\u6c7a\u6b0a\u9650\u963b\u64cb\u554f\u984c\u3002<\/p>\n<li>0 (dump \u5099\u4efd\u9078\u9805)\uff1a<\/li>\n<p>       \u8a2d\u5b9a\u70ba 0 \u8868\u793a\u4e0d\u88ab dump \u6307\u4ee4\u5099\u4efd\u3002<\/p>\n<li>0 (fsck \u6aa2\u67e5\u9806\u5e8f)\uff1a<\/li>\n<p>       \u8a2d\u5b9a\u70ba 0 \u8868\u793a\u958b\u6a5f\u6642\u4e0d\u9700\u8981\u9032\u884c\u6a94\u6848\u7cfb\u7d71\u6aa2\u67e5\u3002<\/p>\n<\/ul>\n<p>   \u7c21\u55ae\u4f86\u8aaa\uff0c\u9019\u4e9b\u8a2d\u5b9a\u5c31\u662f\u8b93 Mariadb \u4ee5\u70ba\u5b83\u9084\u662f\u5728\u8b80\u5beb \/var\/lib\/mysql\uff0c\u4f46\u5be6\u969b\u4e0a\u8cc7\u6599\u662f\u5beb\u5165 \/home \u7684\u65b0\u76ee\u9304\u4e2d\uff0c\u4e14\u80fd\u5b89\u5168\u907f\u958b\u7cfb\u7d71\u7684\u8edf\u9023\u7d50\u9650\u5236\u3002<\/p>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>\u7db2\u7ad9\u56e0\u6545\u9700\u8981\u9077\u79fb\u5230\u4e0d\u540c\u4e3b\u6a5f\u3002 \u539f\u4f86\u67b6\u69cb\u5728 Mariadb \u4e0a\u7684 WordPress <a class=\"more-link\" href=\"https:\/\/yowlab.idv.tw\/wordpress\/?p=3810\">Continue reading <span class=\"screen-reader-text\">  WordPress \u642c\u5bb6\uff0c\u8cc7\u6599\u5eab\u8655\u7406<\/span><span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[136,137],"class_list":["post-3810","post","type-post","status-publish","format-standard","hentry","category-3","tag-mariadb","tag-wordpress"],"_links":{"self":[{"href":"https:\/\/yowlab.idv.tw\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3810","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yowlab.idv.tw\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yowlab.idv.tw\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yowlab.idv.tw\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/yowlab.idv.tw\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3810"}],"version-history":[{"count":41,"href":"https:\/\/yowlab.idv.tw\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3810\/revisions"}],"predecessor-version":[{"id":3929,"href":"https:\/\/yowlab.idv.tw\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3810\/revisions\/3929"}],"wp:attachment":[{"href":"https:\/\/yowlab.idv.tw\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3810"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yowlab.idv.tw\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3810"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yowlab.idv.tw\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3810"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}