{"id":6142,"date":"2024-04-21T16:58:50","date_gmt":"2024-04-21T16:58:50","guid":{"rendered":"https:\/\/pohang.eduwp.kr\/?p=6142"},"modified":"2026-04-20T04:31:04","modified_gmt":"2026-04-20T04:31:04","slug":"9%ec%a3%bc%ec%b0%a8-2","status":"publish","type":"post","link":"https:\/\/pohang.eduwp.kr\/?p=6142","title":{"rendered":"9\uc8fc\ucc28 \uc6f9\uc11c\ubc84, DB\uc11c\ubc84 \uc124\uce58\ud558\uae30"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_81 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"\ubaa9\ucc28 \ud1a0\uae00\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/pohang.eduwp.kr\/?p=6142\/#%EC%9B%B9%EC%84%9C%EB%B2%84_DB%EC%84%9C%EB%B2%84_%EC%84%A4%EC%B9%98%ED%95%98%EA%B8%B0\" >\uc6f9\uc11c\ubc84, DB\uc11c\ubc84 \uc124\uce58\ud558\uae30<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/pohang.eduwp.kr\/?p=6142\/#%EC%95%84%ED%8C%8C%EC%B9%98%EC%9B%B9%EC%84%9C%EB%B2%84_%EC%84%A4%EC%B9%98\" >\uc544\ud30c\uce58\uc6f9\uc11c\ubc84 \uc124\uce58<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/pohang.eduwp.kr\/?p=6142\/#DB%EC%84%9C%EB%B2%84_%EC%84%A4%EC%B9%98%ED%95%98%EA%B8%B0_mariadb\" >DB\uc11c\ubc84 \uc124\uce58\ud558\uae30\u00a0 (mariadb)<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%EC%9B%B9%EC%84%9C%EB%B2%84_DB%EC%84%9C%EB%B2%84_%EC%84%A4%EC%B9%98%ED%95%98%EA%B8%B0\"><\/span>\uc6f9\uc11c\ubc84, DB\uc11c\ubc84 \uc124\uce58\ud558\uae30<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"%EC%95%84%ED%8C%8C%EC%B9%98%EC%9B%B9%EC%84%9C%EB%B2%84_%EC%84%A4%EC%B9%98\"><\/span>\uc544\ud30c\uce58\uc6f9\uc11c\ubc84 \uc124\uce58<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">#apt -y install apache2\r\n\r\n#systemctl restart apache2\r\n\r\n#systemctl status apache2\r\n\r\n#systemctl enable apache2<\/pre>\n<p>\uc544\ud30c\uce58\ub97c \uc124\uce58\ud558\uba74 \uae30\ubcf8\uc801\uc73c\ub85c\u00a0 \/etc\/apache2\/\u00a0 \ud3f4\ub354\uc5d0 \uc124\uce58\ub418\uba70 apache2.conf\ud30c\uc77c\uc5d0 \uc124\uc815\uac12\uc774 \uc874\uc7ac\ud55c\ub2e4.<\/p>\n<p>\uc11c\ubc84\uc758 \ub8e8\ud2b8 \ud3f4\ub354\uc640 \uac01\uc885 \uc124\uc815\uac12\uc774 \uc9c0\uc815\ub418\uc5b4 \uc788\ub2e4.<\/p>\n<p>\uc6f9\uc11c\ubc84 \ub8e8\ud2b8\ud3f4\ub354<\/p>\n<p>\/var\/www\/html<\/p>\n<p>\ud3f4\ub354\uc5d0 index.html\u00a0 \uc0dd\uc131\ud574\uc11c \ube0c\ub77c\uc6b0\uc800\uc5d0\uc11c \ud655\uc778\ud558\uae30<\/p>\n<p>\ube0c\ub77c\uc6b0\uc800\uc5d0 127.0.0.1\uc744 \uc785\ub825\ud55c\ub2e4.<\/p>\n<hr \/>\n<p>\uac04\ub2e8\ud55c phpinfo \ubb38\uc11c\ub97c \ub9cc\ub4e4\uc5b4\uc11c php \uad6c\ubb38\uc774 \uc815\uc0c1\uc791\ub3d9\ud558\ub294\uc9c0 \ud655\uc778\ud55c\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"DB%EC%84%9C%EB%B2%84_%EC%84%A4%EC%B9%98%ED%95%98%EA%B8%B0_mariadb\"><\/span>DB\uc11c\ubc84 \uc124\uce58\ud558\uae30\u00a0 (mariadb)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>mysql\uacfc mariadb\uc911 \ucd5c\uadfc\uc5d0\ub294 mariadb\ub97c \ub354 \ub9ce\uc774 \uc0ac\uc6a9\ud558\ub294 \ucd94\uc138\uc774\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">#apt -y install mariadb-server mariadb-client\u00a0 (\uc11c\ubc84\uc640 \ud074\ub77c\uc774\uc5b8\ud2b8 2\uac1c\ub97c \uc124\uce58\ud55c\ub2e4.)\r\n\r\n#systemctl restart mariadb\r\n\r\n#systemctl status mariadb\r\n\r\n#systemctl enable mariadb\r\n\r\n#ufw allow 3306 (\ubc29\ud654\ubcbd \uc5f4\uae30)<\/pre>\n<p>&nbsp;<\/p>\n<p>#mysql\u00a0 \uc785\ub825\ud574\uc11c db\ud504\ub85c\uadf8\ub7a8\uc774 \uc791\ub3d9\ud558\ub294\uc9c0 \ud655\uc778\ud6c4 exit \ube60\uc838\ub098\uc624\uae30<\/p>\n<p>&nbsp;<\/p>\n<p>mariadb\uc758 \ub8e8\ud2b8 \ud328\uc2a4\uc6cc\ub4dc \uc785\ub825\ud558\uae30<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">#mysqladmin -u root -p '\ud328\uc2a4\uc6cc\ub4dc'\u00a0 \u00a0(db\uc804\uc6a9 root \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc9c0\uc815\ud55c\ub2e4. \uac04\ub2e8\ud558\uac8c 1234\ub85c \uc9c0\uc815)\r\n\r\n#mysql \uc744 \uc785\ub825\ud558\uba74 \ub85c\uadf8\uc778\uc774 \uc548\ub428\r\n\r\n#mysql -u root -p (\uc5d4\ud130\ub97c \uc785\ub825\ud558\uba74 \ud328\uc2a4\uc6cc\ub4dc\ub97c \ubb3c\uc5b4\ubd04)<\/pre>\n<p>&nbsp;<\/p>\n<p>\uc124\uc815\ubcc0\uacbd<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">#nano \/etc\/mysql\/mariadb.conf.d\/50-server.cnf<\/pre>\n<p>\ub0b4\uc6a9 \uc911<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"abap\">#bind -address\u00a0 \u00a0 \u00a0=\u00a0 \u00a0127.0.0.1 (\uc8fc\uc11d\ucc98\ub9ac\ud55c\ub2e4.)<\/pre>\n<p>&nbsp;<\/p>\n<p>\ud55c\ubc88\uc5d0 \uc124\uce58\ud558\ub294 \uba85\ub839\uc5b4\uac00 \uc874\uc7ac\ud55c\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">#apt -y install lamp-server^<\/pre>\n<p>mysql \uc5d0\uc11c wp_db \ub97c \uc0dd\uc131\ud558\uace0 \uc0ac\uc6a9\uc790\ub3c4 \uc0dd\uc131\ud55c\ub2e4.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">#mysql\u00a0\r\n\r\nmysql &gt; create database wp_db;\r\n\r\nmysql &gt; create user wp_user@localhost identified by '1234';\r\n\r\nmysql &gt; grant all on wp_db.* to wp_user@localhost;<\/pre>\n<p>&nbsp;<\/p>\n<p>\uc6cc\ub4dc\ud504\ub808\uc2a4\ub97c \ub2e4\uc6b4\ubc1b\uace0 \uc555\ucd95\uc744 \ud47c \ud6c4 \/var\/www\/html \ud3f4\ub354\uc5d0 \uc774\ub3d9\ud55c\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>\uc6cc\ub4dc\ud504\ub808\uc2a4 \ub2e4\uc6b4 \uacbd\ub85c \ucc3e\uae30 (\uc0ac\uc774\ud2b8\uc5d0 \uc811\uc18d\ud574\uc11c \uc8fc\uc18c \ucc3e\uae30)<\/p>\n<p>tar \uc555\ucd95 \ud480\uae30<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">#tar -zxvf \ud30c\uc77c\uba85\r\n\r\n#mv \uba85\ub839\uc5b4\ub85c \ud3f4\ub354 \uc774\ub3d9\ud558\uae30\r\n\r\n#chmod 707 wordpress\u00a0 \uad8c\ud55c \ud480\uae30\r\n\r\n#chown -R www-data.www-data wordpress\u00a0 \u00a0(\uc18c\uc720\uc8fc\ub97c \uc6f9\uc0ac\uc774\ud2b8\uc5d0 \uc811\uc18d\ud558\ub294 \uc0ac\ub78c\uc73c\ub85c \ubcc0\uacbd)<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>\uc6cc\ub4dc\ud504\ub808\uc2a4\uc758 db\uc815\ubcf4 \ubcc0\uacbd<\/p>\n<p>wp-config-sample.php\ud30c\uc77c\uc744 wp-config.php \ubcf5\uc0ac\ud558\uace0 \uc815\ubcf4\ub97c \uc785\ub825\ud55c\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>\ucd08\uae30 \uacbd\ub85c\ub97c \ubcc0\uacbd\ud558\uae30<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">#nano \/etc\/apache2\/sites-enables\/000-default.conf \uc5f4\uc5b4\uc11c \ucd08\uae30 \ud3f4\ub354\ub97c \uc9c0\uc815\ud55c\ub2e4.<\/pre>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">ServerAdmin webmaster@localhost \uc544\ub798\uc904\uc5d0\r\n\r\nDocumentRoot \/var\/www\/html\/wordpress \ub85c \uc218\uc815<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">#gedit \/etc\/apache2\/apache2.conf<\/pre>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">&lt;Directory \/var\/www\/wordpress&gt;\r\n\u00a0 \u00a0 \u00a0Options Indexes FollowSymLinks\r\n     AllowOverride All\r\n     Require all granted\r\n&lt;\/Directory&gt;<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>\ub0b4\uc6a9 \uc218\uc815 , \uacbd\ub85c \ucd94\uac00 \/ \ubcf5\uc0ac\ud574\uc11c \ubd99\uc774\uae30<\/p>\n<p>\uc6f9\ube0c\ub77c\uc6b0\uc800\uc5d0\uc11c \uc124\uce58\ud558\uae30, wp-config.php \uc5c6\uc774 \uc124\uce58\uac00 \uac00\ub2a5\ud55c \ubd80\ubd84 \ube44\uad50\ud558\uae30<\/p>\n<p>&nbsp;<\/p>\n<hr \/>\n<p>\uc624\ub958\uac00 \ubc1c\uc0dd\ud560\ub54c \uc5c5\ub370\uc774\ud2b8 2\ubc88 \uc2e4\ud589<\/p>\n<p>#apt-get update<\/p>\n<p>#apt-get upgrade<\/p>\n<hr \/>\n<p>\uc6cc\ub4dc\ud504\ub808\uc2a4 \uacbd\ub85c<\/p>\n<p>&nbsp;<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">#wget https:\/\/ko.wordpress.org\/latest-ko_KR.zip\r\n#wget https:\/\/ko.wordpress.org\/wordpress-6.5.3-ko_KR.tar.gz\r\n\r\n\r\n#unzip -q latest-ko_KR.zip\r\n\r\n#tar -xvfz wordpress-6.5.3-ko_KR.tar.gz<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc6f9\uc11c\ubc84, DB\uc11c\ubc84 \uc124\uce58\ud558\uae30 \uc544\ud30c\uce58\uc6f9\uc11c\ubc84 \uc124\uce58 &nbsp; &nbsp; #apt -y install apache2 #systemctl restart apache2 #systemctl status apache2 #systemctl enable apache2 \uc544\ud30c\uce58\ub97c \uc124\uce58\ud558\uba74 \uae30\ubcf8\uc801\uc73c\ub85c\u00a0 \/etc\/apache2\/\u00a0 \ud3f4\ub354\uc5d0 \uc124\uce58\ub418\uba70 apache2.conf\ud30c\uc77c\uc5d0 \uc124\uc815\uac12\uc774 \uc874\uc7ac\ud55c\ub2e4. \uc11c\ubc84\uc758&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-6142","post","type-post","status-publish","format-standard","category-4"],"_links":{"self":[{"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/posts\/6142","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6142"}],"version-history":[{"count":5,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/posts\/6142\/revisions"}],"predecessor-version":[{"id":6161,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=\/wp\/v2\/posts\/6142\/revisions\/6161"}],"wp:attachment":[{"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6142"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6142"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pohang.eduwp.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}