{"id":42,"date":"2019-07-05T01:01:00","date_gmt":"2019-07-05T01:01:00","guid":{"rendered":"http:\/\/pro369.com\/linux\/?p=42"},"modified":"2019-07-05T01:01:00","modified_gmt":"2019-07-05T01:01:00","slug":"%e7%b6%b2%e9%a0%81%e8%b3%87%e6%96%99%e5%ba%ab-linux%e4%b8%bb%e6%a9%9f%e6%9c%8d%e5%8b%99%ef%bc%88linux%e4%b8%bb%e6%a9%9f%e4%bc%ba%e6%9c%8d%e5%99%a8%e6%9e%b6%e8%a8%ad%e6%8a%80%e8%a1%93%ef%bc%89","status":"publish","type":"post","link":"https:\/\/por.tw\/linux\/%e7%b6%b2%e9%a0%81%e8%b3%87%e6%96%99%e5%ba%ab-linux%e4%b8%bb%e6%a9%9f%e6%9c%8d%e5%8b%99%ef%bc%88linux%e4%b8%bb%e6%a9%9f%e4%bc%ba%e6%9c%8d%e5%99%a8%e6%9e%b6%e8%a8%ad%e6%8a%80%e8%a1%93%ef%bc%89\/","title":{"rendered":"\u7db2\u9801&\u8cc7\u6599\u5eab Linux\u4e3b\u6a5f\u670d\u52d9\uff08Linux\u4e3b\u6a5f\u4f3a\u670d\u5668\u67b6\u8a2d\u6280\u8853\uff09"},"content":{"rendered":"

\u7db2\u9801&\u8cc7\u6599\u5eab  Linux\u4e3b\u6a5f\u670d\u52d9\uff08Linux\u4e3b\u6a5f\u4f3a\u670d\u5668\u67b6\u8a2d\u6280\u8853\uff09<\/strong><\/p>\n

Linux \u4e0a\u9810\u8f09\u4e4b\u7db2\u9801\u53ca\u8cc7\u6599\u5eab\u4f3a\u670d\u5668\u6709\uff0c\u7db2\u9801(WWW)\uff1aApache2\uff0c\u52d5\u614b\u7db2\u9801\u8a9e\u8a00\uff1aPHP5\uff0c\u8cc7\u6599\u5eab\uff1aMySQL\uff15\u3002
\u9019\u4e09\u5957\u7684\u7d44\u5408\uff0c\u53ef\u4f9b\u7db2\u7ad9\u7ba1\u7406\u8005\u653e\u7f6e\u7d14\u975c\u614b\u7db2\u9801(HTML)\u4ee5\u53ca\u542b PHP+MySQL \u7684\u52d5\u614b\u7db2\u9801\u3002
\u4e5f\u56e0\u6b64\uff0c\u53ef\u4ee5\u67b6\u8a2d\u4e00\u4e9b\u5177 Web 2.0 \u4e92\u52d5\u529f\u80fd\u7684\u7db2\u7ad9\uff0c\u5982 XOOPS(CMS), WordPress(\u90e8\u843d\u683c), Moodle(\u6578\u4f4d\u5b78\u7fd2), MediaWiki(\u5171\u7b46\u7cfb\u7d71), osTube(\u5f71\u97f3\u5e73\u53f0), Joomla(CMS), Drupal(CMS)…\u7b49\u7b49\u3002\u9019\u6a23\u4e00\u4f86\u53ef\u4ee5\u670d\u52d9\u5b78\u6821\u540c\u4ec1\uff0c\u4ee4\u6240\u6709\u884c\u653f\u4eba\u54e1\u7686\u53ef\u81ea\u4e3b\u8cbc\u516c\u544a\u3001\u5f71\u7247\u53ca\u7167\u7247\uff0c\u4e8c\u4f86\u6e1b\u5c11\u7db2\u7ba1\u7db2\u7ad9\u5167\u5bb9\u7dad\u904b\u7684\u5de5\u4f5c\u58d3\u529b\u3002
\u958b\u555fPORT<\/p>\n

    * TCP 80   Apache2 + PHP
    * TCP 443  \u52a0\u5bc6\u901a\u9053(HTTPS)
    * TCP 3306 MySQL<\/p>\n

\u7db2\u9801\u4f3a\u670d\u5668 Apache2
\u57fa\u672c\u8a2d\u5b9a
\u57fa\u672c\u7d50\u69cb<\/p>\n

    * \u9810\u8a2d\u7db2\u9801\u5b58\u653e\u4f4d\u7f6e\uff1a \/var\/www
      \u6ce8\u610f\uff1a\u9664\u4e86\u4e0a\u50b3\u4e4b\u5fc5\u8981\u5b50\u76ee\u9304\u5916\uff0c\u6b64\u8cc7\u6599\u593e\u5207\u4e0d\u53ef\u4ee5\u8b93 www-data \u53ef\u5b8c\u6574\u8b80\u5beb
    * \u9810\u8a2d\u500b\u4eba\u7db2\u9801\u4f4d\u7f6e\uff1a \/home\/user\/public_html
    * \u8a2d\u5b9a\u6a94\u4f4d\u7f6e\uff1a \/etc\/apache2
          \u4e3b\u8a2d\u5b9a\u6a94\uff1a \/etc\/apache2\/apache2.conf
          \u5fc5\u8f09\u5165\u4e4b\u76f8\u95dc\u8a2d\u5b9a\uff1a \/etc\/apache2\/conf.d\/*
            \u6ce8\u610f\uff1a\u5728\u6b64\u76ee\u9304\u4e0b\u7684\u6240\u6709\u8a2d\u5b9a\u6a94\u7686\u6703\u88ab\u57f7\u884c\uff0c\u6240\u4ee5\u82e5\u6709\u4efb\u4f55\u4fee\u6539\uff0c\u5176\u5099\u4efd\u8a2d\u5b9a\u6a94\u4e0d\u53ef\u7559\u5728\u539f\u5730
          \u53ef\u7528\u6a21\u7d44\uff1a \/etc\/apache2\/mods-available
          \u6a21\u7d44\u555f\u7528\uff1a \/etc\/apache2\/mods-enabled
          \u53ef\u7528\u865b\u64ec\u7ad9\u53f0\uff1a \/etc\/apache2\/sites-available
          \u865b\u64ec\u7ad9\u53f0\u555f\u7528\uff1a \/etc\/apache2\/sites-enabled
    * \u8a18\u9304\u6a94
          \u5b58\u53d6\u8a18\u9304\uff1a \/var\/log\/apache2\/access.log
          \u932f\u8aa4\u8a18\u9304\uff1a \/var\/log\/apache2\/error.log<\/p>\n

\u6a21\u7d44\u7ba1\u7406<\/p>\n

    * \u6a21\u7d44\u5b89\u88dd\u7ba1\u7406
          \u5217\u51fa\u53ef\u4f9b\u5b89\u88dd\u7684 apache2 \u5957\u4ef6\uff0c\u88e1\u9762\u540d\u70ba apache2-xxx \u4e4b\u5957\u4ef6\u5c31\u662f\u53ef\u5b89\u88dd\u7684\u6a21\u7d44\uff1a
            root@dns:~# apt-cache search libapache2
          \u5b89\u88dd\u6a21\u7d44\uff1a
            root@dns:~# apt-get install libapache2-mod-xxxx
    * \u555f\u7528\u6a21\u7d44
         1. \u5217\u51fa\u6a21\u7d44\u771f\u5be6\u540d\u7a31
            root@dns:~# cd \/etc\/apache2\/mods-available
            root@dns:~# ls
         2. \u555f\u7528\u6240\u627e\u5230\u6a21\u7d44\uff0c\u4f8b\u5982\uff1a\u555f\u7528\u500b\u4eba\u7db2\u9801\u6a21\u7d44
            root@dns:~# a2enmod userdir
            \u6ce8\u610f\uff1a\u6a21\u7d44\u8a2d\u5b9a\u6a94\u5927\u591a\u6703\u6709 *.load \u53ca *.conf \u4f46\u555f\u7528\u6642\uff0c\u4e0d\u7528\u8f38\u5165\u526f\u6a94\u540d
         3. \u91cd\u65b0\u555f\u52d5 Apache2
            root@dns:~# service apache2 restart
    * \u8a3b\uff1aApache2 \u6a21\u7d44\u4e26\u4e0d\u7b49\u65bc PHP5 \u6a21\u7d44\uff0c\u8acb\u52ff\u641e\u6df7<\/p>\n

\u9996\u9801\u57fa\u672c\u53c3\u6578<\/p>\n

    * \u9996\u9801\u8a2d\u5b9a\u6a94\uff1a \/etc\/apache2\/sites-available\/default
    * \u53c3\u6578\u89e3\u8aaa<\/p>\n

\u53c3\u6578     \u9078\u9805     \u8aaa\u660e
DocumentRoot     \/var\/www     \u9996\u9801\u8cc7\u6599\u593e\u4f4d\u7f6e\u5728 \/var\/www
Options     Indexes     \u9996\u9801\u6c92 index.html \u6642\uff0c\u81ea\u52d5\u5217\u51fa\u6a94\u6848\u6e05\u55ae<\/p>\n

    FollowSymLinks     \u5141\u8a31\u4f7f\u7528 Alias \u5efa\u7acb\u7684\u8cc7\u6599\u593e\u6377\u5f91(ex. phpmyadmin)<\/p>\n

    MultiViews     \u589e\u5f37\u591a\u570b\u8a9e\u8a00\u652f\u6301(Big5 & UTF8 \u540c\u5b58\u4e5f\u7b97)\uff0c\u4f46\u6703\u5f71\u97ff\u6548\u80fd
AllowOverride     All     \u652f\u63f4 htaccess \u7a0b\u5ea6\uff0c\u82e5 All \u4ee3\u8868\u5b8c\u5168\u652f\u63f4 htaccess \u8a9e\u6cd5
Order
    allow, deny     allow from \u53ca deny from \u62b5\u89f8\u6642\uff0c\u4ee5 allow \u5360\u8f03\u9ad8\u512a\u5148\u6b0a
allow from     all     \u5141\u8a31\u6240\u6709 IP Address \u700f\u89bd\u672c\u7db2\u7ad9<\/p>\n

\u512a\u5316Big5\u8207UTF8\u7db2\u9801\u4e26\u5b58\u6642\u4e4b\u8655\u7406<\/p>\n

    * \/etc\/apache2\/conf.d\/charset → \u628a AddDefaultCharset \u8a3b\u89e3\u6389
      root@dns:~# vi \/etc\/apache2\/conf.d\/charset<\/p>\n

# AddDefaultCharset UTF-8<\/p>\n

    * \u5728 \/etc\/apache2\/sites-available\/default \uff0c\u52a0\u4e0a MultiViews
      root@dns:~# vi \/etc\/apache2\/sites-available\/default<\/p>\n

…<\/p>\n

     DocumentRoot \/var\/www
     <Directory \/>
          Options FollowSymLinks Multiviews
          AllowOverride All
     <\/Directory>
     <Directory \/var\/www\/>
          Options FollowSymLinks MultiViews
          AllowOverride All
          Order allow,deny
          allow from all
     <\/Directory>
…<\/p>\n

\u500b\u4eba\u7db2\u9801<\/p>\n

\u500b\u4eba\u7db2\u9801\u529f\u80fd\u662f\u8b93\u4e00\u822c\u7684\u4f7f\u7528\u8005\u53ef\u4ee5\u5728\u81ea\u5df1\u7684\u5bb6\u76ee\u9304\u5e95\u4e0b\u5efa\u7acb\u7db2\u9801\uff0c\u5854\u914d ftp \u529f\u80fd\uff0c\u8b93\u4f7f\u7528\u8005\u81ea\u5df1\u7ba1\u7406\u81ea\u5df1\u7684\u7db2\u7ad9\u3002<\/p>\n

    * Linux\/Linux Server \u9810\u8a2d\u500b\u4eba\u7db2\u9801\u4f4d\u7f6e\uff1a \/home\/username\/public_html
    * \u9023\u7dda\u65b9\u5f0f\uff1a http:\/\/your.host.name\/~username\/<\/p>\n

Linux e \u53ca sqz \u555f\u7528\u500b\u4eba\u7db2\u9801\u529f\u80fd<\/p>\n

Linux e \u7248\u672c\u8d77\uff0c\u9810\u8a2d\u4e26\u6c92\u555f\u7528\u500b\u4eba\u7db2\u9801\u7684\u529f\u80fd\uff0c\u56e0\u6b64\u8981\u505a\u4e00\u4e9b\u8abf\u6574\u3002<\/p>\n

    * \u555f\u52d5\u500b\u4eba\u7db2\u9801
      root@dns:~# a2enmod userdir
    * \u91cd\u65b0\u555f\u52d5 Apache2
      root@dns:~# service apache2 restart
    * \u82e5\u8981\u8b93\u500b\u4eba\u7db2\u9801\u4e5f\u53ef\u4ee5\u57f7\u884c PHP Code, Linux sqz \u9019\u500b\u7248\u672c\u5fc5\u9808\u7e7c\u7e8c\u4fee\u6539 \/etc\/apache2\/mods-available\/php5.conf , \u628a\u4e0b\u9762\u5e7e\u884c\u52a0 # \u8a3b\u89e3<\/p>\n

<IfModule mod_php5.c><\/p>\n

    <FilesMatch ".ph(p3?|tml)$">
        SetHandler application\/x-httpd-php
    <\/FilesMatch>
    <FilesMatch ".phps$">
        SetHandler application\/x-httpd-php-source
    <\/FilesMatch>
    # Tre-enable php in user directories comment the following lines
    # (from <IfModule …> t<\/IfModule>.) DNOT set it tOn as it
    # prevents .htaccess files from disabling it.
#    <IfModule mod_userdir.c>
#        <Directory \/home\/*\/public_html>
#           php_admin_value engine Off
#        <\/Directory>
#    <\/IfModule>
<\/IfModule><\/p>\n

\u81ea\u8a02\u500b\u4eba\u7db2\u9801\u4f4d\u7f6e<\/p>\n

\u6709\u6642\uff0c\u81ea\u820a\u6a5f\u5668\u79fb\u8f49\u81f3 Linux \u6642\uff0c\u7531\u65bc\u500b\u4eba\u7db2\u9801\u7684\u820a\u8a2d\u5b9a\u503c\u662f \/home\/user_name\/html \u8207 Linux \u4e0a\u7684\u9810\u8a2d\u503c \/home\/user_name\/public_html \u4e0d\u540c\uff0c\u56e0\u800c\u51fa\u73fe\u4e00\u4e9b\u554f\u984c\u3002\u56e0\u6b64\uff0c\u6211\u5011\u53ef\u900f\u904e\u4fee\u6539\u4e00\u4e9b\u53c3\u6578\uff0c\u800c\u4e0d\u5fc5\u53bb\u628a\u6bcf\u500b\u6709\u500b\u4eba\u7db2\u9801\u7684\u4f7f\u7528\u8005\u627e\u51fa\u4f86\u4fee\u6539\u5176\u7db2\u9801\u8cc7\u6599\u593e\u4f4d\u7f6e\u4ecd\u80fd\u9054\u6210\u500b\u4eba\u7db2\u9801\u7684\u4f7f\u7528\u3002<\/p>\n

    * \u6ce8\u610f\uff1a Linux sqz \u7248\u9810\u8a2d\u6c92\u6709\u555f\u52d5\u500b\u4eba\u7db2\u9801\u529f\u80fd\uff0c\u8acb\u5148\u555f\u7528
      root@dns:~# a2enmod userdir
      root@dns:~# service apache2 restart
    * \u8a2d\u5b9a\u6a94 \/etc\/apache2\/mods-available\/userdir.conf
    * \u4fee\u6539\u4e0b\u9762\u7d05\u5b57\u7684\u90e8\u5206<\/p>\n

<IfModule mod_userdir.c><\/p>\n

   UserDir html
   UserDir disabled root<\/p>\n

   <Directory \/home\/*\/html>
      AllowOverride FileInfAuthConfig Limit Indexes
      Options MultiViews Indexes SymLinksIfOwnerMatch IncludesNoExec
      <Limit GET POST OPTIONS>
         Order allow,deny
         Allow from all
      <\/Limit>
      <LimitExcept GET POST OPTIONS>
         Order deny,allow
         Deny from all
      <\/LimitExcept>
   <\/Directory>
<\/IfModule><\/p>\n

    * \u91cd\u65b0\u555f\u52d5 Apache2 \u4f3a\u670d\u5668
      root@dns:~# service apache2 restart
    * \u6ce8\u610f\uff1a \/home\/user_name \u8cc7\u6599\u593e\u7684\u6b0a\u9650\u5fc5\u9808\u70ba 755 \u624d\u53ef\u4ee5<\/p>\n

\u81ea\u8a02\u932f\u8aa4\u8a0a\u606f<\/p>\n

\u9019\u88e1\u6240\u8b02\u7684\u932f\u8aa4\u8a0a\u606f\uff0c\u662f\u6307\u5916\u9762\u9023\u5230\u5b78\u6821\u7db2\u9801\u6642\uff0c\u9023\u5230\u67d0\u4e9b\u4e0d\u5b58\u5728\u6216\u6709\u8a2d\u5bc6\u78bc\u7684\u7db2\u9801\u6642\uff0cApache2 \u6703\u9001\u51fa\u4e00\u4e9b\u8b66\u544a\u8a0a\u606f\uff0c\u4ee5\u901a\u77e5\u700f\u89bd\u8005\u3002\u4f46\u662f\uff0c\u7531\u65bc\u9019\u4e9b\u932f\u8aa4\u8a0a\u606f\u4e26\u6c92\u6709\u4e2d\u6587\u7248\uff0c\u6703\u9020\u6210\u4e00\u4e9b\u56f0\u64fe\u3002\u4e0d\u904e\uff0c\u6211\u5011\u4ecd\u53ef\u81ea\u884c\u88fd\u4f5c\u5c6c\u65bc\u81ea\u5df1\u7684\u932f\u8aa4\u8a0a\uff0c\u6bd4\u5982\uff1a\u700f\u89bd\u5230\u4e0d\u5b58\u5728\u7db2\u9801\uff0c\u60a8\u53ef\u4ee5\u8aaa\u300c\u5225\u641e\u602a\uff01\u672c\u7ad9\u6c92\u6b64\u9801\u9762…\u770b…\u4ec0\u9ebc\uff01\u300d\u3002<\/p>\n

    * \u8a2d\u5b9a\u6a94\u4f4d\u7f6e\uff0c\u5728\u6b64\uff0c\u7b46\u8005\u4ee5 \/etc\/apache2\/apache2.conf \u70ba\u4f8b
          Linux Server(Janaca) \uff5e Linux e\u7cfb\u5217\uff1a \/etc\/apache2\/apache2.conf
          Linux sqz \uff1a \/etc\/apache2\/conf.d\/localized-error-pages<\/p>\n

    * \u4fee\u6539\u6b65\u9a5f\u5982\u4e0b\uff1a<\/p>\n

   1. \u4fee\u6539\u8a2d\u5b9a\u6a94\u555f\u7528\u81ea\u8a02\u9801\u9762\uff0c\u4f9d\u672c\u4f8b\uff1a\u53ea\u5efa\u7acb 404 \u53ca 403 \u5169\u8a0a\u606f\uff0c\u5176\u9918\u4e0d\u8b8a
      root@dns:~# vi \/etc\/apache2\/apache2.conf
      \u627e\u5230\u4ee5\u4e0b\u5167\u5bb9\uff0c\u4fee\u6539\u7d05\u5b57\u90e8\u5206
      # Customizable error responses come in three flavors:<\/p>\n

      # 1) plain text 2) local redirects 3) external redirects
      #
      # Some examples:
      #ErrorDocument 500 "The server made a boboo."
      ErrorDocument 403 \/errmsg\/e403.php
      ErrorDocument 404 \/errmsg\/e404.php
      #ErrorDocument 402 http:\/\/www.example.com\/subscription_info.html
   2. \u627e\u4e00\u500b\u5730\u65b9\u4e26\u5beb\u597d\u81ea\u8a02\u8a0a\u606f\u9801\u9762\uff0c\u4f9d\u672c\u4f8b\u5176\u4f4d\u7f6e\u5728\uff1a \/var\/www\/errmsg\/
          * \u7de8\u8f2f e403.php \u6b0a\u9650\u4e0d\u8db3\u8b66\u544a\u9801\u4f8b\u5b50<\/p>\n

            <!DOCTYPE html PUBLIC "-\/\/W3C\/\/DTD HTML 4.01\/\/EN" "http:\/\/www.w3.org\/TR\/html4\/strict.dtd">
            <html lang="zh-tw"><\/p>\n

            <head>
            <meta content="text\/html; charset=UTF-8" http-equiv="content-type">
            <title>403 Permission Deny!<\/title>
            <\/head><\/p>\n

            <body>
            <br><br>
            <h2 align="center">403 Permission Deny! \u62b1\u6b49\u60a8\u7121\u6b0a\u95b1\u8b80\u672c\u7db2\u9801\uff01
            <br><br>
            <?php ech"<a href='http:\/\/".$_SERVER["HTTP_HOST"]."\/>\u56de\u672c\u7ad9\u9996\u9801<\/a>" ?>
            <\/h2>
            <\/body><\/p>\n

            <\/html><\/p>\n

          * \u7de8\u8f2f e404.php \u627e\u4e0d\u5230\u9801\u9762\u7684\u8b66\u544a\u9801\u4f8b\u5b50<\/p>\n

            <!DOCTYPE html PUBLIC "-\/\/W3C\/\/DTD HTML 4.01\/\/EN" "http:\/\/www.w3.org\/TR\/html4\/strict.dtd">
            <html lang="zh-tw"><\/p>\n

            <head>
            <meta content="text\/html; charset=UTF-8" http-equiv="content-type">
            <title>404 not find!<\/title>
            <\/head><\/p>\n

            <body>
            <br><br>
            <h2 align="center">404! \u627e\u4e0d\u5230\u60a8\u8981\u6c42\u7684\u7db2\u9801\uff01
            <br><br>
            <?php ech"<a href='http:\/\/".$_SERVER["HTTP_HOST"]."\/>\u56de\u672c\u7ad9\u9996\u9801<\/a>" ?>
            <\/h2>
            <\/body><\/p>\n

            <\/html><\/p>\n

   3. \u91cd\u65b0\u555f\u52d5 Apache2
      root@dns:~# service apache2 restart<\/p>\n

\u65b0\u589e\u865b\u64ec\u7ad9\u53f0<\/p>\n

\u5728\u6b64\uff0c\u7b46\u8005\u662f\u4ee5\u4e0b\u5217\u4e4b\u6a21\u64ec\u60c5\u5883\u5217\u6587\u8aaa\u660e\uff0c\u6b64\u60c5\u5883\u9069\u7528\u65bc\u7576\u5b78\u6821\u6709\u53e6\u4e00\u500b\u4eba\u9700\u7368\u7acb\u8ca0\u8cac\u67d0\u4e00\u7db2\u7ad9\uff0c\u7db2\u7ba1\u4eba\u54e1\u53ef\u4ee5\u5728\u4e0d\u4ea4\u51fa root \u6b0a\u9650\u4e0b\uff0c\u958b\u653e\u4e00\u7d44 PHP+MySQL \u7db2\u9801\u7a7a\u9593\u7d66\u8a72\u4f7f\u7528\u8005\u3002<\/p>\n

    * \u7ba1\u7406\u8005\u958b\u8a2d\u4e00\u7d44 Linux \u53ca MySQL \u7684 user \u5e33\u865f\/\u5bc6\u78bc\uff0c\u5982\uff1amyuser\u3002
    * \u56e0\u6b64\u5728 \/home \u53ca \/var\/lib\/mysql \u5e95\u4e0b\u7686\u6703\u7522\u751f myuser \u8cc7\u6599\u593e\u3002
      \u4f7f\u7528\u8005\u53ea\u80fd\u7528 ftp \u53ca phpmyadmin \u7ba1\u7406\u81ea\u5df1\u7684\u7db2\u9801\u53ca\u8cc7\u6599\u5eab\uff08\u770b\u4e0d\u5230\u5176\u4ed6\u8cc7\u6599\uff09\u3002
    * \u6700\u5f8c\u7ba1\u7406\u8005\u6539\u8b8a\u7db2\u5740\u4e4b\u6307\u5b9a\uff0c\u5982\u4e0b\u6240\u793a\uff1a<\/p>\n

http:\/\/your.host.name\/~myuser   –>   http:\/\/myuser.your.host.name\/<\/p>\n

\u958b\u8a2d myuser \u5e33\u865f<\/p>\n

    * \u65b0\u589e Linux \u5e33\u865f
      root@dns:~# adduser myuser
    * \u4f7f\u7528 phpmyadmin \u5efa\u7acb MySQL \u7a7a\u9593<\/p>\n

   1. \u5efa\u7acb\u8cc7\u6599\u5eab myuser
      \u5728 phpmyadmin \u9996\u9801\u5c31\u6709\u5efa\u7acb\u8cc7\u6599\u5eab\u7684\u529f\u80fd\uff0c\u8acb\u4f9d\u81ea\u5df1\u7684\u9700\u6c42\u5efa\u7acb
   2. \u4e0b SQL \u8a9e\u6cd5\uff0c\u5efa\u7acb myuser \u4f7f\u7528\u8005\u4e26\u4f7f\u5176\u53ea\u80fd\u5b8c\u5168\u5b58\u53d6 myuser \u8cc7\u6599\u5eab<\/p>\n

GRANT ALL PRIVILEGES
   ON myuser.*
   T'myuser'@'localhost'
   IDENTIFIED BY 'myuser_pwd';<\/p>\n

\u4fee\u6539 DNS \u8a2d\u5b9a<\/p>\n

\u65b0\u589e myuser.your.host.name \u7db2\u5740<\/p>\n

\u4ee5\u5927\u6210\u570b\u5c0f dns \u6b63\u89e3\u8a2d\u5b9a\u6a94 \/etc\/bind\/db.dc1es.tnc.edu.tw \u8209\u4f8b\u5982\u4e0b\uff1a
      \uff1a<\/p>\n

www  IN   CNAME   dns.dc1es.tnc.edu.tw.
myuser  IN   CNAME   dns.dc1es.tnc.edu.tw.
;
mail    IN   A   163.26.182.1
s2      IN   A   163.26.182.2
      \uff1a<\/p>\n

\u4ee5\u4e0a\u4f8b\u800c\u8a00\uff1a\u7b46\u8005\u65b0\u589e\u4e86\u4e00\u7b46 myuser.dc1es.tnc.edu.tw →\u3000163.26.182.1 \u7684 dns \u8a18\u9304\uff0c\u4e5f\u5c31\u662f\u8aaa\u76ee\u524d 163.26.182.1 \u6709\u591a\u500b\u82f1\u6587\u7db2\u5740\uff0c\u6bd4\u5982 :<\/p>\n

    * dc1es.tnc.edu.tw
    * dns.dc1es.tnc.edu.tw
    * www.dc1es.tnc.edu.tw
    * mail.dc1es.tnc.edu.tw
    * myuser.dc1es.tnc.edu.tw<\/p>\n

         \uff1a
         \uff1a
         \u7b49
         \u7b49
\u65b0\u589e myuser \u865b\u64ec\u7ad9\u53f0<\/p>\n

    * \u8a2d\u5b9a\u6a94: \/etc\/apache2\/sites-available
    * \u5de5\u4f5c\u539f\u7406
          \u539f\u9810\u8a2d\u503c\u662f\u91dd\u5c0d hostname \u8a2d\u5b9a(ex: dns.dc1es.tnc.edu.tw)
          \u8981\u555f\u7528\u591a\u7d44\u8a2d\u5b9a\uff0c\u4e0d\u80fd\u91dd\u5c0d\u60a8\u6240\u8981\u7684 myuser \u8a2d\u5b9a\uff0c\u5fc5\u9808\u8003\u616e\u5468\u8a73\u3002\u4ea6\u5373\u628a\u4f7f\u7528\u8005\u9023\u81f3\u5b78\u6821\u9996\u9801\u7684\u6240\u6709\u53ef\u80fd\u6027\u7686\u8a2d\u59a5\u3002\u4f8b\u5982: http:\/\/www.dc1es.tnc.edu.tw \u3001http:\/\/dc1es.tnc.edu.tw \u3001http:\/\/163.26.182.1<\/p>\n

\u4fee\u6539 \/etc\/apache2\/sites-available\/default<\/p>\n

\u4fee\u6539 default \u4ee5\u4f9b http:\/\/dc1es.tnc.edu.tw \u4f7f\u7528<\/p>\n

    * root@dns:~# vi \/etc\/apache2\/sites-available\/default<\/p>\n

Linux Server ~ Linux t3 \u524d\u9762\u5e7e\u884c\u8209\u4f8b\u5982\u4e0b\uff1a
NameVirtualHost *<\/p>\n

<VirtualHost *>
   ServerAdmin webmaster@dns.dc1es.tnc.edu.tw
   # ServerName dc1es.tnc.edu.tw
   DocumentRoot \/var\/www\/
      :
      :<\/p>\n

Linux e1 ~ Linux sqz \u524d\u9762\u5e7e\u884c\u8209\u4f8b\u5982\u4e0b\uff1a
<VirtualHost *:80><\/p>\n

   ServerAdmin webmaster@dns.dc1es.tnc.edu.tw
   ServerName dc1es.tnc.edu.tw
   ServerAlias www.dc1es.tnc.edu.tw
   ServerAlias 163.26.182.1
   DocumentRoot \/var\/www\/
      :
      :<\/p>\n

\u5efa\u7acb \/etc\/apache2\/sites-available\/myuser<\/p>\n

\u5efa\u7acb\u3000myuser \u4f9b http:\/\/myuser.dc1es.tnc.edu.tw \u4f7f\u7528<\/p>\n

    * root@dns:\/etc\/apache2\/sites-available# vi myuser (\u5167\u5bb9\u5982\u4e0b\u6240\u793a)<\/p>\n

Linux Server \u793a\u4f8b<\/p>\n

<VirtualHost 163.26.182.1:80>
        ServerAdmin myuser@dc1es.tnc.edu.tw
        ServerName myuser.dc1es.tnc.edu.tw
        DocumentRoot \/home\/myuser\/public_html\/
        <Directory \/home\/myuser\/public_html\/>
                Options Indexes FollowSymLinks MultiViews
                AllowOverride None
                Order allow,deny
                allow from all
                AddType application\/x-httpd-php .php
        <\/Directory>
<\/VirtualHost><\/p>\n

Linux Server \u793a\u4f8b<\/p>\n

<VirtualHost *:80>
        ServerAdmin myuser@dc1es.tnc.edu.tw
        ServerName myuser.dc1es.tnc.edu.tw
        DocumentRoot \/home\/myuser\/public_html\/
        <Directory \/home\/myuser\/public_html\/>
                Options Indexes FollowSymLinks MultiViews
                AllowOverride None
                Order allow,deny
                allow from all
                AddType application\/x-httpd-php .php
        <\/Directory>
<\/VirtualHost><\/p>\n

\u555f\u52d5\u5404\u670d\u52d9<\/p>\n

    * root@dns:~# a2ensite myuser
    * root@dns:~# service bind9 restart
    * root@dns:~# service apache2 restart<\/p>\n

Apache2 \u8cc7\u5b89\u7ba1\u7406
\u7279\u5b9a\u7db2\u9801\u4e4b\u9023\u7dda\u9650\u5236<\/p>\n

\u82e5\u5b78\u6821\u6709\u4e9b\u7db2\u9801\u53ea\u9650\u6821\u5167 IP \u8b80\u53d6\uff08intranet\uff09\uff0c\u4f46\u53c8\u4e0d\u60f3\u53e6\u5916\u67b6\u4e00\u53f0\u7db2\u9801\u4f3a\u670d\u5668\uff0c\u9019\u6642\u53ef\u4ee5\u900f\u904e\u5c0d\u8cc7\u6599\u593e\u7684\u8b80\u53d6\u6b0a\u9650\u5236\u4f86\u9054\u6210\u6b64\u4e00\u76ee\u7684\u3002\u5176\u8a2d\u5b9a\u65b9\u5f0f\u53ef\u4ee5\u53c3\u8003 Linux Server \u4e0a ra-phpmyadmin \u4e4b\u53c3\u6578\u5beb\u6cd5\uff0c\u8a73\u898b\u4ee5\u4e0b\u8aaa\u660e\uff1a<\/p>\n

\u8a2d\u5b9a\u65b9\u5f0f<\/p>\n

    * \u8a2d\u5b9a\u4f4d\u7f6e\uff1a \/etc\/apache2\/conf.d
    * \u8209\u4f8b\u8aaa\u660e\uff1a \/etc\/apache2\/conf.d\/ra-phpmyadmin<\/p>\n

# \u8981\u9396\u7684\u8cc7\u6599\u593e, \u8209\u4f8b\u800c\u8a00 \/var\/www\/myweb –> \u8981\u5beb\u6210 <Location \/myweb>
<Location \/phpmyadmin>
  order deny,allow
  deny from all
  # \u53ef\u9023\u7dda\u5340, \u65b0\u589e\u6559\u7db2\u4e2d\u5fc3\u7db2\u6bb5
  allow from 127.0.0.1 163.26.182.0\/24 203.68.102.0\/24
  Options FollowSymLinks MultiViews
<\/Location><\/p>\n

\u7121\u6cd5\u9023\u7dda\u4e4b\u932f\u8aa4\u8a0a\u606f
Forbidden<\/p>\n

You don't have permission taccess \/phpmyadmin\/ on this server.
Apache\/2.2.9 (Debian) PHP\/5.2.6-1+lenny8 with Suhosin-Patch Server at 163.26.182.234 Port 80<\/p>\n

\u89e3\u9664\u65b9\u5f0f<\/p>\n

\u89e3\u9664\u7684\u65b9\u5f0f\u5f88\u7c21\u55ae\uff0c\u628a ra-phpmyadmin \u642c\u8d70\u5373\u53ef\uff0c\u505a\u6cd5\u5982\u4e0b\uff1a<\/p>\n

    * root@dns:~# mv \/etc\/apache2\/conf.d\/ra-phpmyadmin \/root<\/p>\n

    * root@dns:~# service apache2 restart<\/p>\n

    * \u8a3b\uff1a\u7d55\u5c0d\u4e0d\u53ef\u4ee5\u628a\u539f\u6a94\u6539\u500b\u540d\u5b57\u4ecd\u7559 conf.d \u8cc7\u6599\u593e\u5167\uff0c\u56e0\u70ba\u9019\u500b\u8cc7\u6599\u593e\u5167\u6240\u6709\u7684\u6a94\u6848\uff08\u7121\u8ad6\u6a94\u540d\u70ba\u4f55\uff09\u7686\u6703\u88ab\u57f7\u884c\u3002<\/p>\n

\u4e0a\u50b3\u5340\u7981\u6b62\u57f7\u884c Script \u8a9e\u8a00<\/p>\n

\u6709\u6642\u6703\u56e0\u4e00\u4e9b\u67b6\u7ad9\u8edf\u9ad4\u7684\u8981\u6c42\uff0c\u8981\u5efa\u7acb\u8cc7\u6599\u4e0a\u50b3\u5340\uff0c\u5982 \/var\/www\/uploads \uff0c\u800c\u4e14\u5176\u6a94\u6848\u6b0a\u9650\u5fc5\u9808\u662f\u7db2\u9801\u4f3a\u670d\u5668(www-data)\u53ef\u8b80\u53d6\uff08\u6216\u8a2d\u6210 777\uff09\u3002\u6b64\u6642\uff0c\u82e5\u6709\u5fc3\u4eba\u58eb\uff0c\u7121\u8ad6\u662f\u7d93\u7531\u5408\u6cd5\u624b\u6bb5\u6216\u900f\u904e PHP \u7a0b\u5f0f\u6f0f\u6d1e\uff0c\u628a *.php \u4e1f\u5230 uploads \uff0c\u518d\u7d93\u7531\u700f\u89bd\u5668\u57f7\u884c\uff0c\u9019\u6a23\u5c31\u6703\u7522\u751f\u8cc7\u5b89\u98a8\u96aa\u3002\u4f46\u5982\u679c\uff0c\u4e0d\u8b93 Apache2 \u4f3a\u670d\u5668\u5c0d uploads \u5e95\u4e0b\u7279\u5b9a\u985e\u578b script \u4e88\u4ee5\u89e3\u8b6f\u4e26\u57f7\u884c\u7684\u8a71\uff0c\u90a3\u9ebc\u6b64\u98a8\u96aa\u5c31\u53ef\u964d\u5230\u6700\u4f4e\u3002\u8a73\u7d30\u505a\u6cd5\u5982\u4e0b\uff1a<\/p>\n

    * \u5148\u78ba\u8a8d \/etc\/apache2\/sites-available\/default \u4e4b AllowOverride \u53c3\u6578\u6539\u70ba All\uff0c\u64f7\u53d6\u90e8\u5206\u5167\u5bb9\u5982\u4e0b<\/p>\n

    DocumentRoot \/var\/www
    <Directory \/>
        Options FollowSymLinks
        AllowOverride All
    <\/Directory>
    <Directory \/var\/www\/>
        Options FollowSymLinks MultiViews
        AllowOverride All
        Order allow,deny
        allow from all
    <\/Directory><\/p>\n

    * \u5efa\u7acb \/var\/www\/uploads\/.htaccess
      root@dns:~# vi \/var\/www\/uploads\/.htaccess \uff08\u5167\u5bb9\u793a\u4f8b\u5982\u4e0b\uff09<\/p>\n

<FilesMatch ".(php|php3|php4|php5|phtml|pl|py|sh|cgi)$">
deny from all
<\/FilesMatch><\/p>\n

    * \u8a3b\uff1a\u5f71\u97ff\u529b\u53ea\u9054 .htaccess \u6240\u5728\u4e4b\u8cc7\u6599\u593e<\/p>\n

    * \u6539 .htaccess \u6b0a\u9650\u70ba root \u6240\u6709\uff0c\u5176\u4ed6\u8eab\u4efd\u552f\u8b80\uff0c\u4ee5\u514d\u88ab\u4f7f\u7528\u8005\u4e0a\u50b3\u81ea\u5df1\u7684 .htaccess \u8986\u84cb
      root@dns:~# chown root.root \/var\/www\/uploads\/.htaccess
      root@dns:~# chmod 644 \/var\/www\/uploads\/.htaccess<\/p>\n

\u9396\u5bc6\u78bc\u7db2\u9801\u88fd\u4f5c<\/p>\n

\u5047\u8a2d\u6709\u500b\u8cc7\u6599\u593e\uff0c\u88e1\u9762\u7684\u7db2\u9801\u5177\u6709\u6a5f\u5bc6\u6027\uff0c\u53ea\u5141\u8a31\u7279\u5b9a\u4eba\u54e1\u767b\u5165\u5f8c\u624d\u53ef\u89c0\u770b\uff0c\u9019\u53ef\u4ee5\u900f\u904e .htaccess \u7684\u8a2d\u5b9a\u4f86\u5354\u52a9\u9054\u6210\u3002<\/p>\n

\u78ba\u8a8d AllowOverride \u53c3\u6578<\/p>\n

\u5982\u4e0a\u6587\u6240\u8a00\uff0c\u8981\u555f\u7528 .htaccess \u4e4b\u524d\uff0c\u8981\u5148\u78ba\u8a8d \/etc\/apache2\/sites-available\/default \u4e4b AllowOverride \u53c3\u6578\u662f\u5426\u70ba All \u3002<\/p>\n

\u5efa\u7acb .htaccess<\/p>\n

\u5047\u8a2d http:\/\/your.host.name\/topsecu\/ \u9019\u500b\u7db2\u5740\u662f\u8981\u5e33\u865f\u5bc6\u78bc\u8a8d\u8b49\uff0c\u90a3\u9ebc\u5176\u5728\u4e3b\u6a5f\u7684\u5be6\u9ad4\u4f4d\u7f6e\u70ba \/var\/www\/topsecu \uff0c\u56e0\u6b64\uff0c\u5fc5\u9808\u5728\u6b64\u8655\u5efa\u7acb .htaccess \uff0c\u5176\u5167\u5bb9\u793a\u4f8b\u5982\u4e0b\u3002<\/p>\n

    * root@dns:~# vi \/var\/www\/topsecu\/.htaccess<\/p>\n

AuthName "TopSecu"
AuthUserFile \/var\/passwords\/topsecu.pwd
AuthType Basic
Require valid-user<\/p>\n

    * AuthName \u7ad9\u540d
    * AuthUserFile \u5bc6\u78bc\u6a94
    * AuthType Basic \u57fa\u672c\u578b\u5f0f\u6388\u6b0a(\u4e0d\u5fc5\u5206\u7d44)
    * Require valid-user \u8981\u6709\u5e33\u865f<\/p>\n

\u5efa\u7acb\u5bc6\u78bc\u6a94<\/p>\n

    * \u7b2c\u4e00\u6b21\u5efa\u7acb
      root@dns:~# mkdir \/var\/passwords
      root@dns:~# htpasswd –c \/var\/passwords\/topsecu.pwd username
    * \u300c-c\u300d\u662f\u4f9b\u7b2c\u4e00\u6b21\u5efa\u7acb\u7528\uff0c\u82e5\u53ea\u662f\u4fee\u6539\u5bc6\u78bc\u6216\u65b0\u589e\u7b2c\u4e8c\u7d44\u5e33\u865f\u5bc6\u78bc\uff0c\u5c31\u4e0d\u5fc5\u518d\u52a0\u6b64\u53c3\u6578\u3002
    * \u7d93\u904e\u4e0a\u8ff0\u52d5\u4f5c\uff0c\u6703\u5efa\u7acb\u4e00\u7d44\u5e33\u865f\u70ba username \u7684\u8a8d\u8b49<\/p>\n

\u7db2\u9801\u7a0b\u5f0f PHP
\u57fa\u672c\u8a2d\u5b9a<\/p>\n

Apache2 \u662f\u7db2\u9801\u4f3a\u670d\u5668\uff0cPHP5\u7db2\u9801\u8a9e\u8a00\u662f\u4ee5 Apache2 \u6a21\u7d44\u7684\u5f62\u5f0f\u5b58\u5728\u3002\u56e0\u6b64\uff0c\u82e5\u6709\u4efb\u4f55\u8a2d\u5b9a\u8b8a\u66f4\uff0c\u53ea\u8981\u91cd\u65b0\u555f\u52d5 Apache2 \u5373\u53ef\u3002<\/p>\n

    * \u8a2d\u5b9a\u6a94\uff1a \/etc\/php5\/apache2\/php.ini<\/p>\n

PHP5 \u6a21\u7d44\u7ba1\u7406<\/p>\n

PHP5 \u7684\u6a21\u7d44\u5b89\u88dd\uff0f\u79fb\u9664\u8207 Apache2 \u505a\u6cd5\u4e00\u6a23\uff0c\u7686\u662f\u900f\u904e Debian \u7684 DEB \u5957\u4ef6\u5eab\u4f86\u8655\u7406\uff0c\u8209\u4f8b\u5982\u4e0b\uff1a<\/p>\n

    * \u6a21\u7d44\u641c\u5c0b
      root@dns:~# apt-cache search php5
    * \u6a21\u7d44\u5b89\u88dd
      root@dns:~# apt-get install php5-imagick
    * \u6a21\u7d44\u79fb\u9664
      root@dns:~# apt-get remove php5-imagick
    * \u6a21\u7d44\u7570\u52d5\u5f8c\uff0c\u5957\u7528\u8a2d\u5b9a
      root@dns:~# service apache2 restart<\/p>\n

\u52a0\u5927\u6a94\u6848\u4e0a\u50b3\u9650\u5236<\/p>\n

PHP \u9810\u8a2d\u6a94\u6848\u4e0a\u50b3\u9650\u5236\u70ba 2MB \uff0c\u9019\u5c0d\u5b78\u6821\u4f86\u8aaa\u5e38\u5e38\u4e0d\u5920\u7528\uff0c\u4e0d\u904e\u6211\u5011\u53ef\u4ee5\u900f\u904e php.ini \u7684\u4fee\u6539\uff0c\u4f86\u52a0\u5927\u4e0a\u50b3\u9650\u5236\u3002\u4e0d\u904e\u9019\u88e1\u7684\u4e0a\u50b3\u9650\u5236\u8207\u4f7f\u7528\u8005\u7db2\u8def\u7a7a\u9593\u9650\u5236\uff08Quota)\u7684\u610f\u7fa9\u4e0d\u540c\uff0c\u9019\u88e1\u662f\u6307\u7528 PHP \u5beb\u7684\u7db2\u7ad9\uff0c\u82e5\u6709\u4e0a\u50b3\u4ecb\u9762(\u5982 SFS3, XOOPS…\uff09\uff0c\u7121\u8ad6\u662f\u5716\u7247\u6216\u6a94\u6848\u4e4b\u4e0a\u50b3\u9650\u5236\u3002<\/p>\n

    * \u4fee\u6539 \/etc\/php5\/apahce2\/php.ini \uff0c\u4fee\u6539\u4e0b\u5217\u4e09\u500b\u53c3\u6578
      root@dns:~#: vi \/etc\/php5\/apache2\/php.ini<\/p>\n

;\u8a18\u61b6\u9ad4\u9650\u5236
memory_limit = 128M
;PHP \u8868\u55ae POST \u9650\u5236
post_max_size = 72M
;\u6a94\u6848\u5927\u5c0f\u9650\u5236
upload_max_filesize = 64M<\/p>\n

\u5176\u4ed6\u8a2d\u5b9a<\/p>\n

\u4ee5\u4e0b\u5169\u8005\u7686\u5df2\u662f\u9810\u8a2d\u503c\uff0c\u4e0d\u904e\u4ecd\u63d0\u51fa\u4ee5\u4f9b\u53c3\u8003<\/p>\n

    * \u6ce8\u610f php.ini \u5167\u7684 utf-8 \u6216 big5 \u7de8\u78bc\u554f\u984c<\/p>\n

;default_charset = "iso-8859-1"<\/p>\n

\u8a3b\uff1a\u52a0\u300c;\u300d\u8b8a\u6210\u8a3b\u89e3\uff0c\u624d\u53ef\u4ee5\u8b93 php \u9801\u9762\u81ea\u8a02\u8a9e\u7cfb<\/p>\n

    * \u82e5 php \u7a0b\u5f0f\u8981\u91cd\u9001 header (ex.\u5f37\u8feb\u8f49\u5740)\uff0c\u8acb\u6ce8\u610f<\/p>\n

output_buffering = 4096<\/p>\n

\u52a0\u901f PHP \u57f7\u884c<\/p>\n

    * Linux t1\uff5et3 \u53ef\u4ee5\u4f7f\u7528 APC \u52a0\u901f PHP \u57f7\u884c<\/p>\n

   1. root@dns:~# apt-get update
   2. root@dns:~# apt-get install php-pear
   3. root@dns:~# apt-get install php5-dev apache2-prefork-dev build-essential
   4. root@dns:~# pecl install apc
      \u51fa\u73fe Use apxs tset compile flags (if using APC with Apache)? [yes] : \u6642\uff0c\u6309\u300cEnter\u300d\u7e7c\u7e8c
   5. \u7de8\u8f2f \/etc\/php5\/apache2\/php.ini \uff0c\u52a0\u4e0a
      extension=apc.so
   6. \u91cd\u65b0\u555f\u52d5 Apache2
      root@dns:~# service apache2 restart<\/p>\n

    * Linux e1\uff5esqz \u53ef\u4ee5\u4f7f\u7528 Xcache \u52a0\u901f PHP \u57f7\u884c
          xcache \u7c21\u4ecb\uff1a\u5b83\u662f PHP \u904b\u7b97\u78bc(opcode)\u5feb\u53d6\u5668
          \u5b89\u88dd
            root@dns:~# apt-get install php5-xcache
          \u91cd\u65b0\u555f\u52d5 Apache2
            root@dns:~# service apache2 restart<\/p>\n

\u8cc7\u6599\u5eab MySQL<\/p>\n

Linux \u4e0a\u81ea\u7531\u8edf\u9ad4\u6388\u6b0a\u7684\u8cc7\u6599\u5eab\u76ee\u524d\u6709\u5169\u5927\u52e2\u529b\uff0c\u4e00\u662f MySQL \u53e6\u4e00\u662f PostgreSQL \uff0cLinux \u4e0a\u9810\u8f09\u7684\u662f MySQL \uff0c\u56e0\u6b64\u6211\u5011\u53ea\u91dd\u5c0d MySQL \u9032\u884c\u7c21\u6613\u8aaa\u660e\u3002<\/p>\n

    * \u91cd\u8981\u4e2d\u6587\u53c3\u8003\u6587\u4ef6\uff0cMySQL 5.1 \u4e2d\u6587\u624b\u518a\uff1ahttp:\/\/twpug.net\/docs\/mysql-5.1\/<\/p>\n

\u57fa\u672c\u89c0\u5ff5(\u5fc5\u8b80)<\/p>\n

    * \u4e3b\u8a2d\u5b9a\uff1a \/etc\/mysql\/my.cnf
    * \u958b\u555f\u57e0
          \u5c0d\u5916\uff1aTCP 3306
          \u5c0d\u672c\u6a5f\uff1a\u4e0d\u5fc5\u958b\u901a\u8a0a\u57e0
          \u8a3b\uff1a\u82e5 PHP \u7a0b\u5f0f\u78bc\u8207 MySQL Server \u4f4d\u65bc\u540c\u4e00\u53f0\u6a5f\u5668\uff0c\u53ef\u4ee5\u628a 3306 \u57e0\u95dc\u9589
    * \u8a18\u9304\u6a94\uff1a \/var\/log\/mysql.log
    * \u7cfb\u7d71\u8cc7\u6599\u5eab\uff1a \/var\/lib\/mysql\/mysql
          \u5404 MySQL \u7248\u672c\u7684\u7cfb\u7d71\u8cc7\u6599\u5eab\u683c\u5f0f\u4e0d\u4e00\u6a23\uff0c\u82e5\u932f\u7528\u6703\u5c0e\u81f4\u8cc7\u6599\u5eab\u7121\u6cd5\u555f\u52d5
          \u82e5\u6b64\u4e00\u8cc7\u6599\u5eab\u88ab\u8aa4\u522a\uff0c\u53ef\u7528 mysql_install_db \u6307\u4ee4\u5efa\u7acb
    * \u8cc7\u6599\u5eab\u4f4d\u7f6e\uff1a \/var\/lib\/mysql
    * \u8cc7\u6599\u5eab\u89e3\u8aaa
          \u5728 \/var\/lib\/mysql \u5167\u6bcf\u500b\u8cc7\u6599\u593e\u7686\u662f\u4e00\u7d44\u8cc7\u6599\u5eab
          \u8cc7\u6599\u593e\u53ca\u5176\u6a94\u6848\u4e4b\u64c1\u6709\u8005\u70ba mysql.mysql
          \u8cc7\u6599\u593e\u5167\u540c\u540d\u5b57\u4e4b\u4e09\u500b\u6a94\u6848\u7d44\u6210\u4e00\u500b\u8cc7\u6599\u8868
            *.frm –> \u6b04\u4f4d\u5b9a\u7fa9
            *.MYD –> \u5be6\u9ad4\u8cc7\u6599
            *.MYI –> \u8cc7\u6599\u7d22\u5f15<\/p>\n

MySQL \u7ba1\u7406
MySQL\u7cfb\u7d71\u7ba1\u7406<\/p>\n

    * \u95dc\u65bc MySQL \u7ba1\u7406\u5e7e\u500b\u57fa\u672c\u89c0\u5ff5
          MySQL \u6709\u81ea\u5df1\u7684\u5e33\u865f\u5bc6\u78bc
          MySQL \u6700\u9ad8\u6b0a\u9650\u5e33\u865f\u8207 Linux \u4e00\u6a23\u662f root \uff0c\u4f46\u5bc6\u78bc\u4e0d\u540c\uff08\u9664\u975e\u8a2d\u6210\u4e00\u6a23\uff09
          MySQL \u7684\u5e33\u865f\u5bc6\u78bc\u662f\u7d66\u7db2\u9801\u7a0b\u5f0f\u78bc(ex. php)\u9023\u7dda\u7528\uff0c\u4f7f\u7528\u8005\u4f7f\u7528\u7684\u6a5f\u6703\uff0c\u53ea\u50c5\u9650 phpmyadmin \u9023\u7dda\u6642\u624d\u6703\u9700\u8981
          Linux \u4e0a\u6240\u8a2d\u5b9a\u7684\u7ba1\u7406\u5bc6\u78bc(Linux-csetup-utf8)\u5c31\u662f MySQL \u7684 root \u5bc6\u78bc<\/p>\n

    * \u555f\u52d5\/\u95dc\u9589\/\u91cd\u65b0\u555f\u52d5
      root@dns:~# service mysql start|stop|restart<\/p>\n

    * \u521d\u59cb\u5316\u7cfb\u7d71\u8cc7\u6599\u5eab
      root@dns:~# mysql_install_db
      \u8a3b\uff1a\u672c\u529f\u80fd\u50c5\u9650 \/var\/lib\/mysql\/mysql \u5df2\u88ab\u8aa4\u522a\u7684\u60c5\u6cc1\u4e0b\u624d\u53ef\u4ee5\u4f7f\u7528<\/p>\n

    * \u521d\u8a2d MySQL root \u5bc6\u78bc
      root@dns:~# mysqladmin -u root -p password
      \u8a3b\uff11\uff1a\u8f38\u5165 Linux root \u5bc6\u78bc\u5f8c\u5373\u624d\u53ef\u7e7c\u7e8c\u8f38\u5165 MySQL \u5bc6\u78bc
      \u8a3b\uff12\uff1aLinux \u672c\u52d5\u4f5c\u4e0d\u5fc5\u505a\uff0c\u56e0\u70ba Linux-csetup-utf8 \u5df1\u5e6b\u5fd9\u8655\u7406\u904e\u4e86\u3002<\/p>\n

    * \u4fee\u5fa9\u8cc7\u6599\u8868\u7d22\u5f15
      root@dns:~# mysqlcheck -u root -p -f \u8cc7\u6599\u5eab\u540d \u8cc7\u6599\u8868\u540d<\/p>\n

\u5fd8\u8a18 MySQL \u5bc6\u78bc<\/p>\n

    * \u65b9\u6cd5\u4e00\uff1a\u57f7\u884c Linux-csetup-utf8\uff0c\u91cd\u8a2d\u7ba1\u7406\u5bc6\u78bc
      \u6ce8\u610f\uff1a\u5b83\u9664\u4e86\u6703\u5e6b\u60a8\u91cd\u8a2d\u5bc6\u78bc\u5916\uff0c\u4e5f\u6703\u984d\u5916\u91cd\u8a2d\u8a31\u591a\u8a2d\u5b9a\uff0c\u56e0\u6b64\u4e0d\u592a\u5efa\u8b70\u4f7f\u7528\u6b64\u65b9\u6cd5\u3002
    * \u65b9\u6cd5\u4e8c\uff1a\u76f4\u63a5\u4f7f\u7528 MySQL \u5de5\u5177\u91cd\u8a2d<\/p>\n

   1. \u505c\u6b62 MySQL
      root@dns:~# service mysql stop
   2. \u5efa\u7acb \/root\/newpwd.txt
      root@dns:~# vi \/root\/newpwd.txt<\/p>\n

      SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');<\/p>\n

   3. \u555f\u52d5 MySQL
      root@dns:~# mysqld_safe –init-file=\/root\/newpwd.txt &
   4. \u95dc\u9589 MySQL
      root@dns:~# service mysql stop
   5. \u522a\u9664 newpwd.txt
      root@dns:~# rm -rf \/root\/newpwd.txt
   6. \u555f\u52d5 MySQL
      root@dns:~# service mysql start
      \u8a3b\uff1a\u91cd\u65b0\u555f\u52d5\u5f8c MySQL root \u5bc6\u78bc\u5df2\u88ab\u91cd\u8a2d<\/p>\n

\u8cc7\u6599\u5eab\u7ba1\u7406<\/p>\n

\u6574\u500b\u8cc7\u6599\u5eab\u7ba1\u7406\uff0c\u5efa\u8b70\u4f7f\u7528 phpmyadmin \u7db2\u9801\u5de5\u5177\uff0c\u7c21\u4ecb\u5982\u4e0b\uff1a<\/p>\n

    * phpmyadmin \u5b89\u88dd
      root@dns:~# apt-get update
      root@dns:~# apt-get install phpmyadmin
      \u8a3b\uff1a\u5927\u591a\u6578\u7684 Linux \u591a\u5df2\u5b89\u88dd\u6b64\u5957\u4ef6<\/p>\n

    * phpmyadmin \u4f7f\u7528\uff1a\u76f4\u63a5\u4f7f\u7528\u7db2\u9801\u700f\u89bd\u5668\uff0c\u9023\u7d50\u81f3 phpmyadmin \u7db2\u7ad9\u5373\u53ef
      \u8209\u4f8b\uff1ahttp:\/\/your.host.name\/phpmyadmin
      \u9023\u7dda\u5f8c\uff0c\u4ee5 MySQL \u7684\u5e33\u865f\u5bc6\u78bc\u9032\u5165
          \u53ea\u6709\u7528 root \u767b\u5165\uff0c\u624d\u6703\u6709\u5168\u90e8\u529f\u80fd
          \u53ef\u4ee5\u900f\u904e GRANT \u8a9e\u6cd5\uff0c\u5efa\u7acb\u7279\u5b9a\u5e33\u865f\uff0c\u800c\u5b83\u53ea\u80fd\u638c\u63a7\u55ae\u4e00\u8cc7\u6599\u5eab(\u8a73\u898b\u672c\u6587\uff1a\u5efa\u7acb\u865b\u64ec\u7ad9\u53f0\u6bb5\u843d)<\/p>\n

    * \u8cc7\u6599\u5eab\u642c\u5bb6
          Linux \u7cfb\u5217 Server \u4e4b MySQL \u8cc7\u6599\u5eab\u7686\u5728 \/var\/lib\/mysql
          \u53ea\u8981\u4e0b\u6307\u4ee4\u628a \/var\/lib\/mysql \u5e95\u4e0b\u4e4b\u8cc7\u6599\u5eab(\u593e)\u8907\u88fd\u81f3\u65b0\u4e3b\u6a5f\u76f8\u540c\u4e4b\u4f4d\u7f6e\uff0c\u4e26\u4fee\u6539\u6b0a\u9650\u64c1\u6709\u8005\u70ba mysql \u5373\u53ef\u5b8c\u6210\u642c\u79fb\u4efb\u52d9\u3002\u4ee5 sfs3 \u8cc7\u6599\u5eab\u70ba\u4f8b\uff0c\u505a\u6cd5\u5982\u4e0b\uff1a
         1. \u8907\u88fd
            root@dns:~# scp root@your.old.host:\/var\/lib\/mysql\/sfs3 \/var\/lib\/mysql
         2. \u4fee\u6539\u64c1\u6709\u8005
            root@dns:~# chown -R mysql.mysql \/var\/lib\/mysql\/sfs3<\/p>\n","protected":false},"excerpt":{"rendered":"

\u7db2\u9801&\u8cc7\u6599\u5eab  Linux\u4e3b\u6a5f\u670d\u52d9\uff08Linux\u4e3b\u6a5f\u4f3a\u670d\u5668\u67b6\u8a2d\u6280\u8853\uff09 Linux \u4e0a\u9810\u8f09\u4e4b\u7db2\u9801 […]<\/p>\n","protected":false},"author":1,"featured_media":499,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[20],"class_list":["post-42","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-15","tag-linux"],"_links":{"self":[{"href":"https:\/\/por.tw\/linux\/wp-json\/wp\/v2\/posts\/42"}],"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=42"}],"version-history":[{"count":0,"href":"https:\/\/por.tw\/linux\/wp-json\/wp\/v2\/posts\/42\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/por.tw\/linux\/wp-json\/wp\/v2\/media\/499"}],"wp:attachment":[{"href":"https:\/\/por.tw\/linux\/wp-json\/wp\/v2\/media?parent=42"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/por.tw\/linux\/wp-json\/wp\/v2\/categories?post=42"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/por.tw\/linux\/wp-json\/wp\/v2\/tags?post=42"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}