{"id":364,"date":"2020-08-24T03:34:56","date_gmt":"2020-08-23T19:34:56","guid":{"rendered":"http:\/\/log.tanxiaodian.com\/?p=364"},"modified":"2021-06-23T01:31:10","modified_gmt":"2021-06-22T17:31:10","slug":"mysql%e7%bb%99root%e5%bc%80%e5%90%af%e8%bf%9c%e7%a8%8b%e8%ae%bf%e9%97%ae%e6%9d%83%e9%99%90","status":"publish","type":"post","link":"https:\/\/log.tanxiaodian.com\/?p=364","title":{"rendered":"mysql\u7ed9root\u5f00\u542f\u8fdc\u7a0b\u8bbf\u95ee\u6743\u9650"},"content":{"rendered":"<p>https:\/\/blog.csdn.net\/konglongaa\/article\/details\/80996829<\/p>\n<p>.\u5728\u8fde\u63a5\u670d\u52a1\u5668\u540e,\u64cd\u4f5cmysql\u7cfb\u7edf\u6570\u636e\u5e93<\/p>\n<p>\u547d\u4ee4\u4e3a\uff1a\u00a0 mysql -u root -p<\/p>\n<p>use mysql;<\/p>\n<p><img src=\"https:\/\/images2018.cnblogs.com\/blog\/1192534\/201804\/1192534-20180411174621164-219720033.png\" alt=\"\" \/><\/p>\n<p>\u67e5\u8be2\u7528\u6237\u8868\u547d\u4ee4\uff1aselect\u00a0 User,authentication_string,Host from user<\/p>\n<p><img src=\"https:\/\/images2018.cnblogs.com\/blog\/1192534\/201804\/1192534-20180411174816526-300449753.png\" alt=\"\" \/><\/p>\n<p>\u8fd9\u91cc\u4e5f\u53ef\u4ee5\u770b\u51fahost\u9ed8\u8ba4\u90fd\u662flocalhost\u8bbf\u95ee\u6743\u9650<\/p>\n<p>\u63a5\u4e0b\u6765\u5c31\u662f\u6700\u91cd\u8981\u7684\u90e8\u5206\u4e86\uff1a<\/p>\n<p>1. GRANT ALL PRIVILEGES ON *.* TO &#8216;root&#8217;@&#8217;%&#8217; IDENTIFIED BY &#8216;123456&#8217;;<\/p>\n<p>\u8fd9\u91cc\u7684123456\u4e3a\u4f60\u7ed9\u65b0\u589e\u6743\u9650\u7528\u6237\u8bbe\u7f6e\u7684\u5bc6\u7801\uff0c%\u4ee3\u8868\u6240\u6709\u4e3b\u673a\uff0c\u4e5f\u53ef\u4ee5\u5177\u4f53\u5230\u4f60\u7684\u4e3b\u673aip\u5730\u5740<\/p>\n<p>2.flush privileges;\u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u8fd9\u4e00\u6b65\u4e00\u5b9a\u8981\u505a\uff0c\u4e0d\u7136\u65e0\u6cd5\u6210\u529f\uff01 \u8fd9\u53e5\u8868\u793a\u4ecemysql\u6570\u636e\u5e93\u7684grant\u8868\u4e2d\u91cd\u65b0\u52a0\u8f7d\u6743\u9650\u6570\u636e<\/p>\n<p>\u56e0\u4e3aMySQL\u628a\u6743\u9650\u90fd\u653e\u5728\u4e86cache\u4e2d\uff0c\u6240\u4ee5\u5728\u505a\u5b8c\u66f4\u6539\u540e\u9700\u8981\u91cd\u65b0\u52a0\u8f7d\u3002<\/p>\n<p>\u6267\u884c\u5b8c\u8fd9\u4e24\u6b65\uff0c\u518d\u6b21\u67e5\u8be2\u7528\u6237\u8868\u547d\u4ee4\uff1aselect\u00a0 User,authentication_string,Host from user<\/p>\n<p><img src=\"https:\/\/images2018.cnblogs.com\/blog\/1192534\/201804\/1192534-20180411175448459-1101644685.png\" alt=\"\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>https:\/\/blog.csdn.net\/kon&#8230;<\/p>\n<div class=\"more-link-wrapper\"><a class=\"more-link\" href=\"https:\/\/log.tanxiaodian.com\/?p=364\">Continue reading<span class=\"screen-reader-text\">mysql\u7ed9root\u5f00\u542f\u8fdc\u7a0b\u8bbf\u95ee\u6743\u9650<\/span><\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[],"_links":{"self":[{"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=\/wp\/v2\/posts\/364"}],"collection":[{"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=364"}],"version-history":[{"count":3,"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=\/wp\/v2\/posts\/364\/revisions"}],"predecessor-version":[{"id":569,"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=\/wp\/v2\/posts\/364\/revisions\/569"}],"wp:attachment":[{"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/log.tanxiaodian.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}