{"id":5276,"date":"2002-04-17T05:56:39","date_gmt":"2002-04-16T20:56:39","guid":{"rendered":"https:\/\/sonlab.mycafe24.com\/wp\/%ea%b2%8c%ec%8b%9c%ed%8c%90%ec%97%90-%ec%82%ac%ec%9a%a9%eb%90%a0-mysql-db-%ed%85%8c%ec%9d%b4%eb%b8%94-%eb%a7%8c%eb%93%a4%ea%b8%b0\/"},"modified":"2002-04-17T05:56:39","modified_gmt":"2002-04-16T20:56:39","slug":"%ea%b2%8c%ec%8b%9c%ed%8c%90%ec%97%90-%ec%82%ac%ec%9a%a9%eb%90%a0-mysql-db-%ed%85%8c%ec%9d%b4%eb%b8%94-%eb%a7%8c%eb%93%a4%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/sonbm.com\/wp\/%ea%b2%8c%ec%8b%9c%ed%8c%90%ec%97%90-%ec%82%ac%ec%9a%a9%eb%90%a0-mysql-db-%ed%85%8c%ec%9d%b4%eb%b8%94-%eb%a7%8c%eb%93%a4%ea%b8%b0\/","title":{"rendered":"\uac8c\uc2dc\ud310\uc5d0 \uc0ac\uc6a9\ub420 MySQL DB \ud14c\uc774\ube14 \ub9cc\ub4e4\uae30"},"content":{"rendered":"

\uc9c0\ub09c \uc2dc\uac04\uc5d0 \uae00 \uc785\ub825 \ud3fc\uc744 \uc644\uc131\ud558\uc600\uc2b5\ub2c8\ub2e4.
\n\uc774\ubc88 \uc2dc\uac04\uc5d0\ub294 \uae00 \uc785\ub825 \ud3fc\uc5d0\uc11c \uc785\ub825\ud55c \uae00\uc744 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc785\ub825\ud558\uae30 \uc704\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \ud14c\uc774\ube14\uc744 \ub9cc\ub4dc\ub294 \uc791\uc5c5\uc744 \ud569\ub2c8\ub2e4.
\n\uc2e4\uc2b5\uc758 \ud3b8\uc758\ub97c \uc704\ud574 \uc0ac\uc6a9\uc790 \uc774\ub984, \uc554\ud638, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc774\ub984, \ud14c\uc774\ube14 \uc774\ub984\uc744 \ubcf8\ubb38 \uc2e4\uc2b5 \ub0b4\uc6a9\uacfc \ub3d9\uc77c\ud558\uac8c \ub9cc\ub4e4\uc5b4 \uc8fc\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.
\n
\n\uadf8\ub9bc\uacfc \ub530\ub77c\ud558\uae30 \ub0b4\uc6a9\uc774 \uc870\uae08 \ub9ce\uae30 \ub54c\ubb38\uc5d0 \uc790\uc138\ud55c \uc124\uba85\uc740 \uc0dd\ub7b5\ud558\uaca0\uc2b5\ub2c8\ub2e4.
\n \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub300\ud55c \ubcf4\ub2e4 \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \uc624\ub77c\ud074(\ub370\uc774\ud130\ubca0\uc774\uc2a4) \uc785\ubb38 \uac15\uc88c<\/b><\/a>\uc5d0\uc11c \uc790\uc138\ud558\uac8c \uc124\uba85\ud558\uace0 \uc788\uc73c\ub2c8 \ucc38\uc870\ud558\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.<\/font><\/p>\n

\uba3c\uc800 \uc774\ubc88 \uc2dc\uac04\uc5d0 \ub9cc\ub4e4 \ud14c\uc774\ube14\uc758 \uad6c\uc870\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.
\n<\/p>\n

    \n
  1. \uc6f9\ube0c\ub77c\uc6b0\uc800 \uc8fc\uc18c \ud45c\uc2dc\uc904\uc5d0 http:\/\/localhost\/apmsetup\/<\/b>\ub97c \uc785\ub825\ud569\ub2c8\ub2e4.
    \n\ub9c8\uc9c0\ub9c9\uc5d0 \uc2ac\ub798\uc2dc(\/)\ub97c \uaf2d \uc368\uc57c \ud569\ub2c8\ub2e4.<\/p>\n
  2. \uc0c1\ub2e8 \uba54\ub274\uc5d0\uc11c phpMyAdmin(MySQL \uad00\ub9ac)<\/b>\ub97c \ud074\ub9ad\ud569\ub2c8\ub2e4.
    \n<\/p>\n
  3. \ub124\ud2b8\uc6cc\ud06c \uc554\ud638 \uc785\ub825 \ucc3d\uc5d0\uc11c [\uc0ac\uc6a9\uc790 \uc774\ub984]\ub780\uc5d0\ub294 root<\/b>, [\uc554\ud638]\ub780\uc5d0\ub294 \uadf8\ub0e5 \uc5d4\ud130\ub97c \uce69\ub2c8\ub2e4.
    \n\ub85c\uadf8\uc778\ud55c \ub2e4\uc74c \ub098\ud0c0\ub098\ub294 \uba54\uc778 \ud654\uba74\uc744 \uc790\uc138\ud788 \ubcf4\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \ubb38\uc7a5\uc774 \ubcf4\uc785\ub2c8\ub2e4.
    \nMySQL 3.23.46-max-debug \uac00 \uc2e4\ud589\uc911\uc785\ub2c8\ub2e4. localhost:3306 as root@localhost<\/b>
    \n\ubc14\ub85c localhost\uc5d0 root\ub85c \ub85c\uadf8\uc778\ud588\ub2e4\ub294 \ub73b\uc785\ub2c8\ub2e4.<\/p>\n
  4. \uc0c8\ub85c\uc6b4 \uc0ac\uc6a9\uc790\ub97c \ub4f1\ub85d\ud558\uae30 \uc704\ud574 Users<\/b>\ub97c \ud074\ub9ad\ud569\ub2c8\ub2e4.
    \n<\/p>\n
  5. \uc544\ub798 \uadf8\ub9bc\uacfc \uac19\uc774 [\ud638\uc2a4\ud2b8]\ub780\uc5d0\ub294 localhost<\/b>, [User name]\ub780\uc5d0\ub294 phpbbs<\/b>, [Password]\ub780\uc5d0\ub3c4 phpbbs<\/b>\ub97c \uc785\ub825\ud569\ub2c8\ub2e4.
    \n[Privileges] \uc120\ud0dd \ud56d\ubaa9\uc5d0\uc11c\ub294 Check All<\/b>\uc744 \ud074\ub9ad\ud558\uc5ec \ubaa8\ub450 \uc120\ud0dd\ud569\ub2c8\ub2e4.
    \n\ub9c8\uc9c0\ub9c9\uc73c\ub85c [\uc2e4\ud589] \ub2e8\ucd94\ub97c \ud074\ub9ad\ud574\uc11c \uc704\uc640 \uac19\uc740 \uc0ac\uc6a9\uc790\ub97c \ub4f1\ub85d\ud569\ub2c8\ub2e4.
    \n<\/p>\n
  6. \uc88c\uce21 \uba54\ub274\uc5d0\uc11c Main Page<\/b>\ub97c \ud074\ub9ad\ud558\uace0 \ubcf8\ubb38 \uc911\uac04\uc5d0\uc11c \ub85c\uadf8 \uc544\uc6c3<\/b> \ud56d\ubaa9\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4.
    \n\uc0c8\ub86d\uac8c \ub098\ud0c0\ub098\ub294 \ub124\ud2b8\uc6cc\ud06c \uc554\ud638 \uc785\ub825 \ucc3d\uc5d0\uc11c [\uc0ac\uc6a9\uc790 \uc774\ub984]\ub780\uc5d0\ub294 phpbbs<\/b>, [\uc554\ud638]\ub780\uc5d0\ub3c4 phpbbs<\/b>\ub97c \uc785\ub825\ud558\uace0 [\ud655\uc778]\uc744 \ub204\ub985\ub2c8\ub2e4.<\/p>\n
      \n
    • Windows2000\uc5d0\uc11c\ub294 \uc815\uc0c1\uc801\uc73c\ub85c \ub85c\uadf8\uc778\ub420 \uac83\uc785\ub2c8\ub2e4.\n
    • Windows98\uc5d0\uc11c\ub294 \ub85c\uadf8\uc778\ub418\uc9c0 \uc54a\uc744 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub54c\ub294 [\ucde8\uc18c]\ub97c \ub20c\ub7ec \uc554\ud638 \uc785\ub825 \ub300\ud654\uc0c1\uc790\ub97c \ub2eb\uace0, APM_setup\uc744 \uc7ac\uc2e4\ud589\ud558\uc5ec\uc57c \ud569\ub2c8\ub2e4.<\/ul>\n
    • phpbbs<\/b>\ub85c \ub85c\uadf8\uc778\ud558\uba74 \ubcf8\ubb38\uc5d0 phpbbs@localhost<\/b>\uac00 \ubcf4\uc785\ub2c8\ub2e4.
      \n\uc0c8\ub85c\uc6b4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ub9cc\ub4e4\uae30 \uc704\ud574, \uc785\ub825\ub780\uc5d0 itmembers<\/b>\ub97c \uc785\ub825\ud558\uace0 [\ub9cc\ub4e4\uae30] \ub2e8\ucd94\ub97c \ud074\ub9ad\ud569\ub2c8\ub2e4.
      \n<\/p>\n
    • itmembers \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc0c8\ub85c\uc6b4 \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uae30 \uc704\ud574, \uc544\ub798\uc640 \uac19\uc774
      \n[\uc774\ub984] \uc785\ub825\ub780\uc5d0 bbs<\/b>, [\ud544\ub4dc] \uc785\ub825\ub780\uc5d0 10<\/b>\uc744 \uc785\ub825\ud558\uace0 [\uc2e4\ud589] \ub2e8\ucd94\ub97c \ud074\ub9ad\ud569\ub2c8\ub2e4.
      \n<\/p>\n
    • \uc544\ub798\uc640 \uac19\uc774 \ud544\ub4dc, \ud544\ub4dc \ud0c0\uc785, \uae38\uc774, \ubcf4\uae30, \ucd94\uac00, Primary \ud56d\ubaa9\uc744 \uc785\ub825\ud558\uac70\ub098 \uc120\ud0dd\ud55c \ub2e4\uc74c [\ubcf4\uc874] \ub2e8\ucd94\ub97c \ub204\ub985\ub2c8\ub2e4.
      \n<\/p>\n
    • \uc544\ub798\uc640 \uac19\uc740 \ud654\uba74\uc774 \ub098\uc624\uba74 \uc815\uc0c1\uc801\uc73c\ub85c \uc218\ud589\uc774 \ub41c \uac83\uc785\ub2c8\ub2e4.
      \n<\/p>\n

      \ubcf8\ubb38 \uc911\uc5d0 \uc2e4\ud589\ub41c SQL \ucffc\ub9ac<\/b>\ub77c\ub294 \uac83\uc774 \ubcf4\uc774\uc8e0?
      \nCREATE TABLE ‘bbs’\ub85c \uc2dc\uc791\ud558\ub294 SQL \ubb38\uc7a5\uc774 \ubcf4\uc774\ub294\ub370, \uc774 \ubb38\uc7a5\uc744 \uc704\uc758 8\ubc88 \ub2e8\uacc4\uc758 [Run SQL query] \uc785\ub825\ub780\uc5d0 \uc9c1\uc811 \uc785\ub825\ud55c \ub2e4\uc74c \uc2e4\ud589\ud574\ub3c4 \uc9c0\uae08\uacfc \uac19\uc740 bbs \ud14c\uc774\ube14\uc774 \ub9cc\ub4e4\uc5b4\uc9d1\ub2c8\ub2e4.
      \nSQL\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \uc124\uba85\uc740 \uc624\ub77c\ud074 \uac15\uc88c\ub97c \ucc38\uc870\ud574 \uc8fc\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.<\/ol>\n

      \uc774\uc0c1 \uc218\uc694\uc77c \uc0c8\ubcbd, \ub3d9\uc8fc \uc544\ube60 \uc190\ubcd1\ubaa9\uc774\uc5c8\uc2b5\ub2c8\ub2e4.
      \n<\/p>\n","protected":false},"excerpt":{"rendered":"

      \uc9c0\ub09c \uc2dc\uac04\uc5d0 \uae00 \uc785\ub825 \ud3fc\uc744 \uc644\uc131\ud558\uc600\uc2b5\ub2c8\ub2e4. \uc774\ubc88 \uc2dc\uac04\uc5d0\ub294 \uae00 \uc785\ub825 \ud3fc\uc5d0\uc11c \uc785\ub825\ud55c \uae00\uc744 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc785\ub825\ud558\uae30 \uc704\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \ud14c\uc774\ube14\uc744 \ub9cc\ub4dc\ub294 \uc791\uc5c5\uc744 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[77],"tags":[78,79,80,81,28,82],"class_list":["post-5276","post","type-post","status-publish","format-standard","hentry","category-php1","tag-it","tag-php","tag-80","tag-81","tag-28","tag-82"],"_links":{"self":[{"href":"http:\/\/sonbm.com\/wp\/wp-json\/wp\/v2\/posts\/5276","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/sonbm.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/sonbm.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/sonbm.com\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/sonbm.com\/wp\/wp-json\/wp\/v2\/comments?post=5276"}],"version-history":[{"count":0,"href":"http:\/\/sonbm.com\/wp\/wp-json\/wp\/v2\/posts\/5276\/revisions"}],"wp:attachment":[{"href":"http:\/\/sonbm.com\/wp\/wp-json\/wp\/v2\/media?parent=5276"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/sonbm.com\/wp\/wp-json\/wp\/v2\/categories?post=5276"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/sonbm.com\/wp\/wp-json\/wp\/v2\/tags?post=5276"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}