{"id":262,"date":"2013-12-25T11:37:39","date_gmt":"2013-12-25T03:37:39","guid":{"rendered":"https:\/\/yanjingang.com\/blog\/?p=262"},"modified":"2017-12-28T23:21:29","modified_gmt":"2017-12-28T15:21:29","slug":"mysql%e7%99%bb%e9%99%86%e5%af%86%e7%a0%81%e5%bf%98%e8%ae%b0%e6%80%8e%e4%b9%88%e5%8a%9e","status":"publish","type":"post","link":"https:\/\/yanjingang.com\/blog\/?p=262","title":{"rendered":"MySql\u767b\u9646\u5bc6\u7801\u5fd8\u8bb0\u600e\u4e48\u529e?"},"content":{"rendered":"<div>\u53ef\u4ee5\u8fdb\u884c\u5982\u4e0b\u7684\u6b65\u9aa4\u91cd\u65b0\u8bbe\u7f6eMySQL\u7684root\u5bc6\u7801\uff1a<\/div>\n<p>1\uff0e\u9996\u5148\u786e\u8ba4\u670d\u52a1\u5668\u51fa\u4e8e\u5b89\u5168\u7684\u72b6\u6001\uff0c\u4e5f\u5c31\u662f\u6ca1\u6709\u4eba\u80fd\u591f\u4efb\u610f\u5730\u8fde\u63a5MySQL\u6570\u636e\u5e93\u3002\u56e0\u4e3a\u5728\u91cd\u65b0\u8bbe\u7f6eMySQL\u7684root\u5bc6\u7801\u7684\u671f\u95f4\uff0cMySQL\u6570\u636e\u5e93\u5b8c\u5168\u51fa\u4e8e\u6ca1\u6709\u5bc6\u7801\u4fdd\u62a4\u7684\u72b6\u6001\u4e0b\uff0c\u5176\u4ed6\u7684\u7528\u6237\u4e5f\u53ef\u4ee5\u4efb\u610f\u5730\u767b\u5f55\u548c\u4fee\u6539MySQL\u7684\u4fe1\u606f\u3002\u53ef\u4ee5\u91c7\u7528\u5c06MySQL\u5bf9\u5916\u7684\u7aef\u53e3\u5c01\u95ed\uff0c\u5e76\u4e14\u505c\u6b62Apache\u4ee5\u53ca\u6240\u6709\u7684\u7528\u6237\u8fdb\u7a0b\u7684\u65b9\u6cd5\u5b9e\u73b0\u670d\u52a1\u5668\u7684\u51c6\u5b89\u5168\u72b6\u6001\u3002<br \/>\n2\uff0e\u4fee\u6539MySQL\u7684\u767b\u5f55\u8bbe\u7f6e\uff1a<br \/>\n# vi \/etc\/my.cnf<br \/>\n\u5728[mysqld]\u7684\u6bb5\u4e2d\u52a0\u4e0a\u4e00\u53e5\uff1askip-grant-tables<br \/>\n\u4f8b\u5982\uff1a<br \/>\n[mysqld]<br \/>\ndatadir=\/var\/lib\/mysql<br \/>\nsocket=\/var\/lib\/mysql\/mysql.sock<br \/>\nskip-name-resolve<br \/>\nskip-grant-tables<br \/>\n\u4fdd\u5b58\u5e76\u4e14\u9000\u51favi\u3002<br \/>\n3\uff0e\u91cd\u65b0\u542f\u52a8mysqld<br \/>\n# \/etc\/init.d\/mysqld restart<br \/>\nStopping MySQL: [ OK ]<br \/>\nStarting MySQL: [ OK ]<br \/>\n4\uff0e\u767b\u5f55\u5e76\u4fee\u6539MySQL\u7684root\u5bc6\u7801<br \/>\n# \/usr\/bin\/mysql<br \/>\nWelcome to the MySQL monitor. Commands end with ; or \\g. Your MySQL connection id is 3 to server version: 3.23.56 Type \u2018help;\u2019 or \u2018\\h\u2019 for help.Type \u2018\\c\u2019 to clear the buffer.<br \/>\nmysql&gt; USE mysql ;<br \/>\nReading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A<br \/>\nDatabase changed<br \/>\nmysql&gt; UPDATE user SET Password = password ( \u2018new-password\u2019 ) WHERE User = \u2018root\u2019 ;<br \/>\nQuery OK, 0 rows affected (0.00 sec)<br \/>\nRows matched: 2 Changed: 0 Warnings: 0<br \/>\nmysql&gt; flush privileges ;<br \/>\nQuery OK, 0 rows affected (0.01 sec)<br \/>\nmysql&gt; quit<br \/>\nBye<br \/>\n5\uff0e\u5c06MySQL\u7684\u767b\u5f55\u8bbe\u7f6e\u4fee\u6539\u56de\u6765<br \/>\n# vi \/etc\/my.cnf<br \/>\n\u5c06\u521a\u624d\u5728[mysqld]\u7684\u6bb5\u4e2d\u52a0\u4e0a\u7684skip-grant-tables\u5220\u9664\uff0c\u4fdd\u5b58\u5e76\u4e14\u9000\u51favi\u3002<br \/>\n6\uff0e\u91cd\u65b0\u542f\u52a8mysqld<br \/>\n# \/etc\/init.d\/mysqld restart<br \/>\nStopping MySQL: [ OK ]<br \/>\nStarting MySQL: [ OK ]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u53ef\u4ee5\u8fdb\u884c\u5982\u4e0b\u7684\u6b65\u9aa4\u91cd\u65b0\u8bbe\u7f6eMySQL\u7684root\u5bc6\u7801\uff1a 1\uff0e\u9996\u5148\u786e\u8ba4\u670d\u52a1\u5668\u51fa\u4e8e\u5b89\u5168\u7684\u72b6\u6001\uff0c\u4e5f\u5c31\u662f\u6ca1\u6709\u4eba\u80fd\u591f\u4efb\u610f\u5730 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7],"tags":[8,185],"_links":{"self":[{"href":"https:\/\/yanjingang.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/262"}],"collection":[{"href":"https:\/\/yanjingang.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yanjingang.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yanjingang.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yanjingang.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=262"}],"version-history":[{"count":0,"href":"https:\/\/yanjingang.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/262\/revisions"}],"wp:attachment":[{"href":"https:\/\/yanjingang.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=262"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yanjingang.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=262"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yanjingang.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=262"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}