{"id":4767,"date":"2023-01-09T14:38:09","date_gmt":"2023-01-09T05:38:09","guid":{"rendered":"https:\/\/i-kiin.net\/?p=4767"},"modified":"2023-01-09T14:38:09","modified_gmt":"2023-01-09T05:38:09","slug":"mysql%ec%97%90%ec%84%9c-%ec%83%9d%ec%84%b1%ed%95%9c-database-%ed%8c%8c%ec%9d%bc-%ec%9c%84%ec%b9%98","status":"publish","type":"post","link":"https:\/\/i-kiin.net\/?p=4767","title":{"rendered":"MySQL\uc5d0\uc11c \uc0dd\uc131\ud55c Database \ud30c\uc77c \uc704\uce58"},"content":{"rendered":"<p>\uac00\ub054 \ud544\uc694\ud55c \uacbd\uc6b0\uac00 \uc788\uc5b4\uc11c \uad6c\uae00\ub9c1\uc744 \ud1b5\ud574 \ucc3e\uc544\ubcf4\uc558\ub2e4.<\/p>\n<ul>\n<li><a href=\"https:\/\/minasb.tistory.com\/84\" target=\"_blank\" rel=\"nofollow noopener\">MySql DB \ub370\uc774\ud130 \uc800\uc7a5 \uacbd\ub85c<\/a><\/li>\n<\/ul>\n<p>\uc0c1\uae30 \ub9c1\ud06c\uc758 \uae00\ub3c4 \uc6d0\ubcf8\uc744 \ub530\ub85c \ubc1d\ud788\uace0 \uc788\uc5c8\uc73c\ub098 \uc2e4\uc81c \uc6d0\ubcf8 \uae00\uc740 \uc0ac\ub77c\uc9c4 \uc0c1\ud0dc\uc774\ub2e4.<\/p>\n<p>\uac01\uc124\ud558\uace0!!!<\/p>\n<p>MySQL\uc744 \ud1b5\ud574 \uc0dd\uc131\ud55c \uac01 Database \ud30c\uc77c \uc704\uce58\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 \uc9c4\ud589\ud558\uba74 \uc54c \uc218 \uc788\ub2e4.<\/p>\n<ul style=\"list-style-type: circle;\">\n<li>\ud130\ubbf8\ub110\uc5d0\uc11c <code>mysql -u root -p<\/code> \uc785\ub825 \ud6c4 <code>root<\/code> \uacc4\uc815\uc758 <span style=\"color: #ff0000;\"><strong>\ube44\ubc00\ubc88\ud638<\/strong><\/span> \uc785\ub825<\/li>\n<li><code>mysql&gt; show variables like 'datadir';<\/code> \uc785\ub825 \u21d2 \uc6b0\ubd84\ud22c 22.04, MySQL 8.0.31 \uae30\uc900 <span style=\"color: #ff00ff;\"><strong>\ucd9c\ub825 \uac12<\/strong><\/span> == <code>\/var\/lib\/mysql\/<\/code><\/li>\n<li><code>sudo -s<\/code> \uc785\ub825 \ud6c4 <code>sudo<\/code> <span style=\"color: #ff0000;\"><strong>\ube44\ubc00\ubc88\ud638<\/strong><\/span> \uc785\ub825<\/li>\n<li><code>cd \/var\/lib\/mysql\/<\/code> \uc785\ub825\ud558\uc5ec \ud574\ub2f9 \ub514\ub809\ud1a0\ub9ac\ub85c \uc774\ub3d9<\/li>\n<li>\uc0dd\uc131\ud55c <span style=\"color: #ff00ff;\"><strong>Database \ub514\ub809\ud1a0\ub9ac<\/strong><\/span>\ub85c \uc774\ub3d9 \u21d2 e.g., <code>cd wordpress\/<\/code><\/li>\n<\/ul>\n<p>\uc870\ud68c\uc218: 9<\/p>","protected":false},"excerpt":{"rendered":"<p>\uac00\ub054 \ud544\uc694\ud55c \uacbd\uc6b0\uac00 \uc788\uc5b4\uc11c \uad6c\uae00\ub9c1\uc744 \ud1b5\ud574 \ucc3e\uc544\ubcf4\uc558\ub2e4. MySql DB \ub370\uc774\ud130 \uc800\uc7a5 \uacbd\ub85c \uc0c1\uae30 \ub9c1\ud06c\uc758 \uae00\ub3c4 \uc6d0\ubcf8\uc744 \ub530\ub85c \ubc1d\ud788\uace0 \uc788\uc5c8\uc73c\ub098 \uc2e4\uc81c \uc6d0\ubcf8 \uae00\uc740 \uc0ac\ub77c\uc9c4 \uc0c1\ud0dc\uc774\ub2e4. \uac01\uc124\ud558\uace0!!! MySQL\uc744 \ud1b5\ud574 \uc0dd\uc131\ud55c \uac01 Database \ud30c\uc77c \uc704\uce58\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 \uc9c4\ud589\ud558\uba74 \uc54c \uc218 \uc788\ub2e4. \ud130\ubbf8\ub110\uc5d0\uc11c mysql -u root -p \uc785\ub825 \ud6c4 root \uacc4\uc815\uc758 \ube44\ubc00\ubc88\ud638 \uc785\ub825 mysql&gt; show variables like &#8216;datadir&#8217;; \uc785\ub825 &#8230; <a title=\"MySQL\uc5d0\uc11c \uc0dd\uc131\ud55c Database \ud30c\uc77c \uc704\uce58\" class=\"read-more\" href=\"https:\/\/i-kiin.net\/?p=4767\" aria-label=\"MySQL\uc5d0\uc11c \uc0dd\uc131\ud55c Database \ud30c\uc77c \uc704\uce58\uc5d0 \ub300\ud574 \ub354 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uc138\uc694\">\ub354 \uc77d\uae30<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[483],"tags":[2928],"class_list":["post-4767","post","type-post","status-publish","format-standard","hentry","category-pc-and-pc","tag-mysql"],"_links":{"self":[{"href":"https:\/\/i-kiin.net\/index.php?rest_route=\/wp\/v2\/posts\/4767","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/i-kiin.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/i-kiin.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/i-kiin.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/i-kiin.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4767"}],"version-history":[{"count":0,"href":"https:\/\/i-kiin.net\/index.php?rest_route=\/wp\/v2\/posts\/4767\/revisions"}],"wp:attachment":[{"href":"https:\/\/i-kiin.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4767"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/i-kiin.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4767"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/i-kiin.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4767"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}