{"id":592,"date":"2024-04-02T20:04:42","date_gmt":"2024-04-02T12:04:42","guid":{"rendered":"https:\/\/jonasme.ddns.net\/?p=592"},"modified":"2024-04-02T20:19:33","modified_gmt":"2024-04-02T12:19:33","slug":"linux%e8%b3%87%e6%96%99%e8%bd%89%e7%a7%bb%e8%a6%8f%e5%8a%83%e8%88%87%e5%9f%b7%e8%a1%8c","status":"publish","type":"post","link":"https:\/\/jonasvip.ddns.net\/?p=592","title":{"rendered":"Linux\u8cc7\u6599\u8f49\u79fb\u898f\u5283\u8207\u57f7\u884c"},"content":{"rendered":"\n<p class=\"has-small-font-size\">\u5929\u707d\u4eba\u798d\u96e3\u4ee5\u907f\u514d\uff0c\u7576\u4e3b\u8981\u7684\u4f3a\u670d\u5668\u56e0\u610f\u5916\u6216\u932f\u8aa4\u7121\u6cd5\u904b\u4f5c\uff0c\u5099\u63f4\u7684\u8cc7\u6599\u53ef\u4ee5\u5373\u6642\u63a5\u624b\uff0c\u4f01\u696d\u7684\u670d\u52d9\u548c\u71df\u904b\u5f97\u4ee5\u670d\u52d9\u4e0d\u4e2d\u65b7\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><a href=\"https:\/\/hackmd.io\/@HijUWw3JT5ybBIi8gL3fCw\/rkwrUGKkC\" data-type=\"link\" data-id=\"https:\/\/hackmd.io\/@HijUWw3JT5ybBIi8gL3fCw\/rkwrUGKkC\">HackMD\u7b46\u8a18\u9023\u7d50<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div class=\"wp-block-group is-layout-constrained wp-block-group-is-layout-constrained\"><div class=\"wp-block-group__inner-container\">\n<p class=\"has-medium-font-size\"><strong>\u74b0\u5883\u9700\u6c42<\/strong><\/p>\n\n\n\n<p>1.Ubuntu Server 22.04.4<\/p>\n\n\n\n<p>2.Mariadb<\/p>\n\n\n\n<p>3.Apache<\/p>\n<\/div><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div class=\"wp-block-group is-layout-constrained wp-block-group-is-layout-constrained\"><div class=\"wp-block-group__inner-container\">\n<p class=\"has-medium-font-size\"><strong>\u529f\u80fd<\/strong><\/p>\n\n\n\n<p>1.\u4f7f\u7528Shellscript\u5099\u4efd\u4f7f\u7528\u8005\u5e33\u865f\u53ca\u6b0a\u9650<br>2.\u4f7f\u7528Shellscript\u5099\u4efdMariaDB \u3001Apache \u8cc7\u6599\u8207\u8a2d\u5b9a\u6a94<br>3.\u5c07A Linux\u8cc7\u6599\u5099\u4efd\uff0c\u8f49\u79fb\u81f3B Linux\u9084\u539f<\/p>\n<\/div><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>A Linux\u74b0\u5883\u8a2d\u5b9a\u5b89\u88dd(IP\uff1a10.167.223.46)<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>MariaDB\u53caApache\u5b89\u88dd<\/strong>\uff1asudo apt install mariadb-server apache2<\/li>\n\n\n\n<li><strong>\u5efa\u7acb\u4f7f\u7528\u8005\u5e33\u865f\u76f8\u95dc\u8a2d\u5b9a\uff1a<\/strong><br>user0401\uff0c\u6388\u4e88\u8a72\u7528\u6236\u57f7\u884csudo\u547d\u4ee4\u7684\u6b0a\u9650<br>user0402\uff0c\u6388\u4e88\u8a72\u7528\u6236\u64c1\u6709root\u6b0a\u9650\u7684\u6b0a\u9650<\/li>\n\n\n\n<li><strong>MariaDB\u5efa\u7acb\u8cc7\u6599\u5eabA1\u8ddfA2\u3001\u8cc7\u6599\u88680401A1\u8ddf0401A2\uff0c\u4ee5\u5229\u6e2c\u8a66<\/strong>\u3002<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE DATABASE A1;\n\nCREATE DATABASE A2;\n\ncreate table 0401A1(\nsn integer auto_increment primary key,\nname char(20),\nmail char(50),\nhome char(50),\nmessages char(50)\n);\n\ncreate table 0401A2(\nsn integer auto_increment primary key,\nname char(20),\nmail char(50),\nhome char(50),\nmessages char(50)\n);<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>A Linux\u8cc7\u6599\u5099\u4efd\uff1a<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>#!\/bin\/bash\n\n#\u5b9a\u7fa9\u5099\u4efd\u76ee\u9304\nBACKUP_DIR=\"\/home\/jonas\/0402\"\n\n#\u5099\u4efd\u4f7f\u7528\u8005\u8cc7\u6599\u548c\u6b0a\u9650\nsudo cp \/etc\/passwd \/etc\/group \/etc\/shadow $BACKUP_DIR\n\n#\u5099\u4efd\u6240\u6709\u7528\u6236\u5bb6\u76ee\u9304\nsudo rsync -a \/home\/ $BACKUP_DIR\/home\/\n\n#\u5099\u4efdMariaDB\nDB_USER=\"root\"\nDB_PASSWORD=\"123\"\nsudo mysqldump -u $DB_USER -p$DB_PASSWORD --all-databases > $BACKUP_DIR\/all_databases.sql\n\n#\u5099\u4efdApache\u914d\u7f6e\nsudo rsync -a \/etc\/apache2\/ $BACKUP_DIR\/apache2\/\n#Apache\u7db2\u7ad9\u6578\u64da\nsudo rsync -a \/var\/www\/ $BACKUP_DIR\/www\/<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>A Linux\u8cc7\u6599\u5099\u4efd\u6210\u529f\u622a\u5716\uff1a<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"802\" height=\"653\" src=\"https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/A2.png\" alt=\"\" class=\"wp-image-597\" srcset=\"https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/A2.png 802w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/A2-300x244.png 300w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/A2-768x625.png 768w\" sizes=\"(max-width: 802px) 100vw, 802px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"714\" height=\"522\" data-src=\"https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/A1-1.png\" alt=\"\" class=\"wp-image-596 lazyload\" data-srcset=\"https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/A1-1.png 714w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/A1-1-300x219.png 300w\" data-sizes=\"(max-width: 714px) 100vw, 714px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 714px; --smush-placeholder-aspect-ratio: 714\/522;\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>B Linux\u74b0\u5883\u8a2d\u5b9a\u5b89\u88dd(IP\uff1a10.167.223.32)<\/strong><\/p>\n\n\n\n<ul>\n<li><strong>MariaDB\u53caApache\u5b89\u88dd<\/strong>\uff1asudo apt install mariadb-server apache2<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>B Linux\u8cc7\u6599\u9084\u539f\uff1a<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>#!\/bin\/bash\n\n#\u5b9a\u7fa9\u5099\u4efd\u76ee\u9304\nBACKUP_DIR=\"\/home\/jonasb\/home\/jonas\/0402\"\n\n#\u9084\u539f\u4f7f\u7528\u8005\u8cc7\u6599\u548c\u6b0a\u9650\nsudo cp $BACKUP_DIR\/passwd $BACKUP_DIR\/group $BACKUP_DIR\/shadow \/etc\/\n\n#\u9084\u539f\u7528\u6236\u5bb6\u76ee\u9304\nsudo rsync -a $BACKUP_DIR\/home\/ \/home\/\n\n#\u9084\u539fMariaDB\nDB_USER=\"root\"\nDB_PASSWORD=\"123\"\nsudo mysql -u $DB_USER -p$DB_PASSWORD &lt; $BACKUP_DIR\/all_databases.sql\n\n#\u9084\u539fApache\u914d\u7f6e\nsudo rsync -a $BACKUP_DIR\/apache2\/ \/etc\/apache2\/\nsudo rsync -a $BACKUP_DIR\/www\/ \/var\/www\/\n\n#\u91cd\u65b0\u555f\u52d5\u670d\u52d9\nsudo systemctl restart apache2\nsudo systemctl restart mariadb<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><strong>B Linux\u8cc7\u6599\u5099\u4efd\u6210\u529f\u622a\u5716\uff1a<\/strong><\/p>\n\n\n\n<p>\u756b\u976201-user0401\u4f7f\u7528\u8005\u767b\u5165<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"465\" data-src=\"https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/B1-1024x465.png\" alt=\"\" class=\"wp-image-598 lazyload\" data-srcset=\"https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/B1-1024x465.png 1024w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/B1-300x136.png 300w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/B1-768x349.png 768w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/B1.png 1494w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/465;\" \/><\/figure>\n\n\n\n<p>\u756b\u976202-user0402\u4f7f\u7528\u8005\u767b\u5165<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"458\" data-src=\"https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/B2-1024x458.png\" alt=\"\" class=\"wp-image-599 lazyload\" data-srcset=\"https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/B2-1024x458.png 1024w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/B2-300x134.png 300w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/B2-768x343.png 768w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/B2.png 1492w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/458;\" \/><\/figure>\n\n\n\n<p>\u756b\u976203-MariaDB\u8cc7\u6599\u5eab\u9084\u539f\u60c5\u5f62<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"461\" data-src=\"https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/B3-1024x461.png\" alt=\"\" class=\"wp-image-600 lazyload\" data-srcset=\"https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/B3-1024x461.png 1024w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/B3-300x135.png 300w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/B3-768x346.png 768w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/B3.png 1492w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/461;\" \/><\/figure>\n\n\n\n<p>\u756b\u976204-MariaDB\u8cc7\u6599\u5eab\u9084\u539f\u60c5\u5f62<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"464\" data-src=\"https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/B4-1024x464.png\" alt=\"\" class=\"wp-image-601 lazyload\" data-srcset=\"https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/B4-1024x464.png 1024w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/B4-300x136.png 300w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/B4-768x348.png 768w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/B4.png 1495w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/464;\" \/><\/figure>\n\n\n\n<p>\u756b\u976205-Apache\u8cc7\u6599\u5eab\u9084\u539f\u60c5\u5f62<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"390\" data-src=\"https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/B5-1024x390.png\" alt=\"\" class=\"wp-image-602 lazyload\" data-srcset=\"https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/B5-1024x390.png 1024w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/B5-300x114.png 300w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/B5-768x293.png 768w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/B5-1536x586.png 1536w, https:\/\/jonasvip.ddns.net\/wp-content\/uploads\/2024\/04\/B5.png 1768w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/390;\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\u5929\u707d\u4eba\u798d\u96e3\u4ee5\u907f\u514d\uff0c\u7576\u4e3b\u8981\u7684\u4f3a\u670d\u5668\u56e0\u610f\u5916\u6216\u932f\u8aa4\u7121\u6cd5\u904b\u4f5c\uff0c\u5099\u63f4\u7684\u8cc7\u6599\u53ef\u4ee5\u5373\u6642\u63a5\u624b\uff0c\u4f01\u696d\u7684\u670d\u52d9\u548c\u71df\u904b\u5f97\u4ee5\u4e0d\u4e2d\u65b7\u3002<\/p>\n","protected":false},"author":3,"featured_media":593,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[19,21,11],"_links":{"self":[{"href":"https:\/\/jonasvip.ddns.net\/index.php?rest_route=\/wp\/v2\/posts\/592"}],"collection":[{"href":"https:\/\/jonasvip.ddns.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jonasvip.ddns.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jonasvip.ddns.net\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/jonasvip.ddns.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=592"}],"version-history":[{"count":5,"href":"https:\/\/jonasvip.ddns.net\/index.php?rest_route=\/wp\/v2\/posts\/592\/revisions"}],"predecessor-version":[{"id":611,"href":"https:\/\/jonasvip.ddns.net\/index.php?rest_route=\/wp\/v2\/posts\/592\/revisions\/611"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jonasvip.ddns.net\/index.php?rest_route=\/wp\/v2\/media\/593"}],"wp:attachment":[{"href":"https:\/\/jonasvip.ddns.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=592"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jonasvip.ddns.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=592"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jonasvip.ddns.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=592"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}