{"id":27,"date":"2019-07-01T06:47:00","date_gmt":"2019-07-01T06:47:00","guid":{"rendered":"http:\/\/pro369.com\/linux\/?p=27"},"modified":"2019-07-01T06:47:00","modified_gmt":"2019-07-01T06:47:00","slug":"linux-server%e4%b8%bb%e6%a9%9f%e8%88%87%e4%b8%bb%e6%a9%9f%e7%9a%84%e7%a7%bb%e8%bd%89","status":"publish","type":"post","link":"https:\/\/por.tw\/linux\/linux-server%e4%b8%bb%e6%a9%9f%e8%88%87%e4%b8%bb%e6%a9%9f%e7%9a%84%e7%a7%bb%e8%bd%89\/","title":{"rendered":"Linux Server\u4e3b\u6a5f\u8207\u4e3b\u6a5f\u7684\u79fb\u8f49"},"content":{"rendered":"

Linux Server\u4e3b\u6a5f\u8207\u4e3b\u6a5f\u7684\u79fb\u8f49<\/strong><\/font><\/p>\n

\u672c\u6587\u4e3b\u8981\u5728\u4ecb\u7d39\u5982\u4f55\u628a Linux \u4e0a\u7684\u8cc7\u6599\uff0c\u542b\u4f7f\u7528\u8005\u5e33\u865f\u3001\u7db2\u9801\u3001\u8cc7\u6599\u5eab\u79fb\u8f49\u81f3\u53e6\u4e00\u53f0 Linux Server \u4e0a\u982d\u3002
Linux\u4e3b\u6a5f\u7684\u79fb\u8f49\u8981\u638c\u63e1\u4ee5\u4e0b\u5e7e\u9ede\u539f\u5247\uff1a <\/strong><\/font>
\u8981\u6ce8\u610f\u539f\u7db2\u9801\u61c9\u7528\u8edf\u9ad4\u4e4b\u5b89\u5168\u6027
\u6709\u4e9b\u820a\u7684\u8edf\u9ad4\uff0c\u53ef\u80fd\u5df2\u6709\u6f0f\u6d1e\uff0c\u4e0d\u8981\u518d\u628a\u820a\u7684\u7248\u672c\u8f49\u79fb\u904e\u4f86\u3002
\u5728\u79fb\u8f49\u8cc7\u6599\u7684\u540c\u6642\uff0c\u5fc5\u9808\u8981\u6ce8\u610f\uff0c\u8a72\u8cc7\u6599\u7684\u6a94\u6848\u6b0a\u9650\u3002\u4e0d\u8981\u5728\u5b8c\u6210\u8cc7\u6599\u79fb\u8f49\u4e4b\u5f8c\uff0c\u4e00\u822c user \u90fd\u300c\u770b\u300d\u4e0d\u5230\uff0c\u53ea\u5269 root \u4e00\u500b\u624d\u770b\u5f97\u5230\u3002
\u53ef\u5728\u5169\u53f0 Linux \u4e4b\u9593\u76f4\u63a5\u4f7f\u7528 gFtp \u8edf\u9ad4\uff0c\u4ee5 SFTP2 (SSH2) \u5354\u5b9a\u3001 Root \u8eab\u4efd\uff0c\u76f4\u63a5\u628a\u5404\u7a2e\u8cc7\u6599\u5f9e\u820a\u6a5f\u5668\u50b3\u9001\u5230\u65b0\u6a5f\u5668\u4e0a\u3002<\/p>\n

<\/p>\n

Linux\u4e3b\u6a5f\u7684MySQL\u8cc7\u6599\u5eab\u79fb\u8f49\uff1a <\/strong><\/font>
\u8cc7\u6599\u5eab\u4f4d\u7f6e\uff1a\/var\/lib\/mysql
\/var\/lib\/mysql\/mysql \u53ca \/var\/lib\/mysql\/test \u4e0d\u53ef\u642c\u52d5
\u9664\u4e86\u4e0a\u8ff0\u9019\u5169\u500b\u8cc7\u6599\u593e\u4e0d\u53ef\u642c\u52d5\u5916\uff0c\u5176\u9918\u5728 \/var\/lib\/mysql\/ \u5e95\u4e0b\u7684\u8cc7\u6599\u593e\uff08\u8cc7\u6599\u5eab\uff09\uff0c\u7686\u53ef\u4ee5\u642c\u5230\u65b0 Linux Server\u4e3b\u6a5f\u7684 \/var\/lib\/mysql \u5e95\u4e0b\u3002
\u56e0\u70ba \/var\/lib\/mysql\/mysql \u662f MySQL \u7684\u7cfb\u7d71\u8cc7\u6599\u5eab\uff0c\u5b83\u8a18\u9304\u4e86\u8a31\u8a31\u591a\u591a MySQL Server \u7684\u8a2d\u5b9a\u53c3\u6578\u3002\u800c\u4e14\uff0c\u820a\u7248\u7684 MySQL \u8207\u65b0\u7248\u7684 MySQL \uff0c\u7cfb\u7d71\u8cc7\u6599\u5eab\u6703\u6709\u6b04\u4f4d\u5b9a\u7fa9\u4e0a\u7684\u4e0d\u540c\uff0c\u82e5\u60a8\u628a\u820a\u7248\u7cfb\u7d71\u8cc7\u6599\u5eab\uff0c\u76f4\u63a5\u8986\u84cb\u5230\u65b0\u7248\u4e4b\u4e0a\uff0c\u53ef\u80fd\u6703\u9020\u6210 MySQL \u555f\u52d5\u5931\u6557\u3002
\u4f8b\u5916\uff1a\u82e5\u662f\u65b0\u820a\u4e3b\u6a5f\u7684 Linux\/LinuxD Server \u7248\u672c\u4e00\u81f4\uff0c\u7406\u8ad6\u4e0a\u5176 MySQL \u7248\u672c\u61c9\u8a72\u4e5f\u4e00\u81f4\uff0c\u5c31\u53ef\u4ee5\u57f7\u884c\u4ee5\u4e0b\u52d5\u4f5c\u5373\u53ef
\u76f4\u63a5\u628a \/var\/lib\/mysql\/ \u5e95\u4e0b\u6240\u6709\u8cc7\u6599\u593e\u8907\u88fd\u5230\u65b0\u4e3b\u6a5f\u4e0a\u76f8\u540c\u7684\u4f4d\u7f6e\u4e0a
\u4e0d\u5fc5\u518d\u52d5 MySQL \u4f7f\u7528\u8005\u6b0a\u9650\u7684\u90e8\u4efd
\u8907\u88fd\u5230\u65b0\u4e3b\u6a5f\u6642\uff0c\u8981\u8a18\u5f97\u628a \/var\/lib\/mysql \u5e95\u4e0b\u6240\u6709\u7684\u8cc7\u6599\u593e(\u8cc7\u6599\u5eab\uff09\u6b0a\u9650\uff0c\u6539\u70ba mysql.mysql
root@dns:~# chown -R mysql.mysql \/var\/lib\/mysql\/*
\u5728 LinuxD \u5e95\u4e0b\u53ef\u4ee5\u4f7f\u7528 filezilla \u4ee5 SFTP \u7684\u5354\u5b9a\uff0c\u76f4\u63a5\u7528 Root \u8eab\u4efd\u9032\u884c\u642c\u52d5
root@dns:~# apt-get install filezilla
\u6aa2\u67e5\u6240\u6709 PHP+MySQL\u7a0b\u5f0f\u78bc(\u5982 ANN \u516c\u544a\u6b04…etc)\uff0c\u628a\u6240\u4f7f\u7528\u5230\u7684 MySQL \u4f7f\u7528\u8005\u5e33\u865f\u5bc6\u78bc\uff0c\u65b0\u589e\u81f3\u65b0\u4e3b\u6a5f\u7684 MySQL \u5167
\u4f7f\u7528 phpmyadmin\uff0c\u4f8b\uff1a http:\/\/Your.ServerName\/phpmyadmin
\u5728\u9996\u9801\u4e0a\u9ede\uff1a\u300c\u6b0a\u9650\u300d → \u300c\u65b0\u589e\u4f7f\u7528\u8005\u300d (\u65b0\u589e MySQL \u7684\u4f7f\u7528\u8005)<\/p>\n","protected":false},"excerpt":{"rendered":"

Linux Server\u4e3b\u6a5f\u8207\u4e3b\u6a5f\u7684\u79fb\u8f49 \u672c\u6587\u4e3b\u8981\u5728\u4ecb\u7d39\u5982\u4f55\u628a Linux \u4e0a\u7684\u8cc7\u6599\uff0c\u542b\u4f7f\u7528\u8005\u5e33\u865f\u3001\u7db2\u9801\u3001\u8cc7\u6599 […]<\/p>\n","protected":false},"author":1,"featured_media":511,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[20],"class_list":["post-27","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux","tag-linux"],"_links":{"self":[{"href":"https:\/\/por.tw\/linux\/wp-json\/wp\/v2\/posts\/27"}],"collection":[{"href":"https:\/\/por.tw\/linux\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/por.tw\/linux\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/por.tw\/linux\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/por.tw\/linux\/wp-json\/wp\/v2\/comments?post=27"}],"version-history":[{"count":0,"href":"https:\/\/por.tw\/linux\/wp-json\/wp\/v2\/posts\/27\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/por.tw\/linux\/wp-json\/wp\/v2\/media\/511"}],"wp:attachment":[{"href":"https:\/\/por.tw\/linux\/wp-json\/wp\/v2\/media?parent=27"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/por.tw\/linux\/wp-json\/wp\/v2\/categories?post=27"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/por.tw\/linux\/wp-json\/wp\/v2\/tags?post=27"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}