{"id":13,"date":"2013-09-30T19:43:17","date_gmt":"2013-09-30T15:43:17","guid":{"rendered":"http:\/\/itblog.alifer.pro\/?p=13"},"modified":"2013-10-14T17:19:23","modified_gmt":"2013-10-14T13:19:23","slug":"%d1%81%d0%b1%d1%80%d0%be%d1%81-%d0%bf%d0%b0%d1%80%d0%be%d0%bb%d1%8f-root-%d0%b2-mysql","status":"publish","type":"post","link":"https:\/\/it-notes.alifer.su\/?p=13","title":{"rendered":"\u0421\u0431\u0440\u043e\u0441 \u043f\u0430\u0440\u043e\u043b\u044f root \u0432 MySQL"},"content":{"rendered":"<p>1). \u041e\u0441\u0442\u0430\u043d\u0430\u0432\u043b\u0438\u0432\u0430\u0435\u043c \u0441\u043b\u0443\u0436\u0431\u0443 MySQL:<br \/>\n<code>\/etc\/init.d\/mysql stop<\/code><br \/>\n<code>Stopping MySQL database server: mysqld.<\/code><\/p>\n<p>2). \u0417\u0430\u043f\u0443\u0441\u043a\u0430\u0435\u043c \u0441\u043b\u0443\u0436\u0431\u0443 \u0441 \u043e\u043f\u0446\u0438\u0435\u0439 &#8212;skip-grant-tables<br \/>\n<code>mysqld_safe --skip-grant-tables &amp;<\/code><\/p>\n<p>3). \u041f\u043e\u0434\u043a\u043b\u044e\u0447\u0430\u0435\u043c\u0441\u044f \u0441 \u0441\u0435\u0440\u0432\u0435\u0440\u0443 MySQL \u043f\u0440\u0438 \u043f\u043e\u043c\u043e\u0449\u0438 \u043a\u043b\u0438\u0435\u043d\u0442\u0430 mysql:<br \/>\n<code>mysql -u root<\/code><br \/>\n<code>...<\/code><br \/>\n<code>Type 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.<\/code><br \/>\n<code>mysql&gt;<\/code><\/p>\n<p>4). \u0412\u0432\u043e\u0434\u0438\u043c \u043d\u043e\u0432\u044b\u0439 \u043f\u0430\u0440\u043e\u043b\u044c \u0434\u043b\u044f root:<br \/>\n<code>mysql&gt; use mysql;<\/code><br \/>\n<code>mysql&gt; update user set password=PASSWORD(\"NEW-ROOT-PASSWORD\") where User='root';<\/code><br \/>\n<code>mysql&gt; flush privileges;<\/code><br \/>\n<code>mysql&gt; quit<\/code><\/p>\n<p>5). \u041e\u0441\u0442\u0430\u043d\u0430\u0432\u043b\u0438\u0432\u0430\u0435\u043c \u0441\u0435\u0440\u0432\u0435\u0440 MySQL:<br \/>\n<code>\/etc\/init.d\/mysql stop<\/code><br \/>\n<code>Stopping MySQL database server: mysqld<\/code><br \/>\n<code>STOPPING server from pid file \/var\/run\/mysqld\/mysqld.pid<\/code><br \/>\n<code>mysqld_safe[6186]: ended<\/code><br \/>\n<code>[1]+ Done mysqld_safe --skip-grant-table<\/code><\/p>\n<p>6). \u0417\u0430\u043f\u0443\u0441\u043a\u0430\u0435\u043c MySQL-\u0441\u0435\u0440\u0432\u0435\u0440 \u0438 \u043b\u043e\u0433\u0438\u043d\u0438\u043c\u0441\u044f \u0441 \u043d\u043e\u0432\u044b\u043c \u043f\u0430\u0440\u043e\u043b\u0435\u043c:<br \/>\n<code>\/etc\/init.d\/mysql start<\/code><br \/>\n<code>mysql -u root -p<\/code><\/p>\n<p>(http:\/\/www.youisbee.ru\/howto\/mysql\/66-ustanovka-izmenenie-i-sbros-parolya-root-v-mysql.html)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1). \u041e\u0441\u0442\u0430\u043d\u0430\u0432\u043b\u0438\u0432\u0430\u0435\u043c \u0441\u043b\u0443\u0436\u0431\u0443 MySQL: \/etc\/init.d\/mysql stop Stopping MySQL database server: mysqld. 2). \u0417\u0430\u043f\u0443\u0441\u043a\u0430\u0435\u043c \u0441\u043b\u0443\u0436\u0431\u0443 \u0441 \u043e\u043f\u0446\u0438\u0435\u0439 &#8212;skip-grant-tables mysqld_safe &#8212;skip-grant-tables &amp; 3). \u041f\u043e\u0434\u043a\u043b\u044e\u0447\u0430\u0435\u043c\u0441\u044f \u0441 \u0441\u0435\u0440\u0432\u0435\u0440\u0443 MySQL \u043f\u0440\u0438 \u043f\u043e\u043c\u043e\u0449\u0438 \u043a\u043b\u0438\u0435\u043d\u0442\u0430 mysql: mysql -u root &#8230; Type &#8216;help;&#8217; or &#8216;\\h&#8217; for help. Type &#8216;\\c&#8217; to clear the current input statement. mysql&gt; 4). \u0412\u0432\u043e\u0434\u0438\u043c \u043d\u043e\u0432\u044b\u0439 \u043f\u0430\u0440\u043e\u043b\u044c \u0434\u043b\u044f root: mysql&gt;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-13","post","type-post","status-publish","format-standard","hentry","category-nix"],"_links":{"self":[{"href":"https:\/\/it-notes.alifer.su\/index.php?rest_route=\/wp\/v2\/posts\/13","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/it-notes.alifer.su\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/it-notes.alifer.su\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/it-notes.alifer.su\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/it-notes.alifer.su\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=13"}],"version-history":[{"count":13,"href":"https:\/\/it-notes.alifer.su\/index.php?rest_route=\/wp\/v2\/posts\/13\/revisions"}],"predecessor-version":[{"id":41,"href":"https:\/\/it-notes.alifer.su\/index.php?rest_route=\/wp\/v2\/posts\/13\/revisions\/41"}],"wp:attachment":[{"href":"https:\/\/it-notes.alifer.su\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/it-notes.alifer.su\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=13"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/it-notes.alifer.su\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}