{"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_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"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_sharing_enabled":true,"jetpack-related-posts":[{"id":4139,"url":"https:\/\/litcoder.com\/?p=4139","url_meta":{"origin":495,"position":0},"title":"Bitnami \uc6cc\ub4dc\ud504\ub808\uc2a4\ub97c Amazon Linux 2023\uc73c\ub85c \ub9c8\uc774\uadf8\ub808\uc774\uc158","author":"litcoder","date":"2026\ub144 2\uc6d4 25\uc77c","format":false,"excerpt":"\ucc98\uc74c Lightsail\ub85c \uc774\uc0ac\uc654\uc744 \ub54c \uc778\uc2a4\ud134\uc2a4 \uc120\ud0dd\uc5d0\ub294 \ud070 \uace0\ubbfc\uc744 \ub4e4\uc774\uc9c0\ub294 \uc54a\uc558\ub2e4. \uc81c\uacf5\ub418\ub294 WordPress instance\uc5d0\ub294 \ud544\uc694\ud55c \uac83\ub4e4\uc774 \uc774\ubbf8 \ub2e4 \uc124\uce58 \ub418\uc5b4 \uc788\uc5b4\uc11c \uc778\uc2a4\ud134\uc2a4\ub97c \ud558\ub098 \uc0dd\uc131\ud558\uace0 \uae30\uc874 \ube14\ub85c\uadf8\ub97c import\ud558\ub294 \uac83\uc73c\ub85c \ubaa8\ub4e0 \uacfc\uc815\ub4e4\uc774 \ube44\uad50\uc801 \uc21c\uc870\ub86d\uac8c \uc9c4\ud589\ub41c \ud3b8\uc774\uc5c8\ub2e4. \ubb38\uc81c\ub294 \uc774 WordPress \uc778\uc2a4\ud134\uc2a4\uac00 Bitnami\ub85c \ub418\uc5b4 \uc788\uc5b4\uc11c \uc138\ubd80\uc801\uc778 \uad00\ub9ac \uc791\uc5c5\uc5d0\ub294 \uc81c\uc57d\uc774 \ub9ce\ub2e4\ub294 \uc810\uc774\ub2e4. \uadf8\ub798\uc11c AWS\uc5d0 \ucd5c\uc801\ud654 \ub418\uc5b4\u2026","rel":"","context":"&quot;Linux&quot;\uc5d0\uc11c","block_context":{"text":"Linux","link":"https:\/\/litcoder.com\/?cat=4"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/litcoder.com\/wp-content\/uploads\/2026\/02\/lightsail_https_port.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/litcoder.com\/wp-content\/uploads\/2026\/02\/lightsail_https_port.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/litcoder.com\/wp-content\/uploads\/2026\/02\/lightsail_https_port.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/litcoder.com\/wp-content\/uploads\/2026\/02\/lightsail_https_port.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":4719,"url":"https:\/\/litcoder.com\/?p=4719","url_meta":{"origin":495,"position":1},"title":"WordPress &#8220;\ub2e4\ub978 \uc5c5\ub370\uc774\ud2b8\uac00 \uc9c4\ud589\uc911 \uc785\ub2c8\ub2e4&#8221; \ubb38\uc81c \ud574\uacb0","author":"litcoder","date":"2026\ub144 9\uc6d4 9\uc77c","format":false,"excerpt":"Wordpress\uc758 \uc0c8\ub85c\uc6b4 \ubc84\uc804\uc774 \ub098\uc640\uc11c \uc5c5\ub370\uc774\ud2b8\ub97c \uc2dc\ub3c4\ud588\ub294\ub370, \uc544\ubb34\ub7f0 \uc751\ub2f5\uc774 \uc5c6\ub354\ub2c8 \ub2e4\uc2dc \uc5c5\ub370\uc774\ud2b8 \uba54\ub274\ub85c \ub4e4\uc5b4\uac14\uc744 \ub54c \uc774 \uc0c1\ud0dc\uc600\ub2e4. \ud639\uc2dc\ub098 \ud558\ub294 \ub9c8\uc74c\uc5d0 5\ubd84 \uc815\ub3c4\ub97c \uae30\ub2e4\ub838\ub2e4\uac00 \ub2e4\uc2dc \ub4e4\uc5b4\uac00 \ubd24\uc744 \ub54c\ub3c4 \ub9c8\ucc2c\uac00\uc9c0 \uc600\ub2e4. Wordpress\ub294 \uc911\ubcf5\ub41c \ubc84\uc804 \uc5c5\ub370\uc774\ud2b8 \uc2dc\ub3c4\ub97c \ub9c9\uae30 \uc704\ud574\uc11c lock\uc744 \uac78\uace0 \uc5c5\ub370\uc774\ud2b8\uac00 \ub05d\ub098\uba74 \uc774\uac83\uc744 \ud574\uc81c \ud558\ub294\ub370 \uc5b4\ub5a4 \uc774\uc720\uc5d0\uc11c \uc778\uc9c0 \uc911\uac04\uc5d0 \ubc1c\uc0dd\ud55c \uc624\ub958\ub85c lock\uc774 \ud480\ub9ac\uc9c0\u2026","rel":"","context":"&quot;Linux&quot;\uc5d0\uc11c","block_context":{"text":"Linux","link":"https:\/\/litcoder.com\/?cat=4"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/litcoder.com\/wp-content\/uploads\/2026\/08\/sc_wp_update_err.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":718,"url":"https:\/\/litcoder.com\/?p=718","url_meta":{"origin":495,"position":2},"title":"PlantUML war file \uc124\uce58","author":"litcoder","date":"2013\ub144 9\uc6d4 16\uc77c","format":false,"excerpt":"\uadf8\ub3d9\uc548 UML\uc744 \uadf8\ub824\uc57c\ud560 \ud544\uc694\uac00 \uc788\uc744\ub54c StarUML\uc744 \uc368\uc654\ub294\ub370, Windows\ub9cc \uc9c0\uc6d0\ud558\ub294 software\ub77c\ub294 \ud55c\uacc4\ub3c4 \uc788\uace0 \ud574\uc11c \uc5bc\ub9c8 \uc804 \ubd80\ud130\ub294 \uc6b0\uc5f0\ud788 \uc54c\uac8c\ub41c PlantUML\uc744 \uc0ac\uc6a9\ud558\uace0 \uc788\ub2e4. \uc774 software\ub294 \ub9c8\uce58 LaTex \ucc98\ub7fc text\ub85c UML\uc744 \uadf8\ub9ac\uae30 \uc704\ud55c description\uc744 \uc791\uc131\ud558\uba74 \uc774\ub97c \uae30\ubc18\ud574\uc11c UML\uc744 \uadf8\ub824\uc900\ub2e4. \ubb38\ubc95\ub3c4 \uadf8\ub2e4\uc9c0 \uc5b4\ub835\uc9c0 \uc54a\uace0 \uc9c1\uad00\uc801\uc774\uc5b4\uc11c \uc0ac\uc6a9\ud558\uae30\ub3c4 \uc26c\uc6b4 \ud3b8\uc774\ub2e4. \uc791\uc131\ud55c text\ub97c UML\ub85c \uadf8\ub9ac\uae30 \uc704\ud55c client\u2026","rel":"","context":"&quot;Linux&quot;\uc5d0\uc11c","block_context":{"text":"Linux","link":"https:\/\/litcoder.com\/?cat=4"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/litcoder.com\/wp-content\/uploads\/2013\/08\/SC_plantuml_server_page.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/litcoder.com\/wp-content\/uploads\/2013\/08\/SC_plantuml_server_page.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/litcoder.com\/wp-content\/uploads\/2013\/08\/SC_plantuml_server_page.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/litcoder.com\/wp-content\/uploads\/2013\/08\/SC_plantuml_server_page.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":4286,"url":"https:\/\/litcoder.com\/?p=4286","url_meta":{"origin":495,"position":3},"title":"OpenProject\ub97c Docker\ub85c \uc124\uce58","author":"litcoder","date":"2026\ub144 4\uc6d4 8\uc77c","format":false,"excerpt":"\ud504\ub85c\uc81d\ud2b8 \uad00\ub9ac \ub3c4\uad6c\ub85c \ub9ce\uc774 \uc0ac\uc6a9\ub418\ub294 Atlassian\uc758 JIRA\ub97c \ub300\uccb4\ud558\uae30 \uc704\ud55c \uc624\ud508\uc18c\uc2a4 \ud504\ub85c\uc81d\ud2b8\ub4e4 \uc911 \uac00\uc7a5 \uc778\uae30\uac00 \uc788\ub2e4\ub294 OpenProject\ub97c \ud68c\uc0ac\uc5d0\uc11c \uc9c4\ud589\ud558\ub294 \ud504\ub85c\uc81d\ud2b8\ub97c \uc704\ud574 \uc0ac\uc6a9\ud574 \ubcf4\uae30\ub85c \ud588\ub2e4. Docker\ub85c \uc124\uce58\ud558\uae30 \uc900\ube44 Source code clone OpenProject\ub294 GitHub repo\uc5d0\uc11c tag\uac00 \uc544\ub2cc branch\uba85\uc744 stable\/<version> \ud615\uc2dd\uc73c\ub85c \ub9b4\ub9ac\uc988\ud558\uace0 \uc788\ub294 \ub4ef \ud558\ub2e4. 2026\ub144 4\uc6d4 \ud604\uc7ac \uac00\uc7a5 \ucd5c\uc2e0 \ubc84\uc804\uc778 17\ubc84\uc804\uc744 \ub2e4\uc74c\uacfc \uac19\uc774\u2026","rel":"","context":"&quot;Linux&quot;\uc5d0\uc11c","block_context":{"text":"Linux","link":"https:\/\/litcoder.com\/?cat=4"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/litcoder.com\/wp-content\/uploads\/2026\/03\/openproject17_login.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/litcoder.com\/wp-content\/uploads\/2026\/03\/openproject17_login.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/litcoder.com\/wp-content\/uploads\/2026\/03\/openproject17_login.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":563,"url":"https:\/\/litcoder.com\/?p=563","url_meta":{"origin":495,"position":4},"title":"OpenGrok \uc124\uce58","author":"litcoder","date":"2013\ub144 3\uc6d4 9\uc77c","format":false,"excerpt":"OpenGrok\uc744 \uc124\uce58\ud558\ub294 \uac00\uc7a5 \uac04\ub2e8\ud55c \ubc29\ubc95\uc740 tomcat5~6 \uc0ac\uc774\uc758 \ubc84\uc804\uc744 \uc0ac\uc6a9\ud558\uace0, \uc124\uce58\ud558\ub294 \uc704\uce58\ub97c \/var\/opengrok \uc73c\ub85c \uc815\ud558\ub294 \uac83\uc774\ub2e4. \uc774\ub807\uac8c \ud558\uba74 \ubcc4\ub3c4\uc758 \uc218\uc815\uc5c6\uc774 \uac70\uc758 \uadf8\ub300\ub85c OpenGrok\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4. (OpenGrok \uc124\uce58 \ube68\ub9ac \ud558\uae30 \ucc38\uc870) \uc774 posting\uc5d0\uc11c\ub294 Source\ub97c <YOUR_SOURCE_REPOSITORY_TOP> \uacbd\ub85c \uc544\ub798\uc5d0 \uac01 project\ubcc4\ub85c \ub530\ub85c \ubcf4\uad00\ud558\uace0, <YOUR_HOME_DIRECTORY>\/opengrok \uacbd\ub85c \uc544\ub798\uc5d0 OpenGrok\uacfc \uad00\ub828\ub41c file\ub4e4\uc744 \ubcf4\uad00\ud558\ub294 \uc0c1\ud669\uc744 \uac00\uc815\ud558\uace0 \uc124\uba85\ud55c\ub2e4.\u2026","rel":"","context":"&quot;Linux&quot;\uc5d0\uc11c","block_context":{"text":"Linux","link":"https:\/\/litcoder.com\/?cat=4"},"img":{"alt_text":"OpenGrok ScreenShot","src":"https:\/\/i0.wp.com\/litcoder.com\/wp-content\/uploads\/2013\/03\/Screenshot-from-2013-03-09-232044_opengrok-300x241.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":908,"url":"https:\/\/litcoder.com\/?p=908","url_meta":{"origin":495,"position":5},"title":"Repo\uc640 OpenGrok update\ub97c \uc704\ud55c cron\uc6a9 script","author":"litcoder","date":"2013\ub144 11\uc6d4 19\uc77c","format":false,"excerpt":"OpenGrok\uc740 \uc5ec\ub7ec\uba74\uc5d0\uc11c \uc88b\uc740 \uc810\uc774 \ub9ce\uc740 \ub3c4\uad6c\uc774\uc9c0\ub9cc source code\uac00 \ubcc0\uacbd\ub420 \ub54c\ub9c8\ub2e4 \uc624\ub79c\uc2dc\uac04\uc774 \uac78\ub9ac\ub294 indexing\uc744 \ud574\uc57c \ud55c\ub2e4\ub294 \uc810\uc740 \ubd88\ud3b8 \ud55c \uc810 \uc911 \ud558\ub098\uc774\ub2e4. \uc5ec\uae30\uc11c\ub294 cron\uc73c\ub85c \ub3cc\ub9b4 \uc218 \uc788\ub294 \uac04\ub2e8\ud55c shell script\ub97c \uc0ac\uc6a9\ud574\uc11c \ud55c\uac00\ud55c \uc2dc\uac04\uc5d0 source\uac00 \ucd5c\uc2e0\uc73c\ub85c \uc720\uc9c0\ub420 \uc218 \uc788\ub3c4\ub85d \ud558\ub294 \ubc29\ubc95\uc744 \uc124\uba85\ud55c\ub2e4. Cron runnable update script Cron\uc73c\ub85c \ub3d9\uc791\uc2dc\ud0a4\ub294 script\ub97c \uc791\uc131\ud560 \ub54c \uac00\uc7a5\u2026","rel":"","context":"&quot;Programming&quot;\uc5d0\uc11c","block_context":{"text":"Programming","link":"https:\/\/litcoder.com\/?cat=5"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_featured_media_url":"","_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}]}}