{"id":147,"date":"2025-02-01T09:10:30","date_gmt":"2025-02-01T09:10:30","guid":{"rendered":"http:\/\/211.230.203.47\/wordpress\/?p=147"},"modified":"2025-02-01T09:10:30","modified_gmt":"2025-02-01T09:10:30","slug":"%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4%ec%97%90%ec%84%9c-%ec%9b%8c%eb%93%9c%ed%94%84%eb%a0%88%ec%8a%a4-%ea%b4%80%eb%a6%ac%ec%9e%90-%ec%95%84%ec%9d%b4%eb%94%94-%ec%b0%be%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/www.soon7shop.kr\/wordpress\/?p=147","title":{"rendered":"\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c  \uc6cc\ub4dc\ud504\ub808\uc2a4 \uad00\ub9ac\uc790 \uc544\uc774\ub514 \ucc3e\uae30"},"content":{"rendered":"<p>\uc6cc\ub4dc\ud504\ub808\uc2a4 \uad00\ub9ac\uc790 \uc544\uc774\ub514\ub294 MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c \ub2e8\uacc4\ub97c \ub530\ub77c \ud655\uc778\ud558\uc138\uc694.<\/p>\n<h3>1. <strong>MySQL \uc811\uc18d<\/strong><\/h3>\n<p>\ud130\ubbf8\ub110\uc5d0\uc11c \uc544\ub798 \uba85\ub839\uc5b4\ub97c \uc2e4\ud589\ud558\uc5ec MySQL\uc5d0 \uc811\uc18d\ud569\ub2c8\ub2e4.<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950\">\n<div class=\"flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between rounded-t-md h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none\">sh<\/div>\n<div class=\"sticky top-9 md:top-[5.75rem]\">\n<div class=\"absolute bottom-0 right-2 flex h-9 items-center\">\n<div class=\"flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre language-sh\">mysql -u root -p<br \/>\n<\/code><\/div>\n<\/div>\n<p>\ub610\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9\uc790\uac00 \ub530\ub85c \uc788\ub2e4\uba74,<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950\">\n<div class=\"flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between rounded-t-md h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none\">sh<\/div>\n<div class=\"sticky top-9 md:top-[5.75rem]\">\n<div class=\"absolute bottom-0 right-2 flex h-9 items-center\">\n<div class=\"flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre language-sh\">mysql -u [\uc0ac\uc6a9\uc790\uba85] -p<br \/>\n<\/code><\/div>\n<\/div>\n<p>\ube44\ubc00\ubc88\ud638 \uc785\ub825 \ud6c4 \uc811\uc18d\ub429\ub2c8\ub2e4.<\/p>\n<h3>2. <strong>\uc6cc\ub4dc\ud504\ub808\uc2a4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc120\ud0dd<\/strong><\/h3>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950\">\n<div class=\"flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between rounded-t-md h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none\">sql<\/div>\n<div class=\"sticky top-9 md:top-[5.75rem]\">\n<div class=\"absolute bottom-0 right-2 flex h-9 items-center\">\n<div class=\"flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre language-sql\"><span class=\"hljs-keyword\">SHOW<\/span> DATABASES;<br \/>\n<\/code><\/div>\n<\/div>\n<p>\uc6cc\ub4dc\ud504\ub808\uc2a4\uac00 \uc0ac\uc6a9\ud558\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ucc3e\uace0, \uc120\ud0dd\ud569\ub2c8\ub2e4.<br \/>\n\uc608\ub97c \ub4e4\uc5b4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc774\ub984\uc774 <code>wordpress_db<\/code>\ub77c\uba74:<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950\">\n<div class=\"flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between rounded-t-md h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none\">sql<\/div>\n<div class=\"sticky top-9 md:top-[5.75rem]\">\n<div class=\"absolute bottom-0 right-2 flex h-9 items-center\">\n<div class=\"flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre language-sql\">USE wordpress_db;<br \/>\n<\/code><\/div>\n<\/div>\n<h3>3. <strong>\uad00\ub9ac\uc790 \uc544\uc774\ub514 \ud655\uc778<\/strong><\/h3>\n<p>\uc6cc\ub4dc\ud504\ub808\uc2a4\uc758 \uc0ac\uc6a9\uc790 \uc815\ubcf4\ub294 <code>wp_users<\/code> \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ub429\ub2c8\ub2e4. \ub2e4\uc74c \uba85\ub839\uc5b4\ub85c \ubaa8\ub4e0 \uc0ac\uc6a9\uc790 \ubaa9\ub85d\uc744 \ud655\uc778\ud558\uc138\uc694.<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950\">\n<div class=\"flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between rounded-t-md h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none\">sql<\/div>\n<div class=\"sticky top-9 md:top-[5.75rem]\">\n<div class=\"absolute bottom-0 right-2 flex h-9 items-center\">\n<div class=\"flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre language-sql\"><span class=\"hljs-keyword\">SELECT<\/span> ID, user_login, user_email <span class=\"hljs-keyword\">FROM<\/span> wp_users;<br \/>\n<\/code><\/div>\n<\/div>\n<p>\uc5ec\uae30\uc11c <code>user_login<\/code>\uc774 \uc544\uc774\ub514\uc785\ub2c8\ub2e4.<\/p>\n<h3>4. <strong>\ud2b9\uc815 \uad00\ub9ac\uc790 \uacc4\uc815 \ucc3e\uae30<\/strong><\/h3>\n<p>\uad00\ub9ac\uc790 \uacc4\uc815\ub9cc \uc870\ud68c\ud558\ub824\uba74 <code>wp_usermeta<\/code> \ud14c\uc774\ube14\uacfc \uc870\uc778\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950\">\n<div class=\"flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between rounded-t-md h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none\">sql<\/div>\n<div class=\"sticky top-9 md:top-[5.75rem]\">\n<div class=\"absolute bottom-0 right-2 flex h-9 items-center\">\n<div class=\"flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre language-sql\"><span class=\"hljs-keyword\">SELECT<\/span> u.ID, u.user_login, u.user_email<br \/>\n<span class=\"hljs-keyword\">FROM<\/span> wp_users u<br \/>\n<span class=\"hljs-keyword\">JOIN<\/span> wp_usermeta m <span class=\"hljs-keyword\">ON<\/span> u.ID <span class=\"hljs-operator\">=<\/span> m.user_id<br \/>\n<span class=\"hljs-keyword\">WHERE<\/span> m.meta_key <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">'wp_capabilities'<\/span> <span class=\"hljs-keyword\">AND<\/span> m.meta_value <span class=\"hljs-keyword\">LIKE<\/span> <span class=\"hljs-string\">'%administrator%'<\/span>;<br \/>\n<\/code><\/div>\n<\/div>\n<p>\uc774\ub807\uac8c \ud558\uba74 \uad00\ub9ac\uc790 \uad8c\ud55c\uc744 \uac00\uc9c4 \uacc4\uc815\ub9cc \ucd9c\ub825\ub429\ub2c8\ub2e4.<\/p>\n<h3>5. <strong>\ube44\ubc00\ubc88\ud638 \uc7ac\uc124\uc815 (\ud544\uc694 \uc2dc)<\/strong><\/h3>\n<p>\ube44\ubc00\ubc88\ud638\ub97c \ubaa8\ub974\uba74, \uc0c8\ub85c\uc6b4 \uac83\uc73c\ub85c \ubcc0\uacbd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<div class=\"contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary dark:bg-gray-950\">\n<div class=\"flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between rounded-t-md h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none\">sql<\/div>\n<div class=\"sticky top-9 md:top-[5.75rem]\">\n<div class=\"absolute bottom-0 right-2 flex h-9 items-center\">\n<div class=\"flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"!whitespace-pre language-sql\"><span class=\"hljs-keyword\">UPDATE<\/span> wp_users<br \/>\n<span class=\"hljs-keyword\">SET<\/span> user_pass <span class=\"hljs-operator\">=<\/span> MD5(<span class=\"hljs-string\">'\uc0c8\ub85c\uc6b4\ube44\ubc00\ubc88\ud638'<\/span>)<br \/>\n<span class=\"hljs-keyword\">WHERE<\/span> user_login <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">'admin'<\/span>;<br \/>\n<\/code><\/div>\n<\/div>\n<p>\u26a0\ufe0f <code>MD5<\/code> \uc554\ud638\ud654\ub294 \ubcf4\uc548\uc0c1 \ucde8\uc57d\ud558\ubbc0\ub85c, \uc6cc\ub4dc\ud504\ub808\uc2a4 \uad00\ub9ac\uc790 \ud398\uc774\uc9c0\uc5d0\uc11c \ube44\ubc00\ubc88\ud638\ub97c \ubcc0\uacbd\ud558\ub294 \uac83\uc774 \ub354 \uc548\uc804\ud569\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc6cc\ub4dc\ud504\ub808\uc2a4 \uad00\ub9ac\uc790 \uc544\uc774\ub514\ub294 MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c \ub2e8\uacc4\ub97c \ub530\ub77c \ud655\uc778\ud558\uc138\uc694. 1. MySQL \uc811\uc18d \ud130\ubbf8\ub110\uc5d0\uc11c \uc544\ub798 \uba85\ub839\uc5b4\ub97c \uc2e4\ud589\ud558\uc5ec MySQL\uc5d0 \uc811\uc18d\ud569\ub2c8\ub2e4. sh mysql -u root -p \ub610\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9\uc790\uac00 \ub530\ub85c \uc788\ub2e4\uba74, sh mysql -u [\uc0ac\uc6a9\uc790\uba85] -p \ube44\ubc00\ubc88\ud638 \uc785\ub825 \ud6c4 \uc811\uc18d\ub429\ub2c8\ub2e4. 2. \uc6cc\ub4dc\ud504\ub808\uc2a4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc120\ud0dd sql SHOW DATABASES; \uc6cc\ub4dc\ud504\ub808\uc2a4\uac00 \uc0ac\uc6a9\ud558\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ucc3e\uace0, \uc120\ud0dd\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 &hellip; <a href=\"https:\/\/www.soon7shop.kr\/wordpress\/?p=147\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c  \uc6cc\ub4dc\ud504\ub808\uc2a4 \uad00\ub9ac\uc790 \uc544\uc774\ub514 \ucc3e\uae30&#8221;<\/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-147","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\/147","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=147"}],"version-history":[{"count":1,"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/147\/revisions"}],"predecessor-version":[{"id":148,"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/147\/revisions\/148"}],"wp:attachment":[{"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=147"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=147"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=147"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}