{"id":3495,"date":"2021-09-25T12:32:22","date_gmt":"2021-09-25T03:32:22","guid":{"rendered":"https:\/\/www.skyer9.pe.kr\/wordpress\/?p=3495"},"modified":"2022-04-09T10:22:33","modified_gmt":"2022-04-09T01:22:33","slug":"%ec%9a%b0%eb%b6%84%ed%88%ac-20-04-%ec%97%90-mariadb-%ec%84%a4%ec%b9%98%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/www.skyer9.pe.kr\/wordpress\/?p=3495","title":{"rendered":"\uc6b0\ubd84\ud22c 20.04 \uc5d0 MariaDB \uc124\uce58\ud558\uae30"},"content":{"rendered":"<h1>\uc6b0\ubd84\ud22c 20.04 \uc5d0 MariaDB \uc124\uce58\ud558\uae30<\/h1>\n<h2>install<\/h2>\n<pre><code class=\"language-bash\">sudo apt install -y mariadb-server<\/code><\/pre>\n<h2>setup<\/h2>\n<pre><code class=\"language-bash\">sudo mysql_secure_installation<\/code><\/pre>\n<p>\ube44\ubc00\ubc88\ud638\ub294 \uadf8\ub0e5 \uc5d4\ud130\ub97c \uc785\ub825\ud55c\ub2e4.(\ube44\ubc00\ubc88\ud638 \uc5c6\uc74c)<br \/>\n\uccab\ubc88\uc9f8 \ubb3c\uc74c\uc5d0 <code>n<\/code> \uc744 \uc785\ub825 \ud6c4 \ub098\uba38\uc9c0 \ubb3c\uc74c\uc5d0 \ubaa8\ub450 <code>Y<\/code> \ub97c \uc785\ub825\ud55c\ub2e4.<\/p>\n<h2>login<\/h2>\n<p><code>root<\/code> \uacc4\uc815\ub9cc \ub85c\uadf8\uc778\ud560 \uc218 \uc788\ub2e4.<br \/>\n\ube44\ubc00\ubc88\ud638\ub294 \uc785\ub825\ud558\uc9c0 \uc54a\uace0 \uc5d4\ud130\ub97c \uc785\ub825\ud558\uba74 \ub41c\ub2e4.<\/p>\n<pre><code class=\"language-bash\">mysql -u root -p\nERROR 1698 (28000): Access denied for user &#039;root&#039;@&#039;localhost&#039;\n\nsudo su -\nmysql -u root -p<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\uc6b0\ubd84\ud22c 20.04 \uc5d0 MariaDB \uc124\uce58\ud558\uae30 install sudo apt install -y mariadb-server setup sudo mysql_secure_installation \ube44\ubc00\ubc88\ud638\ub294 \uadf8\ub0e5 \uc5d4\ud130\ub97c \uc785\ub825\ud55c\ub2e4.(\ube44\ubc00\ubc88\ud638 \uc5c6\uc74c) \uccab\ubc88\uc9f8 \ubb3c\uc74c\uc5d0 n \uc744 \uc785\ub825 \ud6c4 \ub098\uba38\uc9c0 \ubb3c\uc74c\uc5d0 \ubaa8\ub450 Y \ub97c \uc785\ub825\ud55c\ub2e4. login root \uacc4\uc815\ub9cc \ub85c\uadf8\uc778\ud560 \uc218 \uc788\ub2e4. \ube44\ubc00\ubc88\ud638\ub294 \uc785\ub825\ud558\uc9c0 \uc54a\uace0 \uc5d4\ud130\ub97c \uc785\ub825\ud558\uba74 \ub41c\ub2e4. mysql -u root -p ERROR 1698 (28000): Access denied for user &#039;root&#039;@&#039;localhost&#039;\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.skyer9.pe.kr\/wordpress\/?p=3495\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-3495","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3495","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3495"}],"version-history":[{"count":3,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3495\/revisions"}],"predecessor-version":[{"id":5142,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3495\/revisions\/5142"}],"wp:attachment":[{"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3495"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3495"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skyer9.pe.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3495"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}