{"id":28745,"date":"2023-02-22T17:44:23","date_gmt":"2023-02-21T07:22:34","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8-centos-7-%e4%b8%8a%e5%ae%89%e8%a3%85-apache-%e5%92%8c-mariadb-10-2%ef%bc%8c%e5%b9%b6%e8%bf%9b%e8%a1%8c-sftp-%e8%bf%9e%e6%8e%a5%e3%80%82\/"},"modified":"2025-08-12T09:53:41","modified_gmt":"2025-08-12T01:53:41","slug":"%e5%9c%a8-centos-7-%e4%b8%8a%e5%ae%89%e8%a3%85-apache-%e5%92%8c-mariadb-10-2%ef%bc%8c%e5%b9%b6%e8%bf%9b%e8%a1%8c-sftp-%e8%bf%9e%e6%8e%a5%e3%80%82","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8-centos-7-%e4%b8%8a%e5%ae%89%e8%a3%85-apache-%e5%92%8c-mariadb-10-2%ef%bc%8c%e5%b9%b6%e8%bf%9b%e8%a1%8c-sftp-%e8%bf%9e%e6%8e%a5%e3%80%82\/","title":{"rendered":"\u5728 CentOS 7 \u4e0a\u5b89\u88c5 Apache \u548c MariaDB 10.2\uff0c\u5e76\u8fdb\u884c SFTP \u8fde\u63a5"},"content":{"rendered":"<h1>\u5f15\u5165\u56e0\u4e3a\u91cd\u65b0\u5b89\u88c5\u6a31\u82b1VPS\u7684\u64cd\u4f5c\u7cfb\u7edf\u5347\u7ea7\u5230\u4e86CentOS 7\uff0c\u82b1\u8d39\u4e86\u5f88\u591a\u65f6\u95f4\u548c\u7cbe\u529b\uff0c\u6240\u4ee5\u6211\u628a\u8fd9\u4e2a\u8fc7\u7a0b\u4f5c\u4e3a\u5907\u5fd8\u5f55\u7559\u4e0b\u6765\u3002<\/p>\n<p>\u5047\u8bbe\u5df2\u7ecf\u4f7f\u7528OpenSSH\uff0c\u4ee5\u4e0b\u63cf\u8ff0\u3002\u5ba2\u6237\u7aef\u5728Windows 7\u4e0a\u4f7f\u7528FileZilla Client\u3002\u6b64\u5916\uff0c\u5728\u521b\u5efa\u5bc6\u94a5\u65f6\u4f7f\u7528\u4e86Tera Term\u3002<\/p>\n<h1>\u963f\u5e15\u5947<\/p>\n<h2>\u5b89\u88c5\u5728CentOS\u5b98\u65b9\u7684yum\u4ed3\u5e93\u4e2d\u63d0\u4f9b\u4e86Apache 2.4\u7684RPM\u8f6f\u4ef6\u5305\uff0c\u56e0\u6b64\u6211\u4eec\u5c06\u8fdb\u884c\u5b89\u88c5\u3002<br \/>\n\u5bf9\u4e8e\u6a31\u82b1VPS\u6765\u8bf4\uff0cApache\u5df2\u7ecf\u88ab\u5b89\u88c5\uff0c\u4f46\u8fd8\u9700\u8981\u8fdb\u884c\u542f\u7528\u548c\u542f\u52a8\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"c\"># Apache\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/span>\r\n<span class=\"nb\">sudo <\/span>yum <span class=\"nb\">install <\/span>httpd\r\n\r\n<span class=\"c\"># httpd.service \u306e\u6709\u52b9\u5316 (OS\u8d77\u52d5\u6642\u306b\u81ea\u52d5\u7684\u306b\u8d77\u52d5)<\/span>\r\n<span class=\"nb\">sudo <\/span>systemctl <span class=\"nb\">enable <\/span>httpd\r\n\r\n<span class=\"c\"># \u8d77\u52d5<\/span>\r\n<span class=\"nb\">sudo <\/span>systemctl start httpd\r\n<\/code><\/pre>\n<p>\u6211\u5c06\u6839\u636e\u4ee5\u4e0b\u6587\u7ae0\u53c2\u8003\u6765\u8fdb\u884cApache\u7684\u8bbe\u7f6e\u3002<\/p>\n<ul class=\"post-ul\">\n<li style=\"list-style-type: none;\">\n<ul class=\"post-ul\">Apache \u306b\u95a2\u3059\u308b SELinux \u306e\u8a2d\u5b9a &#8211; Qiita<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ul class=\"post-ul\">Apache 2.4 \u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u306e\u8a18\u8ff0\u4f8b &#8211; Qiita<\/ul>\n<h2>\u9632\u706b\u5899\u8bbe\u7f6e<\/p>\n<pre class=\"post-pre\"><code><span class=\"c\">#\u3010mod_ssl\u3092\u5229\u7528\u3057\u3066\u3044\u306a\u3044\u5834\u5408\u3011TCP\u306e80\u756a\u30dd\u30fc\u30c8\u306e\u901a\u4fe1\u3092\u8a31\u53ef<\/span>\r\n<span class=\"nb\">sudo <\/span>firewall-cmd <span class=\"nt\">--permanent<\/span> <span class=\"nt\">--add-service<\/span><span class=\"o\">=<\/span>http\r\n\r\n<span class=\"c\">#\u3010mod_ssl\u3092\u5229\u7528\u3057\u3066\u3044\u308b\u5834\u5408\u3011TCP\u306e80\u756a\u30dd\u30fc\u30c8\u3068443\u756a\u30dd\u30fc\u30c8\u306e\u901a\u4fe1\u3092\u8a31\u53ef<\/span>\r\n<span class=\"nb\">sudo <\/span>firewall-cmd <span class=\"nt\">--permanent<\/span> <span class=\"nt\">--add-service<\/span><span class=\"o\">=<\/span>http <span class=\"nt\">--add-service<\/span><span class=\"o\">=<\/span>https\r\n\r\n<span class=\"c\"># firewalld \u306e\u8a2d\u5b9a\u3092\u518d\u8aad\u307f\u8fbc\u307f<\/span>\r\n<span class=\"nb\">sudo <\/span>firewall-cmd <span class=\"nt\">--reload<\/span>\r\n<\/code><\/pre>\n<p>\u5982\u679c\u4f60\u6b63\u5728\u4f7f\u7528\u975e\u9ed8\u8ba4\u7aef\u53e3\uff0c\u6211\u4eec\u5c06\u6309\u7167\u4ee5\u4e0b\u65b9\u5f0f\u8fdb\u884c\u5141\u8bb8\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"c\"># (\u4f8b) TCP\u306e49152\u756a\u30dd\u30fc\u30c8\u306e\u901a\u4fe1\u3092\u8a31\u53ef<\/span>\r\n<span class=\"nb\">sudo <\/span>firewall-cmd <span class=\"nt\">--permanent<\/span> <span class=\"nt\">--add-port<\/span><span class=\"o\">=<\/span>49152\/tcp\r\n<\/code><\/pre>\n<h1>\u5bf9Apache\u7684\u64cd\u4f5c<\/p>\n<div>\n<div class=\"post-table\">\u30b3\u30de\u30f3\u30c9\u52b9\u679c<code>httpd -v<\/code>\u30d0\u30fc\u30b8\u30e7\u30f3\u3092\u8868\u793a\u3057\u307e\u3059\u3002<code>sudo -u apache apachectl configtest<\/code>\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u306b\u6587\u6cd5\u30df\u30b9\u304c\u7121\u3044\u304b\u78ba\u8a8d\u3057\u307e\u3059\u3002<code>sudo systemctl start httpd<\/code>\u30b5\u30fc\u30d3\u30b9\u3092\u958b\u59cb\u3057\u307e\u3059\u3002<code>sudo httpd -k stop<\/code>\u30b5\u30fc\u30d3\u30b9\u3092<a title=\"\u6025\u306a\u505c\u6b62 | Apache HTTP Server \u306e\u505c\u6b62\u3068\u518d\u8d77\u52d5 - Apache HTTP \u30b5\u30fc\u30d0 \u30d0\u30fc\u30b8\u30e7\u30f3 2.4\" href=\"https:\/\/httpd.apache.org\/docs\/current\/stopping.html#term\" target=\"_blank\" rel=\"nofollow noopener\">\u505c\u6b62<\/a>\u3057\u307e\u3059\u3002<sup id=\"fnref1\"><a title=\"\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u3068\u901a\u4fe1\u4e2d\u306e\u5834\u5408\u306f\u5f37\u5236\u7684\u306b\u5207\u65ad\u3057\u307e\u3059\u3002\" href=\"#fn1\">1<\/a><\/sup> <sup id=\"fnref2\"><a title=\"systemctl \u30b3\u30de\u30f3\u30c9\u3092\u4ecb\u3057\u3066\u3044\u306a\u3044\u305f\u3081\u3001systemctl status httpd \u3067\u30b9\u30c6\u30fc\u30bf\u30b9\u3092\u8868\u793a\u3057\u305f\u969b\u3001Active \u6b04\u306b failed (Result: exit-code) \u3068\u8868\u793a\u3055\u308c\u307e\u3059\u3002\" href=\"#fn2\">2<\/a><\/sup><code>sudo systemctl stop httpd<\/code>\u30b5\u30fc\u30d3\u30b9\u3092<a title=\"\u7de9\u3084\u304b\u306a\u505c\u6b62 | Apache HTTP Server \u306e\u505c\u6b62\u3068\u518d\u8d77\u52d5 - Apache HTTP \u30b5\u30fc\u30d0 \u30d0\u30fc\u30b8\u30e7\u30f3 2.4\" href=\"https:\/\/httpd.apache.org\/docs\/current\/stopping.html#graceful\" target=\"_blank\" rel=\"nofollow noopener\">\u7de9\u3084\u304b\u306b\u505c\u6b62<\/a>\u3057\u307e\u3059\u3002<sup id=\"fnref3\"><a title=\"\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u3068\u901a\u4fe1\u4e2d\u306e\u5b50\u30d7\u30ed\u30bb\u30b9\u3092\u5f37\u5236\u7d42\u4e86\u305b\u305a\u3001\u901a\u4fe1\u304c\u7d42\u308f\u3063\u305f\u30d7\u30ed\u30bb\u30b9\u304b\u3089\u9806\u306b\u505c\u6b62\u3057\u307e\u3059\u3002\" href=\"#fn3\">3<\/a><\/sup><code>sudo httpd -k restart<\/code>\u30b5\u30fc\u30d3\u30b9\u3092<a title=\"\u6025\u306a\u518d\u8d77\u52d5 | Apache HTTP Server \u306e\u505c\u6b62\u3068\u518d\u8d77\u52d5 - Apache HTTP \u30b5\u30fc\u30d0 \u30d0\u30fc\u30b8\u30e7\u30f3 2.4\" href=\"https:\/\/httpd.apache.org\/docs\/current\/stopping.html#hup\" target=\"_blank\" rel=\"nofollow noopener\">\u518d\u8d77\u52d5<\/a>\u3057\u307e\u3059\u3002<sup id=\"fnref1\"><a title=\"\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u3068\u901a\u4fe1\u4e2d\u306e\u5834\u5408\u306f\u5f37\u5236\u7684\u306b\u5207\u65ad\u3057\u307e\u3059\u3002\" href=\"#fn1\">1<\/a><\/sup><code>sudo service httpd reload<\/code>\u30b5\u30fc\u30d3\u30b9\u3092<a title=\"\u7de9\u3084\u304b\u306a\u518d\u8d77\u52d5 | Apache HTTP Server \u306e\u505c\u6b62\u3068\u518d\u8d77\u52d5 - Apache HTTP \u30b5\u30fc\u30d0 \u30d0\u30fc\u30b8\u30e7\u30f3 2.4\" href=\"https:\/\/httpd.apache.org\/docs\/current\/stopping.html#graceful\" target=\"_blank\" rel=\"nofollow noopener\">\u7de9\u3084\u304b\u306b\u518d\u8d77\u52d5<\/a>\u3057\u307e\u3059\u3002<sup id=\"fnref4\"><a title=\"\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u3068\u901a\u4fe1\u4e2d\u306e\u5b50\u30d7\u30ed\u30bb\u30b9\u3092\u5f37\u5236\u7d42\u4e86\u305b\u305a\u3001\u901a\u4fe1\u304c\u7d42\u308f\u3063\u305f\u30d7\u30ed\u30bb\u30b9\u304b\u3089\u9806\u306b\u65b0\u3057\u3044\u30d7\u30ed\u30bb\u30b9\u306b\u7f6e\u304d\u63db\u3048\u3066\u3044\u304d\u307e\u3059\u3002\" href=\"#fn4\">4<\/a><\/sup><code>sudo httpd -k stop; sleep 1s; sudo systemctl start httpd<\/code>\u30b5\u30fc\u30d3\u30b9\u3092\u89aa\u30d7\u30ed\u30bb\u30b9\u3082\u542b\u3081\u3066\u5b8c\u5168\u306b\u518d\u8d77\u52d5\u3057\u307e\u3059\u3002<sup id=\"fnref1\"><a title=\"\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u3068\u901a\u4fe1\u4e2d\u306e\u5834\u5408\u306f\u5f37\u5236\u7684\u306b\u5207\u65ad\u3057\u307e\u3059\u3002\" href=\"#fn1\">1<\/a><\/sup><code>sudo systemctl restart httpd<\/code>\u30b5\u30fc\u30d3\u30b9\u304c<a title=\"\u7de9\u3084\u304b\u306a\u505c\u6b62 | Apache HTTP Server \u306e\u505c\u6b62\u3068\u518d\u8d77\u52d5 - Apache HTTP \u30b5\u30fc\u30d0 \u30d0\u30fc\u30b8\u30e7\u30f3 2.4\" href=\"https:\/\/httpd.apache.org\/docs\/current\/stopping.html#graceful\" target=\"_blank\" rel=\"nofollow noopener\">\u7de9\u3084\u304b\u306b\u505c\u6b62<\/a>\u3059\u308b\u306e\u3092\u5f85\u6a5f\u3057\u305f\u5f8c\u3067\u518d\u8d77\u52d5\u3057\u307e\u3059\u3002<code>sudo tail \/var\/log\/httpd\/error_log<\/code><code>tail<\/code> \u30b3\u30de\u30f3\u30c9\u3067\u30a8\u30e9\u30fc\u30ed\u30b0\u306e\u672b\u5c3e10\u884c\u3092\u8868\u793a\u3057\u307e\u3059\u3002<sup id=\"fnref5\"><a title=\"\u4e00\u822c\u30e6\u30fc\u30b6\u30fc\u306b\u306f \/var\/log\/httpd \u4ee5\u4e0b\u306e\u8aad\u307f\u8fbc\u307f\u6a29\u9650\u304c\u4e0e\u3048\u3089\u308c\u3066\u3044\u306a\u3044\u305f\u3081\u3001\u30a8\u30e9\u30fc\u30ed\u30b0\u3084\u30a2\u30af\u30bb\u30b9\u30ed\u30b0\u306e\u8aad\u307f\u53d6\u308a\u306b\u306f root \u6a29\u9650\u304c\u5fc5\u8981\u3067\u3059\u3002\" href=\"#fn5\">5<\/a><\/sup><code>sudo tail \/var\/log\/httpd\/access_log<\/code><code>tail<\/code> \u30b3\u30de\u30f3\u30c9\u3067\u30a2\u30af\u30bb\u30b9\u30ed\u30b0\u306e\u672b\u5c3e10\u884c\u3092\u8868\u793a\u3057\u307e\u3059\u3002<sup id=\"fnref5\"><a title=\"\u4e00\u822c\u30e6\u30fc\u30b6\u30fc\u306b\u306f \/var\/log\/httpd \u4ee5\u4e0b\u306e\u8aad\u307f\u8fbc\u307f\u6a29\u9650\u304c\u4e0e\u3048\u3089\u308c\u3066\u3044\u306a\u3044\u305f\u3081\u3001\u30a8\u30e9\u30fc\u30ed\u30b0\u3084\u30a2\u30af\u30bb\u30b9\u30ed\u30b0\u306e\u8aad\u307f\u53d6\u308a\u306b\u306f root \u6a29\u9650\u304c\u5fc5\u8981\u3067\u3059\u3002\" href=\"#fn5\">5<\/a><\/sup> <sup id=\"fnref6\"><a title=\"\u521d\u671f\u8a2d\u5b9a\u3067\u306fTLS\u63a5\u7d9a\u306e\u30a2\u30af\u30bb\u30b9\u30ed\u30b0\u3092 \/var\/log\/httpd\/ssl_access_log \u306b\u8a18\u9332\u3059\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u308b\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002\" href=\"#fn6\">6<\/a><\/sup><\/p>\n<h1>MariaDB \u662f\u4e00\u500b\u958b\u6e90\u7684\u95dc\u806f\u5f0f\u8cc7\u6599\u5eab\u7ba1\u7406\u7cfb\u7d71\u3002<\/p>\n<h2>*.repo \u6587\u4ef6\u7684\u8bed\u6cd5\u9ad8\u4eae\u5728CentOS\u7684\u6807\u51c6yum\u8f6f\u4ef6\u6e90\u4e2d\u63d0\u4f9b\u7684\u9664\u4e86Vim\u4e4b\u5916\u7684\u6587\u672c\u7f16\u8f91\u5668\uff0c\u5728\u521d\u59cb\u72b6\u6001\u4e0b\u65e0\u6cd5\u5b9e\u73b0\u4ed3\u5e93\u5b9a\u4e49\u6587\u4ef6\u7684\u8bed\u6cd5\u9ad8\u4eae\u529f\u80fd\u3002\u9700\u8981\u8fdb\u884c\u4e00\u4e9b\u8bbe\u7f6e\u6587\u4ef6\u7684\u7f16\u8f91\u7b49\u64cd\u4f5c\uff0c\u4ee5\u542f\u7528\u8bed\u6cd5\u9ad8\u4eae\u529f\u80fd\u3002<\/p>\n<h3>GNU Emacs\u662f\u4e00\u6b3e\u529f\u80fd\u5f3a\u5927\u7684\u6587\u672c\u7f16\u8f91\u5668\u548c\u5f00\u53d1\u73af\u5883\u3002\u521b\u5efa\uff08\u6216\u8ffd\u52a0\uff09\u4e2a\u4eba\u8bbe\u5b9a\u6587\u4ef6\uff0c\u5e76\u6dfb\u52a0\u4e00\u4e2a\u8bbe\u7f6e\uff0c\u4f7f\u4ee5.repo\u4e3a\u540e\u7f00\u7684\u6587\u4ef6\u5728conf-mode\u4e0b\u6253\u5f00\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"c1\">;; .repo \u30d5\u30a1\u30a4\u30eb\u3092 Conf \u30e2\u30fc\u30c9\u3067\u958b\u304f<\/span>\r\n<span class=\"p\">(<\/span><span class=\"nv\">add-to-list<\/span> <span class=\"ss\">'auto-mode-alist<\/span> <span class=\"o\">'<\/span><span class=\"p\">(<\/span><span class=\"s\">\"\\\\.repo$\"<\/span> <span class=\"o\">.<\/span> <span class=\"nv\">conf-mode<\/span><span class=\"p\">))<\/span>\r\n<\/code><\/pre>\n<h3>\u6587\u672c\u7f16\u8f91\u5668<br \/>\n\u5c06\u4ee5.repo\u7ed3\u5c3e\u7684\u6587\u4ef6\u4f5c\u4e3aINI\u6587\u4ef6\u6253\u5f00\uff0c\u5e76\u5728\u6bcf\u884c\u6ce8\u91ca\u7684\u8d77\u59cb\u5904\u6dfb\u52a0 # \u7b26\u53f7\u3002<\/p>\n<pre class=\"post-pre\"><code>                    <span class=\"c\">&lt;!--##############\r\n                        ## \u4ee5\u4e0a\u7701\u7565 ##\r\n                        ##############--&gt;<\/span>\r\n\r\n  <span class=\"nt\">&lt;metadata&gt;<\/span>\r\n    <span class=\"nt\">&lt;property<\/span> <span class=\"na\">name=<\/span><span class=\"s\">\"mimetypes\"<\/span><span class=\"nt\">&gt;<\/span>text\/x-ini-file;application\/x-ini-file<span class=\"nt\">&lt;\/property&gt;<\/span>\r\n    <span class=\"nt\">&lt;property<\/span> <span class=\"na\">name=<\/span><span class=\"s\">\"globs\"<\/span><span class=\"nt\">&gt;<\/span>*.ini;*.repo<span class=\"nt\">&lt;\/property&gt;<\/span><span class=\"c\">&lt;!--## *.repo \u3092\u8ffd\u52a0 ##--&gt;<\/span>\r\n    <span class=\"nt\">&lt;property<\/span> <span class=\"na\">name=<\/span><span class=\"s\">\"line-comment-start\"<\/span><span class=\"nt\">&gt;<\/span>;<span class=\"nt\">&lt;\/property&gt;<\/span>\r\n  <span class=\"nt\">&lt;\/metadata&gt;<\/span>\r\n\r\n                    <span class=\"c\">&lt;!--##############\r\n                        ##   \u4e2d\u7565   ##\r\n                        ##############--&gt;<\/span>\r\n\r\n  <span class=\"nt\">&lt;definitions&gt;<\/span>\r\n    <span class=\"nt\">&lt;context<\/span> <span class=\"na\">id=<\/span><span class=\"s\">\"line-comment\"<\/span> <span class=\"na\">style-ref=<\/span><span class=\"s\">\"comment\"<\/span> <span class=\"na\">end-at-line-end=<\/span><span class=\"s\">\"true\"<\/span><span class=\"nt\">&gt;<\/span>\r\n      <span class=\"nt\">&lt;start&gt;<\/span>;<span class=\"nt\">&lt;\/start&gt;<\/span>\r\n    <span class=\"nt\">&lt;\/context&gt;<\/span>\r\n    <span class=\"c\">&lt;!--## \u3053\u3053\u304b\u3089 ##--&gt;<\/span>\r\n    <span class=\"nt\">&lt;context<\/span> <span class=\"na\">id=<\/span><span class=\"s\">\"bash-line-comment\"<\/span> <span class=\"na\">style-ref=<\/span><span class=\"s\">\"comment\"<\/span> <span class=\"na\">end-at-line-end=<\/span><span class=\"s\">\"true\"<\/span><span class=\"nt\">&gt;<\/span>\r\n      <span class=\"nt\">&lt;start&gt;<\/span>#<span class=\"nt\">&lt;\/start&gt;<\/span>\r\n    <span class=\"nt\">&lt;\/context&gt;<\/span><span class=\"c\">&lt;!--## \u3053\u3053\u307e\u3067 ##--&gt;<\/span>\r\n    <span class=\"nt\">&lt;context<\/span> <span class=\"na\">id=<\/span><span class=\"s\">\"group\"<\/span> <span class=\"na\">style-ref=<\/span><span class=\"s\">\"keyword\"<\/span><span class=\"nt\">&gt;<\/span>\r\n      <span class=\"nt\">&lt;start&gt;<\/span>^\\[<span class=\"nt\">&lt;\/start&gt;<\/span>\r\n      <span class=\"nt\">&lt;end&gt;<\/span>\\]$<span class=\"nt\">&lt;\/end&gt;<\/span>\r\n    <span class=\"nt\">&lt;\/context&gt;<\/span>\r\n\r\n                    <span class=\"c\">&lt;!--##############\r\n                        ##   \u4e2d\u7565   ##\r\n                        ##############--&gt;<\/span>\r\n\r\n    <span class=\"nt\">&lt;context<\/span> <span class=\"na\">id=<\/span><span class=\"s\">\"ini\"<\/span><span class=\"nt\">&gt;<\/span>\r\n      <span class=\"nt\">&lt;include&gt;<\/span>\r\n        <span class=\"nt\">&lt;context<\/span> <span class=\"na\">ref=<\/span><span class=\"s\">\"line-comment\"<\/span><span class=\"nt\">\/&gt;<\/span>\r\n        <span class=\"nt\">&lt;context<\/span> <span class=\"na\">ref=<\/span><span class=\"s\">\"bash-line-comment\"<\/span><span class=\"nt\">\/&gt;<\/span><span class=\"c\">&lt;!--## \u8ffd\u52a0 ##--&gt;<\/span>\r\n        <span class=\"nt\">&lt;context<\/span> <span class=\"na\">ref=<\/span><span class=\"s\">\"group\"<\/span><span class=\"nt\">\/&gt;<\/span>\r\n        <span class=\"nt\">&lt;context<\/span> <span class=\"na\">ref=<\/span><span class=\"s\">\"non-standard-key\"<\/span><span class=\"nt\">\/&gt;<\/span>\r\n        <span class=\"nt\">&lt;context<\/span> <span class=\"na\">ref=<\/span><span class=\"s\">\"language\"<\/span><span class=\"nt\">\/&gt;<\/span>\r\n        <span class=\"nt\">&lt;context<\/span> <span class=\"na\">ref=<\/span><span class=\"s\">\"variable\"<\/span><span class=\"nt\">\/&gt;<\/span>\r\n        <span class=\"nt\">&lt;context<\/span> <span class=\"na\">ref=<\/span><span class=\"s\">\"boolean-value\"<\/span><span class=\"nt\">\/&gt;<\/span>\r\n        <span class=\"nt\">&lt;context<\/span> <span class=\"na\">ref=<\/span><span class=\"s\">\"single-quoted-string\"<\/span><span class=\"nt\">\/&gt;<\/span>\r\n        <span class=\"nt\">&lt;context<\/span> <span class=\"na\">ref=<\/span><span class=\"s\">\"double-quoted-string\"<\/span><span class=\"nt\">\/&gt;<\/span>\r\n        <span class=\"nt\">&lt;context<\/span> <span class=\"na\">ref=<\/span><span class=\"s\">\"decimal-number\"<\/span><span class=\"nt\">\/&gt;<\/span>\r\n        <span class=\"nt\">&lt;context<\/span> <span class=\"na\">ref=<\/span><span class=\"s\">\"integer\"<\/span><span class=\"nt\">\/&gt;<\/span>\r\n      <span class=\"nt\">&lt;\/include&gt;<\/span>\r\n    <span class=\"nt\">&lt;\/context&gt;<\/span>\r\n  <span class=\"nt\">&lt;\/definitions&gt;<\/span>\r\n<span class=\"nt\">&lt;\/language&gt;<\/span>\r\n<\/code><\/pre>\n<h3>\u51ef\u7279<br \/>\n\u5c06\u4ee5.repo\u7ed3\u5c3e\u7684\u6587\u4ef6\u4f5c\u4e3aINI\u6587\u4ef6\u6253\u5f00\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"cp\">&lt;?xml version=\"1.0\" encoding=\"UTF-8\"?&gt;<\/span>\r\n<span class=\"cp\">&lt;!DOCTYPE language SYSTEM \"language.dtd\"&gt;<\/span>\r\n<span class=\"nt\">&lt;language<\/span> <span class=\"na\">name=<\/span><span class=\"s\">\"INI Files\"<\/span> <span class=\"na\">section=<\/span><span class=\"s\">\"Configuration\"<\/span> <span class=\"na\">extensions=<\/span><span class=\"s\">\"*.ini;*.pls;*.kcfgc;*.repo\"<\/span> <span class=\"na\">mimetype=<\/span><span class=\"s\">\"\"<\/span> <span class=\"na\">version=<\/span><span class=\"s\">\"1.1\"<\/span> <span class=\"na\">kateversion=<\/span><span class=\"s\">\"2.0\"<\/span> <span class=\"na\">author=<\/span><span class=\"s\">\"Jan Janssen (medhefgo@web.de)\"<\/span> <span class=\"na\">license=<\/span><span class=\"s\">\"LGPL\"<\/span><span class=\"nt\">&gt;<\/span> <span class=\"c\">&lt;!-- extensions\u5c5e\u6027\u5024\u306b *.repo \u3092\u8ffd\u52a0 --&gt;<\/span>\r\n\r\n                    <span class=\"c\">&lt;!--##############\r\n                        ## \u4ee5\u4e0b\u7701\u7565 ##\r\n                        ##############--&gt;<\/span>\r\n<\/code><\/pre>\n<h3>\u7eb3\u7c73\u4f7f\u7528 Arch Linux \u4e0a\u7684 nano-syntax-highlighting-git \u8f6f\u4ef6\u5305\u30027 8<\/p>\n<pre class=\"post-pre\"><code><span class=\"c\"># INI\u30d5\u30a1\u30a4\u30eb\u306e\u30b7\u30f3\u30bf\u30c3\u30af\u30b9\u30cf\u30a4\u30e9\u30a4\u30c8\u3092\u884c\u3046\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/span>\r\nwget https:\/\/raw.githubusercontent.com\/scopatz\/nanorc\/master\/ini.nanorc\r\n\r\n<span class=\"c\"># .repo \u3067\u7d42\u308f\u308b\u30d5\u30a1\u30a4\u30eb\u3092INI\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u6271\u3046\u3088\u3046\u306b\u3059\u308b<\/span>\r\n<span class=\"nb\">sed<\/span> <span class=\"nt\">--in-place<\/span> <span class=\"s1\">'s\/)\\$\/|repo)$\/'<\/span> ini.nanorc\r\n\r\n<span class=\"c\"># \u30b7\u30f3\u30bf\u30c3\u30af\u30b9\u30cf\u30a4\u30e9\u30a4\u30c8\u3092\u884c\u3046\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u4fdd\u7ba1\u5834\u6240\u306b\u79fb\u52d5<\/span>\r\n<span class=\"nb\">sudo mv <\/span>ini.nanorc \/usr\/share\/nano\/\r\n\r\n<span class=\"c\"># nano\u306e\u500b\u4eba\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u304b\u3089\u8aad\u307f\u8fbc\u3080\u3088\u3046\u306b\u3059\u308b<\/span>\r\n<span class=\"nb\">echo<\/span> <span class=\"s1\">$'<\/span><span class=\"se\">\\n\\n<\/span><span class=\"s1\">'<\/span><span class=\"c\">## INI files$'\\n'include \"\/usr\/share\/nano\/ini.nanorc\" &gt;&gt; ~\/.nanorc<\/span>\r\n<\/code><\/pre>\n<h2>\u5b89\u88dd\u5728CentOS\u7684\u5b98\u65b9\u4ed3\u5e93\u4e2d\uff0c\u63d0\u4f9b\u4e86\u65e7\u7248\u672c\u7684MariaDB 5.5\u3002\u56e0\u6b64\uff0c\u6211\u4eec\u9700\u8981\u6dfb\u52a0MariaDB\u7684\u5b98\u65b9\u4ed3\u5e93\uff0c\u5e76\u4ece\u8be5\u4ed3\u5e93\u5b89\u88c5\u6700\u65b0\u7248\u672c\u3002<\/p>\n<p>\u4f7f\u7528yum\u5b89\u88c5MariaDB- MariaDB\u77e5\u8bc6\u5e93<\/p>\n<p>\u9605\u8bfb\u4e0a\u4e00\u9875\uff0c\u5e76\u6309\u7167\u6b65\u9aa4\u5b8c\u6210\u5b89\u88c5\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"nn\">[mariadb]<\/span>\r\n<span class=\"py\">name<\/span> <span class=\"p\">=<\/span> <span class=\"s\">MariaDB<\/span>\r\n<span class=\"py\">baseurl<\/span> <span class=\"p\">=<\/span> <span class=\"s\">http:\/\/yum.mariadb.org\/10.2\/centos7-amd64<\/span>\r\n<span class=\"py\">gpgkey<\/span><span class=\"p\">=<\/span><span class=\"s\">https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB<\/span>\r\n<span class=\"py\">gpgcheck<\/span><span class=\"p\">=<\/span><span class=\"s\">1<\/span>\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"c\"># MariaDB\u306e\u30b5\u30fc\u30d0\u30fc\u30fb\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/span>\r\n<span class=\"nb\">sudo <\/span>yum <span class=\"nb\">install <\/span>MariaDB-server MariaDB-client\r\n\r\n<span class=\"c\"># \u8d77\u52d5<\/span>\r\n<span class=\"nb\">sudo <\/span>systemctl start mariadb\r\n<\/code><\/pre>\n<p>RPM\u5305\u4e0b\u8f7d\u5b8c\u6210\u540e\uff0c\u4f1a\u8be2\u95ee\u662f\u5426\u53ef\u4ee5\u5bfc\u5165GPG\u516c\u94a5\uff0c\u8bf7\u786e\u8ba4\u6307\u7eb9\u4e0ehttps:\/\/mariadb.com\/kb\/ja\/gpg\/\u4e2d\u7684\u6307\u7eb9\u662f\u5426\u5927\u5c0f\u5199\u4e0d\u654f\u611f\u4e00\u81f4\u3002<\/p>\n<h2>\u8bbe\u5b9a\u7b26\u53f7\u5316\u65b9\u5f0f\u5982\u679c\u8981\u5728 MariaDB \u7684\u8a2d\u5b9a\u6587\u4ef6 (*.cnf) \u4e2d\u555f\u7528\u8a9e\u6cd5\u9ad8\u4eae\uff0c\u8acb\u5c07 *.repo \u7684\u8a9e\u6cd5\u9ad8\u4eae\u8a2d\u7f6e\u8f49\u6210 cnf \u4e26\u9032\u884c\u8a2d\u5b9a\u3002<\/p>\n<h3>\u670d\u52a1\u5668MariaDB\u9ed8\u8ba4\u7684\u5b57\u7b26\u96c6\u662flatin1\uff0c\u8fd9\u8868\u793a\u5b83\u4f7f\u7528\u7684\u662f&#8221;windows-1252&#8243;\u7f16\u7801\u65b9\u5f0f\u3002\u901a\u8fc7\u7f16\u8f91\u914d\u7f6e\u6587\u4ef6\uff0c\u53ef\u4ee5\u5c06MariaDB\u7684\u5b57\u7b26\u96c6\u4fee\u6539\u4e3aUTF-8\u7684\u5b57\u7b26\u96c6utf8mb4\u3002\u9700\u8981\u6ce8\u610f\u7684\u662f\uff0cMariaDB\u7684utf8\u5b57\u7b26\u96c6\u8868\u793a\u7684\u662f&#8221;\u65e0\u6cd5\u5904\u7406\u8f85\u52a9\u5b57\u7b26\uff084\u5b57\u8282\u5b57\u7b26\uff09\u7684UTF-8&#8243;\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"c\">#\r\n# These groups are read by MariaDB server.\r\n# Use it for options that only the server (but not clients) should see\r\n#\r\n# See the examples of server my.cnf files in \/usr\/share\/mysql\/\r\n#\r\n<\/span>\r\n<span class=\"c\"># this is read by the standalone daemon and embedded servers\r\n<\/span><span class=\"nn\">[server]<\/span>\r\n<span class=\"py\">character-set-server<\/span><span class=\"p\">=<\/span><span class=\"s\">utf8mb4<\/span>\r\n<span class=\"py\">log-bin<\/span><span class=\"p\">=<\/span><span class=\"s\">mariadb-bin<\/span>\r\n<span class=\"c\">## \u2191\u3053\u306e2\u884c\u3092\u8ffd\u52a0 ##\r\n<\/span><span class=\"py\">event-scheduler<\/span><span class=\"p\">=<\/span><span class=\"s\">ON<\/span>\r\n<span class=\"c\">## \u2191\u30a4\u30d9\u30f3\u30c8\u30b9\u30b1\u30b8\u30e5\u30fc\u30e9\u3092\u6709\u52b9\u5316\u3059\u308b\u5834\u5408\u306f\u3053\u306e\u884c\u3082\u8ffd\u52a0 ##\r\n<\/span>\r\n<span class=\"c\"># this is only for the mysqld standalone daemon\r\n<\/span><span class=\"nn\">[mysqld]<\/span>\r\n\r\n<span class=\"c\"># this is only for embedded server\r\n<\/span><span class=\"nn\">[embedded]<\/span>\r\n\r\n<span class=\"c\"># This group is only read by MariaDB servers, not by MySQL.\r\n# If you use the same .cnf file for MySQL and MariaDB,\r\n# you can put MariaDB-only options here\r\n<\/span><span class=\"nn\">[mariadb]<\/span>\r\n\r\n<span class=\"c\"># This group is only read by MariaDB-10.0 servers.\r\n# If you use the same .cnf file for MariaDB of different versions,\r\n# use this group for options that older servers don't understand\r\n<\/span><span class=\"nn\">[mariadb-10.0]<\/span>\r\n<\/code><\/pre>\n<p>\u6839\u636e character_set_server \u7684\u8bbe\u7f6e\uff0ccharacter_set_database\u3001collation_server\u3001collation_database \u4f1a\u81ea\u52a8\u914d\u7f6e\u3002log-bin \u7684\u503c mariadb-bin \u662f\u4e8c\u8fdb\u5236\u65e5\u5fd7\u6587\u4ef6\u540d\u7684\u524d\u7f00\uff0c\u53ef\u4ee5\u4f7f\u7528\u4efb\u610f\u503c\u3002\u5ba2\u6237\u7aef\u7684\u7f16\u7801\u65b9\u5f0f\u53d6\u51b3\u4e8e\u5ba2\u6237\u7aef\u7684\u8bbe\u7f6e\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"c\"># \u8a2d\u5b9a\u306e\u53cd\u6620<\/span>\r\n<span class=\"nb\">sudo <\/span>systemctl restart mariadb\r\n<\/code><\/pre>\n<p>\u5728\u91cd\u65b0\u52a0\u8f7d mariadb \u65f6\uff0c\u7cfb\u7edf\u53d8\u91cf\u7684\u8bbe\u7f6e\u5c06\u4e0d\u4f1a\u751f\u6548\u3002<\/p>\n<h3>\u547d\u4ee4\u884c\u5ba2\u6237\u7aef<br \/>\n\u5c06MariaDB-client\u4e2d\u5305\u542b\u7684\u547d\u4ee4\uff08\u5982mysql\u7b49\uff09\u7684\u9ed8\u8ba4\u7f16\u7801\u65b9\u5f0f\u4eceauto\u66f4\u6539\u4e3autf8mb4\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"c\">#\r\n# These two groups are read by the client library\r\n# Use it for options that affect all clients, but not the server\r\n#\r\n<\/span>\r\n\r\n<span class=\"nn\">[client]<\/span>\r\n<span class=\"py\">default-character-set<\/span><span class=\"p\">=<\/span><span class=\"s\">utf8mb4<\/span>\r\n<span class=\"c\">## \u2191\u3053\u306e\u884c\u3092\u8ffd\u52a0 ##\r\n<\/span>\r\n<span class=\"c\"># This group is not read by mysql client library,\r\n# If you use the same .cnf file for MySQL and MariaDB,\r\n# use it for MariaDB-only client options\r\n<\/span><span class=\"nn\">[client-mariadb]<\/span>\r\n\r\n<\/code><\/pre>\n<p>\u53e6\u5916\uff0cdefault_character_set\u5df2\u88ab\u5e9f\u5f03\uff0c\u5e76\u66f4\u540d\u4e3acharacter_set_server\uff0c\u8fd9\u662f\u5173\u4e8e\u670d\u52a1\u5668\u7cfb\u7edf\u53d8\u91cf\u7684\u95ee\u9898\u3002\u5728mysql\u547d\u4ee4\u7b49\u4e2d\uff0c\u4ecd\u7136\u662f&#8211;default-character-set\u9009\u9879\uff0c\u8bf7\u6ce8\u610f\u3002<\/p>\n<h2>\u5176\u4ed6\u521d\u59cb\u8bbe\u7f6emysql_secure_installation &#8211; MariaDB \u77e5\u8bc6\u5e93- \u8fdb\u884c\u5b89\u5168\u5b89\u88c5<\/p>\n<p>\u67e5\u770b\u4e0a\u4e00\u9875\uff0c\u6267\u884cmysql_secure_installation\u547d\u4ee4\u3002\u7531\u4e8e\u5c1a\u672a\u8bbe\u7f6eroot\u5bc6\u7801\uff0c\u5bf9\u4e8eSet root password? [Y\/n]\uff0c\u8bf7\u76f4\u63a5\u6309Enter\u952e\u300211<\/p>\n<pre class=\"post-pre\"><code>[100@localhost ~]$ mysql_secure_installation \u23ce\r\n\r\nNOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB\r\n      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!\r\n\r\nIn order to log into MariaDB to secure it, we'll need the current\r\npassword for the root user.  If you've just installed MariaDB, and\r\nyou haven't set the root password yet, the password will be blank,\r\nso you should just press enter here.\r\nEnter current password for root (enter for none): \u23ce    ## \u73fe\u5728\u306e\u30eb\u30fc\u30c8\u30d1\u30b9\u30ef\u30fc\u30c9\u3002\u672a\u8a2d\u5b9a\u306a\u306e\u3067\u305d\u306e\u307e\u307eEnter ##\r\nOK, successfully used password, moving on...\r\n\r\nSetting the root password ensures that nobody can log into the MariaDB\r\nroot user without the proper authorisation.\r\n\r\nSet root password? [Y\/n] \u23ce                             ## MariaDB\u306eroot\u30e6\u30fc\u30b6\u30fc\u306b\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3059\u308b\u304b\u8a0a\u304b\u308c\u308b\u3002\u300cY\u300d(Yes) \u304c\u65e2\u5b9a\u5024\u306a\u306e\u3067\u305d\u306e\u307e\u307eEnter ##\r\nNew password: ******** \u23ce                               ## MariaDB\u306eroot\u30e6\u30fc\u30b6\u30fc\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u5165\u529b\u3057\u3066Enter ##\r\nRe-enter new password: ******** \u23ce                      ## \u540c\u3058\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u518d\u5165\u529b\u3057\u3066Enter ##\r\nPassword updated successfully!\r\nReloading privilege tables..\r\n ... Success!\r\n\r\n\r\nBy default, a MariaDB installation has an anonymous user, allowing anyone\r\nto log into MariaDB without having to have a user account created for\r\nthem.  This is intended only for testing, and to make the installation\r\ngo a bit smoother.  You should remove them before moving into a\r\nproduction environment.\r\n\r\nRemove anonymous users? [Y\/n] \u23ce                        ## \u533f\u540d\u30e6\u30fc\u30b6\u30fc\u3092\u524a\u9664\u3059\u308b\u304b\u8a0a\u304b\u308c\u308b\u3002\u300cY\u300d(Yes) \u304c\u65e2\u5b9a\u5024\u306a\u306e\u3067\u305d\u306e\u307e\u307eEnter ##\r\n ... Success!\r\n\r\nNormally, root should only be allowed to connect from 'localhost'.  This\r\nensures that someone cannot guess at the root password from the network.\r\n\r\nDisallow root login remotely? [Y\/n] \u23ce                  ## root\u30e6\u30fc\u30b6\u30fc\u306e\u30ea\u30e2\u30fc\u30c8\u30ed\u30b0\u30a4\u30f3\u3092\u7981\u6b62\u3059\u308b\u304b\u8a0a\u304b\u308c\u308b\u3002\u300cY\u300d(Yes) \u304c\u65e2\u5b9a\u5024\u306a\u306e\u3067\u305d\u306e\u307e\u307eEnter ##\r\n ... Success!\r\n\r\nBy default, MariaDB comes with a database named 'test' that anyone can\r\naccess.  This is also intended only for testing, and should be removed\r\nbefore moving into a production environment.\r\n\r\nRemove test database and access to it? [Y\/n] \u23ce         ## test\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u524a\u9664\u3059\u308b\u304b\u8a0a\u304b\u308c\u308b\u3002\u300cY\u300d(Yes) \u304c\u65e2\u5b9a\u5024\u306a\u306e\u3067\u305d\u306e\u307e\u307eEnter ##\r\n - Dropping test database...\r\n ... Success!\r\n - Removing privileges on test database...\r\n ... Success!\r\n\r\nReloading the privilege tables will ensure that all changes made so far\r\nwill take effect immediately.\r\n\r\nReload privilege tables now? [Y\/n] \u23ce                   ## \u6a29\u9650\u30c6\u30fc\u30d6\u30eb\u3092\u518d\u8aad\u307f\u8fbc\u307f\u3059\u308b\u304b\u8a0a\u304b\u308c\u308b\u3002\u300cY\u300d(Yes) \u304c\u65e2\u5b9a\u5024\u306a\u306e\u3067\u305d\u306e\u307e\u307eEnter ##\r\n ... Success!\r\n\r\nCleaning up...\r\n\r\nAll done!  If you've completed all of the above steps, your MariaDB\r\ninstallation should now be secure.\r\n\r\nThanks for using MariaDB!\r\n<\/code><\/pre>\n<h2>\u8fdb\u884c\u6570\u636e\u5e93\u6062\u590d\u548c\u521b\u5efa\u7528\u6237\u3002\u6267\u884cmysql &#8211;user=root &#8211;password\u547d\u4ee4\uff0c\u4ee5MariaDB\u7684root\u7528\u6237\u767b\u5f55\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"c1\">-- \u30ea\u30b9\u30c8\u30a2 (\u30d5\u30a1\u30a4\u30eb\u540d\u304c backup.sql \u306e\u5834\u5408)<\/span>\r\n<span class=\"k\">source<\/span> <span class=\"n\">backup<\/span><span class=\"p\">.<\/span><span class=\"k\">sql<\/span><span class=\"p\">;<\/span>\r\n\r\n<span class=\"c1\">-- \u4e00\u822c\u30e6\u30fc\u30b6\u30fc\u306e\u4f5c\u6210\u3068 \u2985\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540dA\u2986 \u306b\u5bfe\u3059\u308b\u6a29\u9650\u306e\u4ed8\u4e0e<\/span>\r\n<span class=\"k\">GRANT<\/span> <span class=\"k\">ALL<\/span> <span class=\"k\">PRIVILEGES<\/span> <span class=\"k\">ON<\/span> <span class=\"s1\">'\u2985\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540dA\u2986'<\/span><span class=\"p\">.<\/span><span class=\"o\">*<\/span> <span class=\"k\">TO<\/span> <span class=\"s1\">'\u2985MariaDB\u306e\u30e6\u30fc\u30b6\u30fc\u540d\u2986'<\/span><span class=\"o\">@<\/span><span class=\"n\">localhost<\/span> <span class=\"n\">IDENTIFIED<\/span> <span class=\"k\">BY<\/span> <span class=\"s1\">'\u2985MariaDB\u306e\u30e6\u30fc\u30b6\u30fc\u306e\u30d1\u30b9\u30ef\u30fc\u30c9\u2986'<\/span><span class=\"p\">;<\/span>\r\n\r\n<span class=\"c1\">-- \u4f5c\u6210\u3057\u305f\u30e6\u30fc\u30b6\u30fc\u306b \u2985\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540dB\u2986 \u306b\u5bfe\u3059\u308b\u6a29\u9650\u3082\u4ed8\u4e0e<\/span>\r\n<span class=\"k\">GRANT<\/span> <span class=\"k\">ALL<\/span> <span class=\"k\">PRIVILEGES<\/span> <span class=\"k\">ON<\/span> <span class=\"s1\">'\u2985\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540dB\u2986'<\/span><span class=\"p\">.<\/span><span class=\"o\">*<\/span> <span class=\"k\">TO<\/span> <span class=\"s1\">'\u2985MariaDB\u306e\u30e6\u30fc\u30b6\u30fc\u540d\u2986'<\/span><span class=\"o\">@<\/span><span class=\"n\">localhost<\/span><span class=\"p\">;<\/span>\r\n\r\n<span class=\"c1\">-- \u6a29\u9650\u30c6\u30fc\u30d6\u30eb\u306e\u518d\u8aad\u307f\u8fbc\u307f<\/span>\r\n<span class=\"n\">FLUSH<\/span> <span class=\"k\">PRIVILEGES<\/span><span class=\"p\">;<\/span>\r\n\r\n<span class=\"c1\">-- \u30ed\u30b0\u30a2\u30a6\u30c8<\/span>\r\n<span class=\"n\">exit<\/span>\r\n<\/code><\/pre>\n<h1>\u5b89\u5168\u6587\u4ef6\u4f20\u8f93\u534f\u8bae (SFTP)<\/p>\n<h2>\u521b\u5efaSFTP\u7528\u6237\u3002<br \/>\n\u6211\u4eec\u5c06\u62e5\u6709\u4ee5\u4e3b\u76ee\u5f55\u4f5c\u4e3aSFTP\u6839\u76ee\u5f55\u7684\u7528\u6237\u79f0\u4e3a&#8221;homeroot&#8221;\uff0c\u800c\u5c06\u4ee5\u4e3b\u76ee\u5f55\u4e0b\u5c5e\u76ee\u5f55public_html\u4f5c\u4e3aSFTP\u6839\u76ee\u5f55\u7684\u7528\u6237\u79f0\u4e3a&#8221;dirroot&#8221;\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"c\"># \u30b7\u30a7\u30eb\u306b\u30ed\u30b0\u30a4\u30f3\u3067\u304d\u306a\u3044\u30e6\u30fc\u30b6\u30fc\u3092\u4f5c\u6210<\/span>\r\n<span class=\"nb\">sudo <\/span>adduser <span class=\"nt\">--shell<\/span> \/sbin\/nologin homeroot\r\n<span class=\"nb\">sudo <\/span>passwd homeroot\r\n<span class=\"nb\">sudo <\/span>adduser <span class=\"nt\">--shell<\/span> \/sbin\/nologin dirroot\r\n<span class=\"nb\">sudo <\/span>passwd dirroot\r\n<\/code><\/pre>\n<h2>\u8bbe\u7f6eSSH\u516c\u94a5\u3002<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u4eceTera Term\u83dc\u5355\u680f\u4e2d\u6253\u5f00&#8221;\u8bbe\u7f6e&#8221; &#8211; &#8220;SSH\u5bc6\u94a5\u751f\u6210&#8221;\u3002<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u70b9\u51fb&#8221;\u751f\u6210&#8221;\u6309\u94ae\u5c06\u751f\u6210\u4e00\u628a\u5bc6\u94a5\u3002<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u8f93\u5165\u5bc6\u7801\u77ed\u8bed\u300211<\/ol>\n<\/li>\n<\/ol>\n<p>\u70b9\u51fb&#8221;\u4fdd\u5b58\u79c1\u94a5&#8221;\u6309\u94ae\uff0c\u5e76\u5c06\u5176\u4fdd\u5b58\u5230\u4efb\u610f\u4f4d\u7f6e\u300212<\/p>\n<p>\u70b9\u51fb&#8221;\u4fdd\u5b58\u516c\u94a5&#8221;\u6309\u94ae\uff0c\u5e76\u5c06\u5176\u4fdd\u5b58\u5230\u4efb\u610f\u4f4d\u7f6e\u300212<\/p>\n<p>\u5c06\u4fdd\u5b58\u7684\u516c\u94a5\u62d6\u653e\u5230Tera Term\u7a97\u53e3\u4e2d\uff0c\u4f7f\u7528&#8221;SCP&#8221;\u8fdb\u884c\u6587\u4ef6\u4f20\u8f93\u3002<\/p>\n<p>\u4ee5\u4e0b\u662f\u5bf9\u300chomeroot\u300d\u516c\u94a5\u547d\u540d\u4e3ahomeroot.pub\u3001\u300cdirroot\u300d\u516c\u94a5\u547d\u540d\u4e3adirroot.pub\u7684\u8bf4\u660e\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"c\"># SSH\u306e\u8a2d\u5b9a\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3092\u4f5c\u6210<\/span>\r\n<span class=\"nb\">sudo mkdir<\/span> <span class=\"nt\">--mode<\/span><span class=\"o\">=<\/span>500 \/home\/<span class=\"o\">{<\/span>homeroot,dirroot<span class=\"o\">}<\/span>\/.ssh\r\n\r\n<span class=\"c\"># \u516c\u958b\u9375\u3092\u8a2d\u5b9a\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u914d\u7f6e<\/span>\r\n<span class=\"nb\">sudo mv<\/span> ~\/homeroot.pub \/home\/homeroot\/.ssh\/authorized_keys\r\n<span class=\"nb\">sudo mv<\/span> ~\/dirroot.pub \/home\/dirroot\/.ssh\/authorized_keys\r\n\r\n<span class=\"c\"># SSH\u306e\u8a2d\u5b9a\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3001\u304a\u3088\u3073\u516c\u958b\u9375\u306e\u30a2\u30af\u30bb\u30b9\u6a29\u30fb\u6240\u6709\u8005\u3092\u5909\u66f4<\/span>\r\n<span class=\"nb\">sudo chmod <\/span>400 \/home\/<span class=\"o\">{<\/span>homeroot,dirroot<span class=\"o\">}<\/span>\/.ssh\/authorized_keys\r\n<span class=\"nb\">sudo chown<\/span> <span class=\"nt\">--recursive<\/span> homeroot:homeroot \/home\/homeroot\/.ssh\r\n<span class=\"nb\">sudo chown<\/span> <span class=\"nt\">--recursive<\/span> dirroot:dirroot \/home\/dirroot\/.ssh\r\n\r\n<span class=\"c\">#\u3010SELinux\u3011\u516c\u958b\u9375\u306e\u30e9\u30d9\u30eb\u3092\u8cbc\u308a\u76f4\u3059<\/span>\r\n<span class=\"nb\">sudo <\/span>restorecon \/home\/<span class=\"o\">{<\/span>homeroot,dirroot<span class=\"o\">}<\/span>\/.ssh\/authorized_keys\r\n<\/code><\/pre>\n<h2>\u8bbe\u7f6eSFTP\u6839\u76ee\u5f55\u5982\u679cSFTP\u6839\u76ee\u5f55\u53ca\u5176\u4e0a\u7ea7\u76ee\u5f55\u7684\u6240\u6709\u8005\u4e0d\u662froot\uff0c\u5219\u5728\u8bbe\u7f6e\u4e86ChrootDirectory\u65f6\u5c06\u88ab\u62d2\u7edd\u8fde\u63a5\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"c\"># SFTP\u30eb\u30fc\u30c8\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306e\u4f5c\u6210\u3001\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306e\u6240\u6709\u8005\u3092\u5909\u66f4<\/span>\r\n<span class=\"nb\">sudo chown <\/span>root \/home\/<span class=\"o\">{<\/span>homeroot,dirroot<span class=\"o\">}<\/span>\r\n<span class=\"nb\">sudo chmod <\/span>750 \/home\/<span class=\"o\">{<\/span>homeroot,dirroot<span class=\"o\">}<\/span>\r\n<span class=\"nb\">sudo mkdir<\/span> <span class=\"nt\">--mode<\/span><span class=\"o\">=<\/span>775 \/home\/dirroot\/public_html\r\n<span class=\"nb\">sudo chgrp <\/span>dirroot \/home\/dirroot\/public_html\r\n\r\n<span class=\"c\">#\u3010SELinux\u3011SSH\u306b\u3088\u308b\u30db\u30fc\u30e0\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306e\u8aad\u307f\u66f8\u304d\u3092\u8a31\u53ef<\/span>\r\n<span class=\"nb\">sudo <\/span>setsebool <span class=\"nt\">-P<\/span> ssh_chroot_rw_homedirs on\r\n<span class=\"nb\">sudo <\/span>restorecon <span class=\"nt\">-R<\/span> \/home\/homeroot\r\n<\/code><\/pre>\n<p>\u5728\u8fd9\u91cc\uff0c\u6211\u4eec\u7981\u6b62\u5bf9\u4e3b\u76ee\u5f55\u8fdb\u884c\u5199\u5165\u64cd\u4f5c\u3002<\/p>\n<h2>\u4ece\u6587\u6863\u6839\u76ee\u5f55\u8fdb\u884c\u6302\u8f7d\u4ee5\u4e0b\u662f\u5728HTTP\u670d\u52a1\u5668\u7684\u6587\u6863\u6839\u76ee\u5f55\u4e0b\u76f4\u63a5\u4e0a\u4f20\u6587\u4ef6\u7684\u4f8b\u5b50\u3002<\/p>\n<pre class=\"post-pre\"><code>                        <span class=\"c\">##############<\/span>\r\n                        <span class=\"c\">## \u4ee5\u4e0a\u7701\u7565 ##<\/span>\r\n                        <span class=\"c\">##############<\/span>\r\n\r\n<span class=\"c\"># \u2193\u3053\u306e\u884c\u3092\u8ffd\u8a18<\/span>\r\n\/var\/www\/common \/home\/ftpuser\/common none <span class=\"nb\">bind <\/span>0 0\r\n\r\n<\/code><\/pre>\n<p>\u8bf7\u52a1\u5fc5\u5728 \/etc\/fstab \u6587\u4ef6\u7684\u672b\u5c3e\u63d2\u5165\u6362\u884c\u7b26\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"c\"># \u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u30eb\u30fc\u30c8\u306e\u30b0\u30eb\u30fc\u30d7\u3092\u5909\u66f4\u3001\u30b0\u30eb\u30fc\u30d7\u306b\u3082\u66f8\u304d\u8fbc\u307f\u6a29\u9650\u3092\u4e0e\u3048\u308b<\/span>\r\n<span class=\"nb\">sudo chgrp <\/span>homeroot \/var\/www\/html\r\n<span class=\"nb\">sudo chmod <\/span>775 \/var\/www\/html\r\n\r\n<span class=\"c\"># \u30de\u30a6\u30f3\u30c8\u5148\u306e\u30c7\u30a3\u30ec\u30af\u30c8\u30ea (\u30de\u30a6\u30f3\u30c8\u30dd\u30a4\u30f3\u30c8) \u3092\u4f5c\u6210<\/span>\r\n<span class=\"nb\">sudo mkdir<\/span> \/home\/homeroot\/html\r\n\r\n<span class=\"c\"># \/etc\/fstab \u306e\u8a2d\u5b9a\u3092\u9069\u7528<\/span>\r\n<span class=\"nb\">sudo <\/span>mount <span class=\"nt\">-a<\/span>\r\n<\/code><\/pre>\n<h2>OpenSSH\u7684\u914d\u7f6e<\/p>\n<pre class=\"post-pre\"><code>                        <span class=\"c\">##############<\/span>\r\n                        <span class=\"c\">## \u4ee5\u4e0a\u7701\u7565 ##<\/span>\r\n                        <span class=\"c\">##############<\/span>\r\n\r\n<span class=\"c\"># no default banner path<\/span>\r\n<span class=\"c\">#Banner none<\/span>\r\n\r\n<span class=\"c\"># Accept locale-related environment variables<\/span>\r\nAcceptEnv LANG LC_CTYPE LC_NUMERIC LC_TIME LC_COLLATE LC_MONETARY LC_MESSAGES\r\nAcceptEnv LC_PAPER LC_NAME LC_ADDRESS LC_TELEPHONE LC_MEASUREMENT\r\nAcceptEnv LC_IDENTIFICATION LC_ALL LANGUAGE\r\nAcceptEnv XMODIFIERS\r\n\r\n<span class=\"c\"># override default of no subsystems<\/span>\r\n<span class=\"c\">#Subsystem  sftp        \/usr\/libexec\/openssh\/sftp-server<\/span>\r\n<span class=\"c\">## \u2191\u3053\u306e\u884c\u3092\u30b3\u30e1\u30f3\u30c8\u30a2\u30a6\u30c8 ##<\/span>\r\nSubsystem   sftp        internal-sftp\r\n<span class=\"c\">## \u2191\u3053\u306e\u884c\u3092\u8ffd\u52a0 ##<\/span>\r\n\r\n<span class=\"c\"># Example of overriding settings on a per-user basis<\/span>\r\n<span class=\"c\">#Match User anoncvs<\/span>\r\n<span class=\"c\">#   X11Forwarding no<\/span>\r\n<span class=\"c\">#   AllowTcpForwarding no<\/span>\r\n<span class=\"c\">#   PermitTTY no<\/span>\r\n<span class=\"c\">#   ForceCommand cvs server<\/span>\r\n\r\n<span class=\"c\">## \u2193\u3053\u306e\u884c\u4ee5\u964d\u3092\u8ffd\u8a18 ##<\/span>\r\nMatch User homeroot,dirroot\r\n      ForceCommand internal-sftp\r\n\r\nMatch User homeroot\r\n      ChrootDirectory %h\r\n\r\nMatch User dirroot\r\n      ChrootDirectory %h\/public_html\r\n<\/code><\/pre>\n<h1>\u7528\u4e8e\u8fde\u7ebf\u7684\u662fFileZilla\u3002<\/p>\n<h2>\u8bbe\u7f6e\u79c1\u94a5<br \/>\n\u4e0d\u662f\u9010\u4e2a\u8d26\u6237\u6ce8\u518c\uff0c\u800c\u662f\u6279\u91cf\u6ce8\u518c\u3002<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u4eceFileZilla FTP\u5ba2\u6237\u7aef\u7684\u83dc\u5355\u680f\u4e2d\u9009\u62e9\u201c\u7f16\u8f91\u201d\u2192\u201c\u8bbe\u7f6e\u201d\u3002<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u5728\u8bbe\u7f6e\u5bf9\u8bdd\u6846\u7684\u5de6\u4fa7\u83dc\u5355\u4e2d\u9009\u62e9\u201c\u8fde\u63a5\u201d\u2192\u201cSFTP\u201d\u3002<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u70b9\u51fb\u8bbe\u7f6e\u5bf9\u8bdd\u6846\u4e2d\u95f4\u4e0b\u65b9\u7684\u201c\u6dfb\u52a0\u5bc6\u94a5\u6587\u4ef6\u201d\u6309\u94ae\uff0c\u5e76\u6ce8\u518c\u60a8\u7684\u79c1\u94a5\u6587\u4ef6\u3002<\/ol>\n<\/li>\n<\/ol>\n<p>\u53ea\u80fd\u4f7f\u7528\u672a\u53d7\u5bc6\u7801\u4fdd\u62a4\u7684PuTTY\u683c\u5f0f\u5bc6\u94a5\u3002<br \/>\n\u5982\u679c\u5c1d\u8bd5\u6ce8\u518c\u5176\u4ed6\u683c\u5f0f\u7684\u5bc6\u94a5\uff0c\u5c06\u4f1a\u88ab\u8981\u6c42\u8fdb\u884c\u5bc6\u94a5\u8f6c\u6362\u3002<br \/>\nFileZilla\u65e0\u6cd5\u89e3\u6790bcrypt KDF\u683c\u5f0f\u7684\u5bc6\u94a5\uff0c\u4e5f\u65e0\u6cd5\u8fdb\u884c\u8f6c\u6362\u3002<br \/>\n\u5373\u4f7f\u4e00\u4e2a\u8d26\u53f7\u62e5\u6709\u591a\u4e2a\u5bc6\u94a5\uff0c\u4e5f\u9700\u8981\u5168\u90e8\u5728\u6b64\u5904\u6dfb\u52a0\u3002<\/p>\n<h2>\u8fde\u63a5\u8bbe\u7f6e<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u5728FileZilla FTP\u5ba2\u6237\u7aef\u7684\u83dc\u5355\u680f\u4e2d\uff0c\u9009\u62e9\u6587\u4ef6\u25b8\u7ad9\u70b9\u7ba1\u7406\u5668\u3002<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u70b9\u51fb\u5de6\u4e0b\u65b9\u7684\u201c\u65b0\u5efa\u7ad9\u70b9\u201d\u6309\u94ae\uff0c\u5e76\u4e3a\u5176\u547d\u540d\u3002<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u5728\u4e3b\u673a\u680f\u4e2d\u8f93\u5165\u670d\u52a1\u5668\u7684IP\u5730\u5740\uff0c\u5728\u7aef\u53e3\u680f\u4e2d\u8f93\u5165OpenSSH\u6240\u4f7f\u7528\u7684\u7aef\u53e3\u53f7\u3002<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u5728\u534f\u8bae\u7684\u4e0b\u62c9\u83dc\u5355\u4e2d\u9009\u62e9\u201cSFTP-SSH\u6587\u4ef6\u4f20\u8f93\u534f\u8bae\u201d\u3002<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u5728\u767b\u5f55\u7c7b\u578b\u7684\u4e0b\u62c9\u83dc\u5355\u4e2d\u9009\u62e9\u201c\u666e\u901a\u201d\u3002<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u5728\u7528\u6237\u680f\u4e2d\u586b\u5199Linux\u7684\u7528\u6237\u540d\uff0c\u5bc6\u7801\u7559\u7a7a\u3002<\/ol>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\u5982\u679c\u9700\u8981\u7684\u8bdd\uff0c\u586b\u5199\u201c\u8be6\u7ec6\u201d\u6807\u7b7e\u4e2d\u7684\u201c\u9ed8\u8ba4\u672c\u5730\u76ee\u5f55\u201d\u548c\u201c\u9ed8\u8ba4\u8fdc\u7a0b\u76ee\u5f55\u201d\uff0c\u5e76\u52fe\u9009\u201c\u4f7f\u7528\u540c\u6b65\u6d4f\u89c8\u201d\u3002<\/ol>\n<\/li>\n<\/ol>\n<p>\u201c\u9ed8\u8ba4\u8fdc\u7a0b\u76ee\u5f55\u201d\u5e94\u4e3a\u76f8\u5bf9\u4e8eSFTP\u6839\u76ee\u5f55\u7684\u7edd\u5bf9\u8def\u5f84\u3002<\/p>\n<p>\u201c\u8fde\u63a5\u201d<\/p>\n<h1>\u53c2\u8003\u7f51\u9875\u548c\u811a\u6ce8<\/p>\n<div>\n<p>\u5982\u679c\u4e0e\u5ba2\u6237\u7aef\u901a\u4fe1\u4e2d\uff0c\u5219\u5f3a\u5236\u65ad\u5f00\u8fde\u63a5\u3002<\/p>\n<p>\u7531\u4e8e\u672a\u7ecf\u8fc7systemctl\u547d\u4ee4\uff0c\u56e0\u6b64\u5728\u4f7f\u7528systemctl status httpd\u547d\u4ee4\u663e\u793a\u72b6\u6001\u65f6\uff0cActive\u680f\u5c06\u663e\u793a\u4e3afailed (Result: exit-code)\u3002<\/p>\n<p>\u4e0d\u5f3a\u5236\u7ec8\u6b62\u4e0e\u5ba2\u6237\u7aef\u901a\u4fe1\u4e2d\u7684\u5b50\u8fdb\u7a0b\uff0c\u800c\u662f\u6309\u7167\u901a\u4fe1\u7ed3\u675f\u7684\u8fdb\u7a0b\u987a\u5e8f\u505c\u6b62\u3002<\/p>\n<p>\u4e0d\u5f3a\u5236\u7ec8\u6b62\u4e0e\u5ba2\u6237\u7aef\u901a\u4fe1\u4e2d\u7684\u5b50\u8fdb\u7a0b\uff0c\u800c\u662f\u9010\u6b65\u5c06\u5176\u66ff\u6362\u4e3a\u65b0\u8fdb\u7a0b\u3002<\/p>\n<p>\u666e\u901a\u7528\u6237\u6ca1\u6709\/var\/log\/httpd\u6587\u4ef6\u5939\u4ee5\u4e0b\u7684\u8bfb\u53d6\u6743\u9650\uff0c\u56e0\u6b64\u9700\u8981root\u6743\u9650\u624d\u80fd\u8bfb\u53d6\u9519\u8bef\u65e5\u5fd7\u548c\u8bbf\u95ee\u65e5\u5fd7\u3002<\/p>\n<p>\u5728\u521d\u59cb\u8bbe\u7f6e\u4e2d\uff0c\u53ef\u80fd\u5c06TLS\u8fde\u63a5\u7684\u8bbf\u95ee\u65e5\u5fd7\u8bb0\u5f55\u5728\/var\/log\/httpd\/ssl_access_log\u4e2d\u3002<\/p>\n<p>nano\uff08\u65e5\u8bed\uff09- ArchWiki<\/p>\n<p>\u4fee\u6539nano\u7f16\u8f91\u5668\u7684\u914d\u7f6e\u6587\u4ef6nanorc | Linux\u6218\u8bb0<\/p>\n<p>MySQL 5.5.3-m3, 5.5.4-m3\u540c\u65f6\u53d1\u5e03 &#8211; sakaik\u7684\u65e5\u5e38\u611f\u53d7\uff5e(T)\u7f16<\/p>\n<p>mysql\u9009\u9879 | mysql\u547d\u4ee4\u884c\u5ba2\u6237\u7aef &#8211; MariaDB\u77e5\u8bc6\u5e93<\/p>\n<p>\u5728\u5c1d\u8bd5\u767b\u5f55\u65f6\uff0c\u8bf7\u6ce8\u610f\u7b26\u53f7\u548c\u52a0\u5bc6\u65b9\u5f0f\u7684\u517c\u5bb9\u6027\uff0c\u4ee5\u907f\u514d\u8eab\u4efd\u9a8c\u8bc1\u5931\u8d25\u3002<\/p>\n<p>\u4ee5OpenSSH\u683c\u5f0f\u4fdd\u5b58\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5f15\u5165\u56e0\u4e3a\u91cd\u65b0\u5b89\u88c5\u6a31\u82b1VPS\u7684\u64cd\u4f5c\u7cfb\u7edf\u5347\u7ea7\u5230\u4e86CentOS 7\uff0c\u82b1\u8d39\u4e86\u5f88\u591a\u65f6\u95f4\u548c\u7cbe\u529b\uff0c\u6240\u4ee5\u6211\u628a\u8fd9\u4e2a\u8fc7\u7a0b\u4f5c\u4e3a\u5907\u5fd8\u5f55 [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[227],"class_list":["post-28745","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-227"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u5728 CentOS 7 \u4e0a\u5b89\u88c5 Apache \u548c MariaDB 10.2\uff0c\u5e76\u8fdb\u884c SFTP \u8fde\u63a5 - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"\u5173\u4e8e\u5728 CentOS 7 \u4e0a\u5b89\u88c5 Apache \u548c MariaDB 10.2\uff0c\u5e76\u8fdb\u884c SFTP \u8fde\u63a5\u7684\u6280\u672f\u6587\u7ae0\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5728-centos-7-\u4e0a\u5b89\u88c5-apache-\u548c-mariadb-10-2\uff0c\u5e76\u8fdb\u884c-sftp-\u8fde\u63a5\u3002\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u5728 CentOS 7 \u4e0a\u5b89\u88c5 Apache \u548c MariaDB 10.2\uff0c\u5e76\u8fdb\u884c SFTP \u8fde\u63a5\" \/>\n<meta property=\"og:description\" content=\"\u5173\u4e8e\u5728 CentOS 7 \u4e0a\u5b89\u88c5 Apache \u548c MariaDB 10.2\uff0c\u5e76\u8fdb\u884c SFTP \u8fde\u63a5\u7684\u6280\u672f\u6587\u7ae0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u5728-centos-7-\u4e0a\u5b89\u88c5-apache-\u548c-mariadb-10-2\uff0c\u5e76\u8fdb\u884c-sftp-\u8fde\u63a5\u3002\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-21T07:22:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-12T01:53:41+00:00\" \/>\n<meta name=\"author\" content=\"\u97f5, \u79d1\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u97f5, \u79d1\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8-centos-7-%e4%b8%8a%e5%ae%89%e8%a3%85-apache-%e5%92%8c-mariadb-10-2%ef%bc%8c%e5%b9%b6%e8%bf%9b%e8%a1%8c-sftp-%e8%bf%9e%e6%8e%a5%e3%80%82\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8-centos-7-%e4%b8%8a%e5%ae%89%e8%a3%85-apache-%e5%92%8c-mariadb-10-2%ef%bc%8c%e5%b9%b6%e8%bf%9b%e8%a1%8c-sftp-%e8%bf%9e%e6%8e%a5%e3%80%82\/\",\"name\":\"\u5728 CentOS 7 \u4e0a\u5b89\u88c5 Apache \u548c MariaDB 10.2\uff0c\u5e76\u8fdb\u884c SFTP \u8fde\u63a5 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-02-21T07:22:34+00:00\",\"dateModified\":\"2025-08-12T01:53:41+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e\"},\"description\":\"\u5173\u4e8e\u5728 CentOS 7 \u4e0a\u5b89\u88c5 Apache \u548c MariaDB 10.2\uff0c\u5e76\u8fdb\u884c SFTP \u8fde\u63a5\u7684\u6280\u672f\u6587\u7ae0\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8-centos-7-%e4%b8%8a%e5%ae%89%e8%a3%85-apache-%e5%92%8c-mariadb-10-2%ef%bc%8c%e5%b9%b6%e8%bf%9b%e8%a1%8c-sftp-%e8%bf%9e%e6%8e%a5%e3%80%82\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8-centos-7-%e4%b8%8a%e5%ae%89%e8%a3%85-apache-%e5%92%8c-mariadb-10-2%ef%bc%8c%e5%b9%b6%e8%bf%9b%e8%a1%8c-sftp-%e8%bf%9e%e6%8e%a5%e3%80%82\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8-centos-7-%e4%b8%8a%e5%ae%89%e8%a3%85-apache-%e5%92%8c-mariadb-10-2%ef%bc%8c%e5%b9%b6%e8%bf%9b%e8%a1%8c-sftp-%e8%bf%9e%e6%8e%a5%e3%80%82\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u5728 CentOS 7 \u4e0a\u5b89\u88c5 Apache \u548c MariaDB 10.2\uff0c\u5e76\u8fdb\u884c SFTP \u8fde\u63a5\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e\",\"name\":\"\u97f5, \u79d1\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g\",\"caption\":\"\u97f5, \u79d1\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/yunke\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8-centos-7-%e4%b8%8a%e5%ae%89%e8%a3%85-apache-%e5%92%8c-mariadb-10-2%ef%bc%8c%e5%b9%b6%e8%bf%9b%e8%a1%8c-sftp-%e8%bf%9e%e6%8e%a5%e3%80%82\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u5728 CentOS 7 \u4e0a\u5b89\u88c5 Apache \u548c MariaDB 10.2\uff0c\u5e76\u8fdb\u884c SFTP \u8fde\u63a5 - Blog - Silicon Cloud","description":"\u5173\u4e8e\u5728 CentOS 7 \u4e0a\u5b89\u88c5 Apache \u548c MariaDB 10.2\uff0c\u5e76\u8fdb\u884c SFTP \u8fde\u63a5\u7684\u6280\u672f\u6587\u7ae0","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u5728-centos-7-\u4e0a\u5b89\u88c5-apache-\u548c-mariadb-10-2\uff0c\u5e76\u8fdb\u884c-sftp-\u8fde\u63a5\u3002\/","og_locale":"zh_CN","og_type":"article","og_title":"\u5728 CentOS 7 \u4e0a\u5b89\u88c5 Apache \u548c MariaDB 10.2\uff0c\u5e76\u8fdb\u884c SFTP \u8fde\u63a5","og_description":"\u5173\u4e8e\u5728 CentOS 7 \u4e0a\u5b89\u88c5 Apache \u548c MariaDB 10.2\uff0c\u5e76\u8fdb\u884c SFTP \u8fde\u63a5\u7684\u6280\u672f\u6587\u7ae0","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u5728-centos-7-\u4e0a\u5b89\u88c5-apache-\u548c-mariadb-10-2\uff0c\u5e76\u8fdb\u884c-sftp-\u8fde\u63a5\u3002\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-02-21T07:22:34+00:00","article_modified_time":"2025-08-12T01:53:41+00:00","author":"\u97f5, \u79d1","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u97f5, \u79d1","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"1 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8-centos-7-%e4%b8%8a%e5%ae%89%e8%a3%85-apache-%e5%92%8c-mariadb-10-2%ef%bc%8c%e5%b9%b6%e8%bf%9b%e8%a1%8c-sftp-%e8%bf%9e%e6%8e%a5%e3%80%82\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8-centos-7-%e4%b8%8a%e5%ae%89%e8%a3%85-apache-%e5%92%8c-mariadb-10-2%ef%bc%8c%e5%b9%b6%e8%bf%9b%e8%a1%8c-sftp-%e8%bf%9e%e6%8e%a5%e3%80%82\/","name":"\u5728 CentOS 7 \u4e0a\u5b89\u88c5 Apache \u548c MariaDB 10.2\uff0c\u5e76\u8fdb\u884c SFTP \u8fde\u63a5 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-02-21T07:22:34+00:00","dateModified":"2025-08-12T01:53:41+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e"},"description":"\u5173\u4e8e\u5728 CentOS 7 \u4e0a\u5b89\u88c5 Apache \u548c MariaDB 10.2\uff0c\u5e76\u8fdb\u884c SFTP \u8fde\u63a5\u7684\u6280\u672f\u6587\u7ae0","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8-centos-7-%e4%b8%8a%e5%ae%89%e8%a3%85-apache-%e5%92%8c-mariadb-10-2%ef%bc%8c%e5%b9%b6%e8%bf%9b%e8%a1%8c-sftp-%e8%bf%9e%e6%8e%a5%e3%80%82\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8-centos-7-%e4%b8%8a%e5%ae%89%e8%a3%85-apache-%e5%92%8c-mariadb-10-2%ef%bc%8c%e5%b9%b6%e8%bf%9b%e8%a1%8c-sftp-%e8%bf%9e%e6%8e%a5%e3%80%82\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8-centos-7-%e4%b8%8a%e5%ae%89%e8%a3%85-apache-%e5%92%8c-mariadb-10-2%ef%bc%8c%e5%b9%b6%e8%bf%9b%e8%a1%8c-sftp-%e8%bf%9e%e6%8e%a5%e3%80%82\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u5728 CentOS 7 \u4e0a\u5b89\u88c5 Apache \u548c MariaDB 10.2\uff0c\u5e76\u8fdb\u884c SFTP \u8fde\u63a5"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/6530331a63adef3b3443a1fab53a0e6e","name":"\u97f5, \u79d1","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/429ccb39b3fff5188bc17986222cfb0936cbadb8cc933cff04ab5ca01bd30a08?s=96&d=mm&r=g","caption":"\u97f5, \u79d1"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/yunke\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e5%9c%a8-centos-7-%e4%b8%8a%e5%ae%89%e8%a3%85-apache-%e5%92%8c-mariadb-10-2%ef%bc%8c%e5%b9%b6%e8%bf%9b%e8%a1%8c-sftp-%e8%bf%9e%e6%8e%a5%e3%80%82\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/28745","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=28745"}],"version-history":[{"count":3,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/28745\/revisions"}],"predecessor-version":[{"id":111379,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/28745\/revisions\/111379"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=28745"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=28745"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=28745"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}