{"id":218,"date":"2008-06-27T16:11:19","date_gmt":"2008-06-27T20:11:19","guid":{"rendered":"http:\/\/www.eyoungwon.com\/journal\/?p=218"},"modified":"2008-07-07T09:51:56","modified_gmt":"2008-07-07T13:51:56","slug":"reset-root-password-on-mysql-server","status":"publish","type":"post","link":"https:\/\/eyoungwon.com\/journal\/reset-root-password-on-mysql-server\/","title":{"rendered":"Reset root password on MySQL Server"},"content":{"rendered":"<pre>[root@host root]# <strong>mysql<\/strong> Welcome to the MySQL monitor.<\/pre>\n<pre>Commands end with ; or g. Your MySQL connection id is 1 to server<\/pre>\n<pre>version: 3.23.41<\/pre>\n<pre>Type 'help;' or 'h' for help. Type 'c' to clear the buffer.<\/pre>\n<pre>mysql&gt; <strong>USE mysql<\/strong> Reading table information for completion of table and c<\/pre>\n<pre>olumn names You can turn off this feature to get a quicker startup<\/pre>\n<pre>with -A Database changed<\/pre>\n<pre>mysql&gt; <strong>UPDATE user<\/strong> -&gt; <strong>SET password=password(\"newpassword\")<\/strong> -&gt; <strong>WHERE user=\"root\";<\/strong><\/pre>\n<pre>Query OK, 2 rows affected (0.04 sec) Rows matched: 2  Changed: 2  Warnings: 0<\/pre>\n<pre>mysql&gt; <strong>flush privileges;<\/strong> Query OK, 0 rows affected (0.01 sec)<\/pre>\n<pre>mysql&gt; <strong>exit;<\/strong> [root@host root]#<strong>killall mysqld<\/strong><\/pre>\n<pre>Start MySQL the normal way for your system, and all is good.\r\n<table bgcolor=\"#e0e0e0\" border=\"0\" width=\"100%\"><tbody>\r\n<tr>\r\n<td>\r\n<pre><strong>\/etc\/init.d\/mysqld start<\/strong><\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>[root@host root]# mysql Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 1 to server version: 3.23.41 Type &#8216;help;&#8217; or &#8216;h&#8217; for help. Type &#8216;c&#8217; to clear the buffer. mysql&gt; USE mysql Reading table information for completion of table and c olumn names You can turn off this [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38,2],"tags":[],"class_list":["post-218","post","type-post","status-publish","format-standard","hentry","category-mysql","category-web-development"],"_links":{"self":[{"href":"https:\/\/eyoungwon.com\/journal\/wp-json\/wp\/v2\/posts\/218","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eyoungwon.com\/journal\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eyoungwon.com\/journal\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eyoungwon.com\/journal\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eyoungwon.com\/journal\/wp-json\/wp\/v2\/comments?post=218"}],"version-history":[{"count":0,"href":"https:\/\/eyoungwon.com\/journal\/wp-json\/wp\/v2\/posts\/218\/revisions"}],"wp:attachment":[{"href":"https:\/\/eyoungwon.com\/journal\/wp-json\/wp\/v2\/media?parent=218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eyoungwon.com\/journal\/wp-json\/wp\/v2\/categories?post=218"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eyoungwon.com\/journal\/wp-json\/wp\/v2\/tags?post=218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}