{"id":495,"date":"2013-02-03T20:46:01","date_gmt":"2013-02-03T11:46:01","guid":{"rendered":"http:\/\/43.203.250.216\/?p=495"},"modified":"2013-02-03T20:46:01","modified_gmt":"2013-02-03T11:46:01","slug":"%eb%b6%84%ec%8b%a4%ed%95%9c-mysql-root-password-%ec%9e%ac%ec%84%a4%ec%a0%95%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/litcoder.com\/?p=495","title":{"rendered":"\ubd84\uc2e4\ud55c mysql root password \uc7ac\uc124\uc815\ud558\uae30"},"content":{"rendered":"<p>Mysql\uc744 \ucc98\uc74c \uc124\uce58\ud560 \ub54c database root \uacc4\uc815\uc73c\ub85c \uc0ac\uc6a9\ud560 password\ub97c \uc124\uc815\ud55c\ub2e4. \ud558\uc9c0\ub9cc \uc2dc\uac04\uc774 \uc624\ub798 \uc9c0\ub098\uc11c \uadf8\ub54c \uc124\uc815\ud55c password\ub97c \uae30\uc5b5\ud560 \uc218 \uc5c6\ub2e4\uba74 \ub2e4\uc74c\uc758 \ubc29\ubc95\uc73c\ub85c \uc7ac\uc124\uc815\ud560 \uc218 \uc788\ub2e4. (Ubuntu 12.04 \uae30\uc900)<\/p>\n<p><span style=\"line-height: 24px;\">Step 1. \uc2e4\ud589\uc911\uc778 mysql service\ub97c \uc911\uc9c0 \uc2dc\ud0a8\ub2e4.<\/span><\/p>\n<pre class=\"lang:default highlight:0 decode:true\"># service mysql stop<\/pre>\n<p>Step\u00a02. Password\ub97c \uac80\uc0ac\ud558\uc9c0 \uc54a\ub3c4\ub85d mysql \ud658\uacbd\uc124\uc815 \ud30c\uc77c\uc744 \uc218\uc815\ud55c\ub2e4.<br \/>\n: \/etc\/mysql\/my.conf file\uc5d0 skip-grant-tables\ub97c \ucd94\uac00\ud558\uba74 password\ub97c \uac80\uc0ac\ud558\uc9c0 \uc54a\ub294\ub2e4.<\/p>\n<pre class=\"lang:default highlight:0 decode:true crayon-selected\">[mysqld]\n#\n# * Basic Settings\n#\nuser         = mysql\npid-file     = \/var\/run\/mysqld\/mysqld.pid\nsocket       = \/var\/run\/mysqld\/mysqld.sock\nport         = 3306\nbasedir      = \/usr\ndatadir      = \/var\/lib\/mysql\ntmpdir       = \/tmp\nlc-messages-dir = \/usr\/share\/mysql\n\nskip-external-locking\n\nskip-grant-tables<\/pre>\n<p>Step\u00a03. \uc0c8\ub85c\uc6b4 \uc124\uc815 \uac12\uc73c\ub85c mysql service\ub97c \uc2e4\ud589\ud55c\ub2e4.<\/p>\n<pre class=\"lang:default highlight:0 decode:true\"># sudo service mysql start<\/pre>\n<p>Step\u00a04. root \uacc4\uc815\uc73c\ub85c mysql database\ub97c \uc5f0\ub2e4.<\/p>\n<pre class=\"lang:default highlight:0 decode:true\">$ mysql -uroot mysql\nReading table information for completion of table and column names\nYou can turn off this feature to get a quicker startup with -A\n\nWelcome to the MySQL monitor.  Commands end with ; or \\g.\nYour MySQL connection id is 37\nServer version: 5.5.29-0ubuntu0.12.04.1 (Ubuntu)\n\nCopyright (c) 2000, 2012, Oracle and\/or its affiliates. All rights reserved.\n\nOracle is a registered trademark of Oracle Corporation and\/or its\naffiliates. Other names may be trademarks of their respective\nowners.\n\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\n\nmysql&gt;<\/pre>\n<p>Step\u00a05. root password\ub97c \uc7ac\uc124\uc815\ud55c\ub2e4.<\/p>\n<pre class=\"lang:default highlight:0 decode:true\">mysql&gt; UPDATE user SET password=PASSWORD('ROOT_\ube44\ubc00\ubc88\ud638') WHERE user='root';\nQuery OK, 4 rows affected (0.00 sec)\nRows matched: 4  Changed: 4  Warnings: 0<\/pre>\n<p>Step\u00a06. my.conf\ub97c \ubcf5\uc6d0\ud558\uace0 mysql service\ub97c \uc7ac\uc2e4\ud589 \uc2dc\ud0a8\ub2e4.<span style=\"line-height: 1.714285714; font-size: 1rem;\">\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Mysql\uc744 \ucc98\uc74c \uc124\uce58\ud560 \ub54c database root \uacc4\uc815\uc73c\ub85c \uc0ac\uc6a9\ud560 password\ub97c \uc124\uc815\ud55c\ub2e4. \ud558\uc9c0\ub9cc \uc2dc\uac04\uc774 \uc624\ub798 \uc9c0\ub098\uc11c \uadf8\ub54c \uc124\uc815\ud55c password\ub97c \uae30\uc5b5\ud560 \uc218 \uc5c6\ub2e4\uba74 \ub2e4\uc74c\uc758 \ubc29\ubc95\uc73c\ub85c \uc7ac\uc124\uc815\ud560 \uc218 \uc788\ub2e4. (Ubuntu 12.04 \uae30\uc900) Step 1. \uc2e4\ud589\uc911\uc778 mysql service\ub97c \uc911\uc9c0 \uc2dc\ud0a8\ub2e4. # service mysql stop Step\u00a02. Password\ub97c \uac80\uc0ac\ud558\uc9c0 \uc54a\ub3c4\ub85d mysql \ud658\uacbd\uc124\uc815 \ud30c\uc77c\uc744 \uc218\uc815\ud55c\ub2e4. : \/etc\/mysql\/my.conf file\uc5d0 skip-grant-tables\ub97c \ucd94\uac00\ud558\uba74 password\ub97c \uac80\uc0ac\ud558\uc9c0 \uc54a\ub294\ub2e4. [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[33,72,87],"class_list":["post-495","post","type-post","status-publish","format-standard","hentry","category-linux","tag-database","tag-linux","tag-mysql"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/litcoder.com\/index.php?rest_route=\/wp\/v2\/posts\/495","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/litcoder.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/litcoder.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/litcoder.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/litcoder.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=495"}],"version-history":[{"count":0,"href":"https:\/\/litcoder.com\/index.php?rest_route=\/wp\/v2\/posts\/495\/revisions"}],"wp:attachment":[{"href":"https:\/\/litcoder.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=495"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/litcoder.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=495"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/litcoder.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=495"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}