wp-config.php\uc758 \uc0ac\uc6a9\uc790\uba85\uacfc \ube44\ubc00\ubc88\ud638 \uc815\ubcf4\uac00 \uc62c\ubc14\ub974\uc9c0 \uc54a\uac70\ub098 192.168.1.3\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc5d0 \uc811\uadfc\ud560 \uc218 \uc5c6\ub2e4\ub294 \uac83\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4. \uc774\ub294 \ud638\uc2a4\ud2b8\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uac00 \ub3d9\uc791\ud558\uc9c0 \uc54a\uace0 \uc788\ub2e4\ub294 \uac83\uc744 \uc758\ubbf8\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
wp-config.php<\/code> \ud30c\uc77c\uc758 \uc124\uc815 \ud655\uc778<\/strong><\/h2>\n\uc6cc\ub4dc\ud504\ub808\uc2a4\uc758 wp-config.php<\/code> \ud30c\uc77c\uc5d0 \uc785\ub825\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc815\ubcf4\uac00 \uc815\ud655\ud55c\uc9c0 \ud655\uc778\ud558\uc138\uc694.<\/p>\n\nbash<\/div>\n\n\n<\/div>\n<\/div>\n<\/div>\nsudo nano \/var\/www\/html\/wordpress\/wp-config.php
\n<\/code><\/div>\n<\/div>\n\ud655\uc778\ud574\uc57c \ud560 \ud56d\ubaa9:<\/p>\n
\nphp<\/div>\n\n\n<\/div>\n<\/div>\n<\/div>\ndefine<\/span>('DB_NAME'<\/span>, 'wordpress'<\/span>); \/\/ \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc774\ub984<\/span>
\n<\/code><\/div>\ndefine<\/span>('DB_USER'<\/span>, 'wp_user'<\/span>); \/\/ \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9\uc790\uba85<\/span>
\n<\/code><\/div>\ndefine<\/span>('DB_PASSWORD'<\/span>, '\ube44\ubc00\ubc88\ud638'<\/span>); \/\/ \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ube44\ubc00\ubc88\ud638<\/span><\/code><\/div>\n
\ndefine<\/span>('DB_HOST'<\/span>, 'localhost'<\/span>); \/\/ \ud638\uc2a4\ud2b8 \uc774\ub984<\/span>
\n<\/code><\/div>\n<\/div>\n\uc810\uac80:<\/h3>\n\n- DB_NAME<\/strong>: MySQL\uc5d0\uc11c \uc0dd\uc131\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc774\ub984\uacfc \uc77c\uce58\ud558\ub294\uc9c0 \ud655\uc778.<\/li>\n
- DB_USER<\/strong>: \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9\uc790 \uc774\ub984\uc774 \uc62c\ubc14\ub978\uc9c0 \ud655\uc778.<\/li>\n
- DB_PASSWORD<\/strong>: MySQL \uc0ac\uc6a9\uc790 \uacc4\uc815\uc758 \ube44\ubc00\ubc88\ud638\uc640 \ub3d9\uc77c\ud55c\uc9c0 \ud655\uc778.<\/li>\n
- DB_HOST<\/strong>: \ub3d9\uc77c \uc11c\ubc84\uc5d0 \uc124\uce58\ub41c MySQL\uc774\ub77c\uba74
localhost<\/code>\ub85c \uc720\uc9c0.<\/li>\n<\/ul>\n
\n2. MySQL \uc0ac\uc6a9\uc790 \uad8c\ud55c \ud655\uc778<\/strong><\/h2>\nMySQL\uc5d0 \uc811\uc18d\ud574 \uc0ac\uc6a9\uc790 \uad8c\ud55c\uc774 \uc81c\ub300\ub85c \uc124\uc815\ub418\uc5c8\ub294\uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4.<\/p>\n
\nbash<\/div>\n\n\n<\/div>\n<\/div>\n<\/div>\nsudo mysql -u root -p
\n<\/code><\/div>\n<\/div>\n\ub2e4\uc74c \uba85\ub839\uc5b4\ub97c \uc2e4\ud589:<\/p>\n
\nsql<\/div>\n\n\n<\/div>\n<\/div>\n<\/div>\nUSE mysql;
\nSELECT<\/span> User<\/span>, Host FROM<\/span> mysql.user WHERE<\/span> User<\/span> =<\/span> 'wp_user'<\/span>;
\n<\/code><\/div>\n<\/div>\n\n- \uacb0\uacfc\uc5d0
wp_user<\/code>\uc640 localhost<\/code>\uac00 \ud3ec\ud568\ub418\uc5b4 \uc788\ub294\uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4.<\/li>\n- \uad8c\ud55c\uc774 \uc81c\ub300\ub85c \uc124\uc815\ub418\uc9c0 \uc54a\uc558\ub2e4\uba74 \ub2e4\uc2dc \uad8c\ud55c \ubd80\uc5ec:\n\nsql<\/div>\n\n\n<\/div>\n<\/div>\n<\/div>\n
GRANT<\/span> ALL<\/span> PRIVILEGES ON<\/span> wordpress.*<\/span> TO<\/span> 'wp_user'<\/span>@'localhost'<\/span> IDENTIFIED BY<\/span> '\ube44\ubc00\ubc88\ud638'<\/span>;
\nFLUSH PRIVILEGES;
\n<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n
\n3. MySQL \uc11c\ubc84 \uc0c1\ud0dc \ud655\uc778<\/strong><\/h2>\nMySQL \uc11c\ubc84\uac00 \uc2e4\ud589 \uc911\uc778\uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4.<\/p>\n
\nbash<\/div>\n\n\n<\/div>\n<\/div>\n<\/div>\nsudo systemctl status mysql
\n<\/code><\/div>\n<\/div>\n\n- MySQL \uc11c\ubc84\uac00 \uba48\ucdb0 \uc788\ub2e4\uba74:\n\nbash<\/div>\n\n\n<\/div>\n<\/div>\n<\/div>\n
sudo systemctl start mysql
\n<\/code><\/div>\n<\/div>\n<\/li>\n- \ubd80\ud305 \uc2dc MySQL\uc774 \uc790\ub3d9\uc73c\ub85c \uc2dc\uc791\ub418\ub3c4\ub85d \uc124\uc815:\n\nbash<\/div>\n\n\n<\/div>\n<\/div>\n<\/div>\n
sudo systemctl enable<\/span> mysql
\n<\/code><\/div>\n<\/div>\n<\/li>\n<\/ul>\n
\n4. MySQL\uc5d0\uc11c \uc9c1\uc811 \uc811\uc18d \ud14c\uc2a4\ud2b8<\/strong><\/h2>\nwp-config.php<\/code>\uc5d0 \uc124\uc815\ub41c \uc0ac\uc6a9\uc790 \uacc4\uc815\uc73c\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uc18d\ud560 \uc218 \uc788\ub294\uc9c0 \ud14c\uc2a4\ud2b8\ud569\ub2c8\ub2e4.<\/p>\n\nbash<\/div>\n\n\n<\/div>\n<\/div>\n<\/div>\nmysql -u wp_user -p -h localhost
\n<\/code><\/div>\n<\/div>\n\n- \uc81c\ub300\ub85c \uc811\uc18d\ub418\uba74 MySQL CLI\uac00 \uc5f4\ub9bd\ub2c8\ub2e4.<\/li>\n
- \uc811\uc18d\uc5d0 \uc2e4\ud328\ud55c\ub2e4\uba74 \uc0ac\uc6a9\uc790 \uc774\ub984, \ube44\ubc00\ubc88\ud638, \ub610\ub294 \ud638\uc2a4\ud2b8 \uc124\uc815\uc744 \ub2e4\uc2dc \ud655\uc778\ud558\uc138\uc694.<\/li>\n<\/ul>\n
\n5. \ubc29\ud654\ubcbd \uc124\uc815 \ud655\uc778<\/strong><\/h2>\n\uc6b0\ubd84\ud22c \ubc29\ud654\ubcbd(UFW)\uc744 \uc0ac\uc6a9 \uc911\uc778 \uacbd\uc6b0 MySQL \ud3ec\ud2b8(\uae30\ubcf8: 3306)\uac00 \uc5f4\ub824 \uc788\ub294\uc9c0 \ud655\uc778\ud558\uc138\uc694.<\/p>\n
\ubc29\ud654\ubcbd \uc0c1\ud0dc \ud655\uc778:<\/p>\n
\nbash<\/div>\n\n\n<\/div>\n<\/div>\n<\/div>\nsudo ufw status
\n<\/code><\/div>\n<\/div>\nMySQL \ud3ec\ud2b8\ub97c \uc5f4\ub824\uba74:<\/p>\n
\nbash<\/div>\n\n\n<\/div>\n<\/div>\n<\/div>\nsudo ufw allow 3306
\nsudo ufw reload
\n<\/code><\/div>\n<\/div>\n
\n6. DB_HOST<\/code> \uc124\uc815 \ubcc0\uacbd (\uc678\ubd80 \uc11c\ubc84 \uc0ac\uc6a9 \uc2dc)<\/strong><\/h2>\nDB_HOST<\/code>\ub97c localhost<\/code> \ub300\uc2e0 \uc2e4\uc81c MySQL \uc11c\ubc84 IP \uc8fc\uc18c(175.202.41.78<\/code>)\ub85c \uc124\uc815\ud574 \ubcf4\uc138\uc694.
\nwp-config.php<\/code> \ud30c\uc77c\uc5d0\uc11c:<\/p>\n\nphp<\/div>\n\n\n<\/div>\n<\/div>\n<\/div>\ndefine<\/span>('DB_HOST'<\/span>, '175.202.41.78'<\/span>);
\n<\/code><\/div>\n<\/div>\n\uc678\ubd80 \uc11c\ubc84\uc77c \uacbd\uc6b0 \ud655\uc778\ud560 \uc0ac\ud56d:<\/h3>\n\n- MySQL \uc11c\ubc84\uc5d0\uc11c \uc678\ubd80 \uc811\uc18d\uc774 \ud5c8\uc6a9\ub418\uc5c8\ub294\uc9c0 \ud655\uc778:\n\nsql<\/div>\n\n\n<\/div>\n<\/div>\n<\/div>\n
GRANT<\/span> ALL<\/span> PRIVILEGES ON<\/span> wordpress.*<\/span> TO<\/span> 'wp_user'<\/span>@'%'<\/span> IDENTIFIED BY<\/span> '\ube44\ubc00\ubc88\ud638'<\/span>;
\nFLUSH PRIVILEGES;
\n<\/code><\/div>\n<\/div>\n<\/li>\n- MySQL \uc124\uc815 \ud30c\uc77c(
\/etc\/mysql\/mysql.conf.d\/mysqld.cnf<\/code>)\uc5d0\uc11c bind-address<\/code> \ud56d\ubaa9\uc774 0.0.0.0<\/code> \ub610\ub294 \ud2b9\uc815 IP\ub85c \uc124\uc815\ub418\uc5b4 \uc788\ub294\uc9c0 \ud655\uc778\ud558\uc138\uc694.<\/li>\n<\/ul>\n
\n7. Apache \ubc0f PHP \ub85c\uadf8 \ud655\uc778<\/strong><\/h2>\nApache\uc640 PHP \ub85c\uadf8\ub97c \ud655\uc778\ud558\uc5ec \ucd94\uac00 \uc624\ub958 \uc815\ubcf4\ub97c \ud30c\uc545\ud558\uc138\uc694.<\/p>\n
Apache \ub85c\uadf8:<\/p>\n
\nbash<\/div>\n\n\n<\/div>\n<\/div>\n<\/div>\nsudo tail<\/span> -f \/var\/log\/apache2\/error.log
\n<\/code><\/div>\n<\/div>\nPHP \uc624\ub958 \ub85c\uadf8:<\/p>\n
\nbash<\/div>\n\n\n<\/div>\n<\/div>\n<\/div>\nsudo tail<\/span> -f \/var\/log\/php*.log<\/span>
\n<\/code><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"wp-config.php\uc758 \uc0ac\uc6a9\uc790\uba85\uacfc \ube44\ubc00\ubc88\ud638 \uc815\ubcf4\uac00 \uc62c\ubc14\ub974\uc9c0 \uc54a\uac70\ub098 192.168.1.3\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uc5d0 \uc811\uadfc\ud560 \uc218 \uc5c6\ub2e4\ub294 \uac83\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4. \uc774\ub294 \ud638\uc2a4\ud2b8\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\uac00 \ub3d9\uc791\ud558\uc9c0 \uc54a\uace0 \uc788\ub2e4\ub294 \uac83\uc744 \uc758\ubbf8\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. 1. wp-config.php \ud30c\uc77c\uc758 \uc124\uc815 \ud655\uc778 \uc6cc\ub4dc\ud504\ub808\uc2a4\uc758 wp-config.php \ud30c\uc77c\uc5d0 \uc785\ub825\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc815\ubcf4\uac00 \uc815\ud655\ud55c\uc9c0 \ud655\uc778\ud558\uc138\uc694. bash sudo nano \/var\/www\/html\/wordpress\/wp-config.php \ud655\uc778\ud574\uc57c \ud560 \ud56d\ubaa9: php define(‘DB_NAME’, ‘wordpress’); \/\/ \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc774\ub984 define(‘DB_USER’, ‘wp_user’); \/\/ \ub370\uc774\ud130\ubca0\uc774\uc2a4 … \ub354 \ubcf4\uae30 “\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5f0\uacb0 \uc911 \uc624\ub958”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-13","post","type-post","status-publish","format-standard","hentry","category-4"],"_links":{"self":[{"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/13","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=13"}],"version-history":[{"count":1,"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/13\/revisions"}],"predecessor-version":[{"id":14,"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/13\/revisions\/14"}],"wp:attachment":[{"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=13"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}