{"id":23,"date":"2024-09-24T14:33:22","date_gmt":"2024-09-24T06:33:22","guid":{"rendered":"https:\/\/blog.lyx.cool\/?p=23"},"modified":"2024-09-24T14:54:06","modified_gmt":"2024-09-24T06:54:06","slug":"daxue%e7%9a%84%e5%8d%9a%e5%ae%a2%e6%90%ad%e5%bb%ba%e6%97%a5%e8%ae%b0","status":"publish","type":"post","link":"https:\/\/blog.lyx.cool\/?p=23","title":{"rendered":"daxue\u7684\u535a\u5ba2\u642d\u5efa\u65e5\u8bb0"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u603b\u7684\u6765\u8bf4\uff0c\u8fd9\u662f\u4e00\u7bc7\u5199\u7ed9\u672a\u6765\u81ea\u5df1\u7684\u642d\u5efa\u7b14\u8bb0\u3002\u6309\u7167\u9ec4\u59d0\u59d0\u7684\u8bdd\u8bf4\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"265\" height=\"180\" src=\"https:\/\/blog.lyx.cool\/wp-content\/uploads\/2024\/09\/\u5c4f\u5e55\u622a\u56fe-2024-09-24-130109.png\" alt=\"\" class=\"wp-image-24\" style=\"width:186px;height:auto\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u7b28\u86cb\u5f53\u7136\u5f97\u505a\u7b14\u8bb0\uff01<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u670d\u52a1\u5668\u914d\u7f6e<\/strong><\/h3>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\u8df3\u677f\u673a\uff1a       <em>\u64cd\u4f5c\u7cfb\u7edf\uff1aCentOS-7.9.2111-x64 CPU:E5-2650V4 4\u6838 \u5185\u5b58:2G<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5185\u7f51\u670d\u52a1\u5668\uff1a<em>\u64cd\u4f5c\u7cfb\u7edf\uff1aUbuntu 22.04.4  \u5185\u5b58\uff1a4G<\/em><\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">\u81f3\u4e8e\u4e3a\u4f55\u4e0d\u76f4\u63a5\u5728\u8df3\u677f\u673a\u4e0a\u642d\u535a\u5ba2\uff0c\u975e\u5f97\u7ed5\u4e00\u4e2a\u5927\u5708\u5b50\u3002\u56e0\u4e3a\u2014\u2014\u8d2b\u7a77\uff0c\u6211\u5b9e\u5728\u662f\u65e0\u6cd5\u4fe1\u4efb\u516b\u5757\u516b\u6bdb\u516b\u7684\u673a\u5b50\u7684\u7a33\u5b9a\u6027\u554a\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>wordpress\u90e8\u7f72\uff1aphp+nginx+mysql<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">wordpress\u7684\u642d\u5efa\u8fc7\u7a0b\u8fc7\u4e8e\u987a\u5229\uff0c\u5b9e\u8d28\u4e0a\u5e76\u6ca1\u6709\u9047\u5230\u5f88\u5927\u7684\u5751\uff0c\u5370\u8c61\u53cd\u800c\u4e0d\u6df1\u523b\u4e86\u3002\u653e\u4e2a\u53c2\u8003\u94fe\u63a5\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/blog.csdn.net\/qq_36078992\/article\/details\/105595215#:~:text=%E7%BB%BC%E5%90%88%E8%80%83%E8%99%91%E4%B9%8B%E4%B8%8B%EF%BC%8C%E6%9C%80%E7%BB%88%E9%80%89\">\u4ece\u96f6\u642d\u5efaWordPress\u4e2a\u4eba\u7ad9\u70b9 Ubuntu+Nginx+Mysql+PHP_\u4f7f\u7528ubuntu20.4\u7cfb\u7edf\u901a\u8fc7wordpress\u5efa\u7ad9\u8be6\u7ec6\u6559\u7a0b-CSDN\u535a\u5ba2<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>rathole\u5185\u7f51\u7a7f\u900f<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u7531\u4e8e\u6211\u7684\u535a\u5ba2\u662f\u642d\u8f7d\u5728\u5185\u7f51\u73af\u5883\u4e0b\u7684\uff0c\u60f3\u8981\u901a\u8fc7\u5916\u90e8\u8bbf\u95ee\uff0c\u7a7f\u900f\u662f\u96be\u4ee5\u907f\u514d\u7684\uff0c\u9009\u62e9rathole\u53ea\u662f\u56e0\u4e3a\u9ec4\u59d0\u59d0\u538b\u69a8\u6211\u7ed9\uff08\u4ed6\uff09\u6253\u5de5\u7684\u65f6\u5019\u7528\u7684\u4e5f\u662frathole\u7f62\u8fbd~<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5148\u653e\u4e2a\u5b98\u65b9\u94fe\u63a5\u548c\u4e0b\u8f7d\u94fe\u63a5\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/github.com\/rapiz1\/rathole\">rapiz1\/rathole: A lightweight and high-performance reverse proxy for NAT traversal, written in Rust. An alternative to frp and ngrok. (github.com)<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/github.com\/rapiz1\/rathole\/releases\">Releases \u00b7 rapiz1\/rathole (github.com)<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u7ede\u5c3d\u8111\u6c41\u60f3\u4e86\u60f3\u7a7f\u900f\u9047\u5230\u7684\u95ee\u9898\uff0c\u7531\u4e8e\u6218\u7ebf\u62c9\u7684\u592a\u957f\uff0c\u73b0\u5728\u5df2\u7ecf\u4e0d\u751a\u6e05\u695a\u4e86\u3002\u5370\u8c61\u6700\u6df1\u523b\u5e94\u8be5\u662f\u5728\u8df3\u677f\u673a\u4e0a\u642ddocker\uff08\u56e0\u4e3acentos\u6ca1\u6cd5\u76f4\u63a5\u7528rathole\uff09\uff0c\u4ee5\u53caUbuntu\u7cfb\u7edf\u8981\u65b0\u7248\u672c\u624d\u80fd\u7528rathole\u505a\u7a7f\u900f\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5728\u8df3\u677f\u673a\u4e0a\u7684\u4fee\u6539server.toml\u914d\u7f6e\u540e\u7684\u547d\u4ee4\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>docker ps\ndocker restart ID<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u5728\u5185\u7f51\u670d\u52a1\u5668\u4e0a\u4fee\u6539client.toml\u914d\u7f6e\u540e\u7684\u547d\u4ee4\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>.\/rathole client.toml\nsudo systemctl status rathole<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u5173\u4e8ewordpress\u7684\u4e00\u7cfb\u5217\u5927\u5751<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u8fd9\u771f\u662f\u4e00\u7bc7\u8840\u6cea\u53f2\uff01\uff01\uff01<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u7531\u4e8e\u662f\u7b2c\u4e00\u6b21\u642d\u535a\u5ba2\uff0c\u628a\u535a\u5ba2\u642d\u8d77\u6765\u4e4b\u540e\u8fc7\u4e8e\u6fc0\u52a8\uff0cdaxue\u5e76\u6ca1\u6709\u6ce8\u610f\u5230\u662f\u901a\u8fc7\u5185\u7f51\u73af\u5883\u6253\u5f00\u7684\uff0c\u5c31\u76f4\u63a5\u5174\u51b2\u51b2\u5199\u4e86\u4eba\u751f\u7684\u7b2c\u4e00\u7bc7blog\uff0c\u53d1\u7ed9\u5c0f\u4f19\u4f34\u4eec\u6b23\u8d4f\u7684\u65f6\u5019\u624d\u53d1\u73b0\u9664\u4e86\u81ea\u5df1\u8c01\u4e5f\u6253\u4e0d\u5f00\u3002\u603b\u7684\u6765\u8bf4\uff0c\u4e0b\u9762\u8fd9\u73a9\u610f\u513f\u5168\u8d23\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"297\" height=\"124\" src=\"https:\/\/blog.lyx.cool\/wp-content\/uploads\/2024\/09\/image-5.png\" alt=\"\" class=\"wp-image-25\" style=\"width:223px;height:auto\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u5927\u96ea\u7684\u7b2c\u4e00\u4ef6\u4e8b\uff0c\u5c31\u662f\u6539\u5730\u5740\u3002\u7531\u4e8e\u6211\u7a7f\u900f\u4f7f\u7528\u4e8680\u7aef\u53e3\uff0c\u6ca1\u6709\u7ecf\u9a8c\u7684\u5927\u96ea\uff0c\u5c31\u76f4\u63a5\u628a\u7f51\u5740\u6539\u6210\u4e86\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"727\" height=\"166\" src=\"https:\/\/blog.lyx.cool\/wp-content\/uploads\/2024\/09\/a6b871cf9b0fa668c44276925ba29eea.png\" alt=\"\" class=\"wp-image-26\" style=\"width:228px;height:auto\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u7136\u540e\u5185\u7f51\u4e5f\u6253\u4e0d\u5f00\u535a\u5ba2\u4e86\u3002\u539f\u56e0\uff1a<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\u6d4f\u89c8\u5668\u8bbf\u95ee\u4f1a\u5403\u6389 :80\uff0c\u4f46 WordPress \u4f1a\u671f\u671b host \u5e26\u7740 :80\uff0c\u5c31\u4e00\u76f4\u91cd\u5b9a\u5411\u3002<\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">\u8fd9\u5c31\u5f97\u53bb\u6570\u636e\u5e93\u4e2d\u6539\u7f51\u5740\u4e86\uff08\u771f\u7684\u662f\u6ca1\u6709\u96be\u5ea6\u4e5f\u8981\u521b\u9020\u96be\u5ea6\uff0c\u786c\u751f\u751f\u8ba9\u6211\u6361\u8d77\u4e86\u9057\u5fd8\u591a\u5e74\u7684MySQL\u77e5\u8bc6\uff09\u3002\u653e\u4e00\u4e0b\u547d\u4ee4\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql -u wordpressuser -p\nuse wordpress;\n\nselect * from wp_options where option_name=\"home\" or  option_name=\"siteurl\";\n\nupdate wp_options set option_value  = replace(option_value  ,\"https:\/\/blog.lyx.cool:80\",\"https:\/\/blog.lyx.cool\");\n\n<em><strong>\uff01\uff01\uff01\u7f51\u5740\u4e0d\u80fd\u6709\u7a7a\u683c\uff01\uff01\uff01\u7f51\u5740\u4e0d\u80fd\u6709\u7a7a\u683c\uff01\uff01\uff01\u7f51\u5740\u4e0d\u80fd\u6709\u7a7a\u683c\uff01\uff01\uff01<\/strong>\n\u91cd\u8981\u7684\u4e8b\u60c5\u8bf4\u4e09\u904d\nwordpress\u4e00\u76f4\u62a5\u9519\uff0c\u4e00\u4e2a\u7a7a\u683c\u6298\u78e8\u4e86\u6211\u4e00\u665a\u4e0a\u3002<\/em><\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u81f3\u6b64\uff0c\u6211\u53d1\u73b0wordpress\u767b\u5f55\u4e0d\u8fdb\u53bb\u4e86\uff0c\u6211\u53c8\u628a\u5bc6\u7801\u6539\u4e86\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>UPDATE wp_users SET user_pass = ******* WHERE ID = 1;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e4b\u540e\u535a\u5ba2\u5c31\u80fd\u6253\u5f00\u4e86\uff0c\u4f46\u662f\uff01\u535a\u5ba2\u5185\u5bb9\u91cc\u9762\u7684\u56fe\u7247\u770b\u4e0d\u89c1\uff0c\u63a5\u7740\u53bb\u6539\u56fe\u7247\u7f51\u5740\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>update wp_posts set post_content =replace(post_content,\"https:\/\/blog.lyx.cool\uff1a80\",\"https:\/\/blog.lyx.cool\");<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u8fd9\u771f\u662f\u4e00\u4e2a\u7f8e\u4e3d\u7684\u5957\u5a03\u8fc7\u7a0b~<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>\u4ecehttp\u5230https\u7684\u8de8\u8d8a<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u60f3\u8981\u5b9e\u73b0\u5b89\u5168\u7684\u8bbf\u95ee\uff0c\u5f53\u7136\u5f97\u7b7eCA\u8bc1\u4e66\u5566~<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u653e\u4e2a\u53c2\u8003\u94fe\u63a5\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/github.com\/acmesh-official\/acme.sh\">acmesh-official\/acme.sh: A pure Unix shell script implementing ACME client protocol (github.com)<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u53c2\u8003\u6559\u7a0b\u8bf4\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"432\" src=\"https:\/\/blog.lyx.cool\/wp-content\/uploads\/2024\/09\/image-7.png\" alt=\"\" class=\"wp-image-28\" style=\"width:197px;height:auto\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u8bf7\u5728root\u7528\u6237\u4e0b\u5b89\u88c5acme.sh\u3002<\/strong>\u4e0d\u7136\u5c31\u4f1a\u8e29\u5f88\u591a\u5f88\u591a\u5f88\u591a\u7684\u5751\uff0c\u65e0\u6570\u7684\u6743\u9650\u95ee\u9898\u5728\u540e\u9762\u7b49\u7740\uff08\u4e5f\u53ef\u80fd\u662f\u6211\u5b66\u827a\u4e0d\u7cbe\uff0c\u603b\u4e4b\u5728\u666e\u901a\u7528\u6237\u4e0b\u9762\u6211\u6ca1\u642d\u8d77\uff09<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u628aca\u670d\u52a1\u5668\u6539\u6210letsencrypt\uff0c\u8fd9\u4e2a\u66f4\u597d\u7528\uff01<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>acme.sh --set-default-ca --server letsencrypt<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u751f\u6210\u8bc1\u4e66\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>acme.sh --issue -d blog.lyx.cool --webroot \/var\/www\/html<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u5b89\u88c5\u8bc1\u4e66\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>cd  \/etc\/nginx\n\nacme.sh --install-cert -d blog.lyx.cool \\\n--key-file       \/etc\/nginx\/key.pem  \\\n--fullchain-file \/etc\/nginx\/cert.pem \\\n--reloadcmd     \"service nginx force-reload\"<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u5173\u4e8eNginx \u7684\u914d\u7f6e\uff0c\u53c2\u8003\u94fe\u63a5\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/help.aliyun.com\/zh\/ssl-certificate\/user-guide\/install-ssl-certificates-on-nginx-servers-or-tengine-servers\">https:\/\/help.aliyun.com\/zh\/ssl-certificate\/user-guide\/install-ssl-certificates-on-nginx-servers-or-tengine-servers<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u518d\u653e\u4e00\u4e0b\u6211\u7684\u914d\u7f6e\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>cd \/etc\/nginx\/sites-enabled\n\nnginx\u4fee\u6539\u7684\uff08\u5728\u540c\u4e00\u4e2aserver\u5757\u4e2d\uff09\uff1a\n listen 443 ssl\uff1b\n server_name blog.lyx.cool;\n ssl_certificate \/etc\/nginx\/cert.pem;\n ssl_certificate_key \/etc\/nginx\/key.pem;\n if ($scheme = http) {\n      return 301 https:\/\/$server_name$request_uri;\n }<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u518d\u5bf9nginx\u8fdb\u884c\u72b6\u6001\u68c0\u6d4b\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo nginx -t\nsudo nginx -s reload<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u68c0\u67e5\u8fde\u901a\u6027\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo curl -v https:\/\/localhost:443<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u63a5\u7740\uff0c\u5728mysql\u4e2d\uff0c\u628a\u7b2c\u4e00\u7bc7\u535a\u5ba2\u5185\u5bb9\u91cc\u9762\u7684<em>https:\/\/blog.lyx.cool<\/em>\u5168\u90e8\u6539\u4e3a<em>https:\/\/blog.lyx.cool<\/em>\uff0c\u63a5\u7740\u5728rathole\u4e2d\u5c06https\u914d\u7f6e\u5b8c\u6210\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u81f3\u6b64\uff0cdaxue\u7684\u535a\u5ba2\u642d\u5efa\u5706\u6ee1\u7ed3\u675f\uff01\u6492\u82b1~~~<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u9ec4\u59d0\u59d0\u82e6\u53e3\u5a46\u5fc3\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"285\" height=\"72\" src=\"https:\/\/blog.lyx.cool\/wp-content\/uploads\/2024\/09\/image-8.png\" alt=\"\" class=\"wp-image-29\" style=\"width:202px;height:auto\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u5927\u96ea\u7684\u7b2c\u4e8c\u7bc7\u535a\u5ba2\u987a\u5229\u51fa\u7089~~~~<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u603b\u7684\u6765\u8bf4\uff0c\u8fd9\u662f\u4e00\u7bc7\u5199\u7ed9\u672a\u6765\u81ea\u5df1\u7684\u642d\u5efa\u7b14\u8bb0\u3002\u6309\u7167\u9ec4\u59d0\u59d0\u7684\u8bdd\u8bf4\uff1a \u7b28\u86cb\u5f53\u7136\u5f97\u505a\u7b14\u8bb0\uff01 \u670d\u52a1\u5668\u914d\u7f6e \u8df3\u677f\u673a\uff1a \u64cd\u4f5c\u7cfb [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-23","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/blog.lyx.cool\/index.php?rest_route=\/wp\/v2\/posts\/23","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.lyx.cool\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.lyx.cool\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.lyx.cool\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.lyx.cool\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=23"}],"version-history":[{"count":4,"href":"https:\/\/blog.lyx.cool\/index.php?rest_route=\/wp\/v2\/posts\/23\/revisions"}],"predecessor-version":[{"id":35,"href":"https:\/\/blog.lyx.cool\/index.php?rest_route=\/wp\/v2\/posts\/23\/revisions\/35"}],"wp:attachment":[{"href":"https:\/\/blog.lyx.cool\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=23"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.lyx.cool\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=23"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.lyx.cool\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=23"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}