{"id":377,"date":"2024-01-22T23:56:40","date_gmt":"2024-01-22T14:56:40","guid":{"rendered":"http:\/\/www.iwgh.run\/?p=377"},"modified":"2024-01-23T09:05:25","modified_gmt":"2024-01-23T00:05:25","slug":"wordpress-%ec%82%ac%ec%9d%b4%ed%8a%b8-%ec%a3%bc%ec%86%8c-%eb%b3%80%ea%b2%bd-%ec%8b%a4%ec%88%98%ec%8b%9c-database%ec%97%90%ec%84%9c%ec%9d%98-%eb%b3%80%ea%b2%bd","status":"publish","type":"post","link":"https:\/\/iwgh.duckdns.org\/?p=377","title":{"rendered":"WordPress \uc0ac\uc774\ud2b8 \uc8fc\uc18c \ubcc0\uacbd \uc2e4\uc218\uc2dc, database\uc5d0\uc11c\uc758 \ubcc0\uacbd"},"content":{"rendered":"

WordPress\ub97c \uc6b4\uc601\ud55c\ub2e4\uba74 \uac1c\uc778\ub3c4\uba54\uc778\uc5d0 \uc5f0\uacb0\ud574\uc11c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0\uac00 \uc788\ub2e4.<\/p>\n

\uc774 \ub3c4\uba54\uc778\uc774 \ubcc0\uacbd\ub418\ub294 \uacbd\uc6b0 wordpress \uad00\ub9ac\uc790 \ud398\uc774\uc9c0 – \uc124\uc815\uc5d0\uc11c siteurl\uacfc home \uc815\ubcf4\ub97c \ubcc0\uacbd\ud574\uc8fc\uc5b4\uc57c \ud55c\ub2e4.
\uc774 \uc8fc\uc18c \ubcc0\uacbd\ud560 \ub54c \uc2e4\uc218\ub85c www..iwgh.run\uc73c\ub85c \uc624\uae30\ud558\ub294 \ubc14\ub78c\uc5d0 wordpress\uc5d0 \uc811\uc18d\uc774 \ub418\uc9c0 \uc54a\ub294 \uc0c1\ud669\uc774 \uc0dd\uacbc\ub2e4.<\/p>\n

\uae30\uc874\uc5d0\ub294 \uacf5\uc778IP\ub97c \uce58\uace0 \ub4e4\uc5b4\uac00\uba74 \ub418\uc5c8\uc73c\ub098 \uc5b4\ucc0c\ub41c \uc77c\uc778\uc9c0 \ubcc0\uacbd\uc744 \uc704\ud574 \uad00\ub9ac\uc790 \ud398\uc774\uc9c0\uc5d0 \uc811\uc18d\uc744 \ud558\ub2c8 \uc624\uae30\ub41c “www..”\u00a0
\uc73c\ub85c \ub9ac\ub2e4\uc774\ub809\ud2b8 \ub418\ub294 \ubc14\ub78c\uc5d0 \uad00\ub9ac\uc790 \ud398\uc774\uc9c0\uc5d0\ub294 \uc811\uadfc\ub3c4 \ubabb\ud558\uac8c \ub418\uc5c8\ub2e4.<\/p>\n

\ub9e4\uc6b0 \ub09c\uac10\ud558\uc5ec \uc11c\ubc84\uc5d0 \uc811\uc18d\ud558\uc5ec config \ud30c\uc77c\ub4e4\uc744 \ub458\ub7ec\ubcf4\uc558\uc73c\ub098 \ud574\ub2f9 \ubcc0\uacbd\uc744 \uc218\ud589\ud558\ub294 php \ud30c\uc77c\uc740 \uc788\uc5c8\uc73c\ub098
\uc624\uae30\ub41c \uc0ac\uc774\ud2b8 \uc8fc\uc18c\uc778 “www..iwgh.run”\uc5d0 \ub300\ud55c \uc815\ubcf4\ub294 \uc5c6\uc5c8\ub2e4.<\/p>\n

\ud574\ub2f9 \uc815\ubcf4\ub294 \ub2e4\ub978 \uae00\uc774\ub098 \uacc4\uc815\uc815\ubcf4\uc640 \ub9c8\ucc2c\uac00\uc9c0\ub85c database\uc5d0 \uc800\uc7a5\ub418\ub294 \uac83\uc73c\ub85c \uc9d0\uc791\ud558\uc5ec \ud655\uc778\ud574\ubcf4\ub2c8 wordpress database\uc758 “wp_options” table\uc5d0 \uc800\uc7a5\ub428\uc744 \ud655\uc778\ud558\uc600\ub2e4.<\/p>\n

\uc5ec\uae30\uc11c \uc218\uc815\uc744 \ud558\ub2c8 \uc815\uc0c1 \uc811\uc18d\uc774 \ub418\uc5c8\ub2e4. \uc5b4\ud734…<\/p>\n\n\n

# mysql -u root\nWelcome to the MariaDB monitor.  Commands end with ; or \\g.\nYour MariaDB connection id is 15341\nServer version: 5.5.68-MariaDB MariaDB Server\n\nCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.\n\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\n\nMariaDB [(none)]> show databases;\n+--------------------+\n| Database           |\n+--------------------+\n| information_schema |\n| mysql              |\n| performance_schema |\n| wordpress          |\n+--------------------+\n4 rows in set (0.01 sec)\n\nMariaDB [(none)]> use wordpress\nReading table information for completion of table and column names\nYou can turn off this feature to get a quicker startup with -A\n\nDatabase changed\n\nMariaDB [wordpress]> show tables;\n+-----------------------+\n| Tables_in_wordpress   |\n+-----------------------+\n...\n| wp_options            |\n| wp_postmeta           |\n| wp_posts              |\n...\n+-----------------------+\n13 rows in set (0.00 sec)\n\nMariaDB [wordpress]> desc wp_options;\n+--------------+---------------------+------+-----+---------+----------------+\n| Field        | Type                | Null | Key | Default | Extra          |\n+--------------+---------------------+------+-----+---------+----------------+\n| option_id    | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |\n| option_name  | varchar(191)        | NO   | UNI |         |                |\n| option_value | longtext            | NO   |     | NULL    |                |\n| autoload     | varchar(20)         | NO   | MUL | yes     |                |\n+--------------+---------------------+------+-----+---------+----------------+\n4 rows in set (0.00 sec)\n\nMariaDB [wordpress]> select option_name from wp_options;\n+---------------------------------------------------------------------------------+\n| option_name                                                                     |\n+---------------------------------------------------------------------------------+\n...                                                                   |\n| site_logo                                                                       |\n| siteurl                                                                         |\n| start_of_week                                                                   |\n...\n+---------------------------------------------------------------------------------+\n211 rows in set (0.00 sec)\n\nMariaDB [wordpress]> select option_id, option_value from wp_options where option_name = 'siteurl';\n+-----------+----------------------+\n| option_id | option_value         |\n+-----------+----------------------+\n|         1 | http:\/\/www..iwgh.run |\n+-----------+----------------------+\n1 row in set (0.00 sec)\n\nMariaDB [wordpress]> update wp_options set option_value = 'http:\/\/www.iwgh.run' where option_name = 'siteurl';\nQuery OK, 1 row affected (0.01 sec)\nRows matched: 1  Changed: 1  Warnings: 0\n\nMariaDB [wordpress]> select option_id, option_value from wp_options where option_name = 'siteurl';\n+-----------+---------------------+\n| option_id | option_value        |\n+-----------+---------------------+\n|         1 | http:\/\/www.iwgh.run |\n+-----------+---------------------+\n1 row in set (0.00 sec)\n\n<\/code><\/pre><\/div>\n","protected":false},"excerpt":{"rendered":"
WordPress\ub97c \uc6b4\uc601\ud55c\ub2e4\uba74 \uac1c\uc778\ub3c4\uba54\uc778\uc5d0 \uc5f0\uacb0\ud574\uc11c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0\uac00 \uc788\ub2e4. \uc774 \ub3c4\uba54\uc778\uc774 \ubcc0\uacbd\ub418\ub294 \uacbd\uc6b0 wordpress \uad00\ub9ac\uc790 \ud398\uc774\uc9c0 – \uc124\uc815\uc5d0\uc11c siteurl\uacfc home \uc815\ubcf4\ub97c \ubcc0\uacbd\ud574\uc8fc\uc5b4\uc57c \ud55c\ub2e4.\uc774 \uc8fc\uc18c \ubcc0\uacbd\ud560 \ub54c \uc2e4\uc218\ub85c […]<\/p>\n","protected":false},"author":1,"featured_media":378,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[118,117,115,116,114],"class_list":["post-377","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-gossip","tag-blog","tag-config","tag-mariadb","tag-siteurl","tag-wordpress"],"_links":{"self":[{"href":"https:\/\/iwgh.duckdns.org\/index.php?rest_route=\/wp\/v2\/posts\/377","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/iwgh.duckdns.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/iwgh.duckdns.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/iwgh.duckdns.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/iwgh.duckdns.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=377"}],"version-history":[{"count":4,"href":"https:\/\/iwgh.duckdns.org\/index.php?rest_route=\/wp\/v2\/posts\/377\/revisions"}],"predecessor-version":[{"id":384,"href":"https:\/\/iwgh.duckdns.org\/index.php?rest_route=\/wp\/v2\/posts\/377\/revisions\/384"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/iwgh.duckdns.org\/index.php?rest_route=\/wp\/v2\/media\/378"}],"wp:attachment":[{"href":"https:\/\/iwgh.duckdns.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=377"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/iwgh.duckdns.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=377"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/iwgh.duckdns.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}