{"id":760,"date":"2019-05-08T23:43:57","date_gmt":"2019-05-08T15:43:57","guid":{"rendered":"http:\/\/www.eait.co\/?p=760"},"modified":"2022-01-10T16:54:45","modified_gmt":"2022-01-10T08:54:45","slug":"%e9%85%8d%e7%bd%aemysql%e5%85%81%e8%ae%b8%e8%bf%9c%e7%a8%8b%e8%bf%9e%e6%8e%a5%e7%9a%84%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/notes.coremix.net\/?p=760","title":{"rendered":"\u914d\u7f6emysql\u5141\u8bb8\u8fdc\u7a0b\u8fde\u63a5\u7684\u65b9\u6cd5"},"content":{"rendered":"<p>\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0cmysql\u53ea\u5141\u8bb8\u672c\u5730\u767b\u5f55\uff0c\u5982\u679c\u8981\u5f00\u542f\u8fdc\u7a0b\u8fde\u63a5\uff0c\u5219\u9700\u8981\u4fee\u6539\/etc\/mysql\/my.conf\u6587\u4ef6\u3002<\/p>\n<p><strong>\u4e00\u3001\u4fee\u6539\/etc\/mysql\/my.conf<\/strong><br \/>\n\u627e\u5230bind-address = 127.0.0.1\u8fd9\u4e00\u884c<br \/>\n\u6539\u4e3abind-address = 0.0.0.0\u5373\u53ef<\/p>\n<p><strong>\u4e8c\u3001\u4e3a\u9700\u8981\u8fdc\u7a0b\u767b\u5f55\u7684\u7528\u6237\u8d4b\u4e88\u6743\u9650<\/strong><br \/>\n1\u3001\u65b0\u5efa\u7528\u6237\u8fdc\u7a0b\u8fde\u63a5mysql\u6570\u636e\u5e93<br \/>\ngrant all on *.* to admin@&#8217;%&#8217; identified by &#8216;123456&#8217; with grant option;<br \/>\nflush privileges;<br \/>\n\u5141\u8bb8\u4efb\u4f55ip\u5730\u5740(%\u8868\u793a\u5141\u8bb8\u4efb\u4f55ip\u5730\u5740)\u7684\u7535\u8111\u7528admin\u5e10\u6237\u548c\u5bc6\u7801(123456)\u6765\u8bbf\u95ee\u8fd9\u4e2amysql server\u3002<br \/>\n\u6ce8\u610fadmin\u8d26\u6237\u4e0d\u4e00\u5b9a\u8981\u5b58\u5728\u3002<\/p>\n<p>2\u3001\u652f\u6301root\u7528\u6237\u5141\u8bb8\u8fdc\u7a0b\u8fde\u63a5mysql\u6570\u636e\u5e93<br \/>\ngrant all privileges on *.* to &#8216;root&#8217;@&#8217;%&#8217; identified by &#8216;123456&#8217; with grant option;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0cmysql\u53ea\u5141\u8bb8\u672c\u5730\u767b\u5f55\uff0c\u5982\u679c\u8981\u5f00\u542f\u8fdc\u7a0b\u8fde\u63a5\uff0c\u5219\u9700\u8981\u4fee\u6539\/etc\/mysql\/my.conf\u6587\u4ef6\u3002 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,29],"tags":[10],"class_list":["post-760","post","type-post","status-publish","format-standard","hentry","category-other","category-29","tag-linux"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/notes.coremix.net\/index.php?rest_route=\/wp\/v2\/posts\/760","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/notes.coremix.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/notes.coremix.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/notes.coremix.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/notes.coremix.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=760"}],"version-history":[{"count":1,"href":"https:\/\/notes.coremix.net\/index.php?rest_route=\/wp\/v2\/posts\/760\/revisions"}],"predecessor-version":[{"id":761,"href":"https:\/\/notes.coremix.net\/index.php?rest_route=\/wp\/v2\/posts\/760\/revisions\/761"}],"wp:attachment":[{"href":"https:\/\/notes.coremix.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=760"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/notes.coremix.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=760"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/notes.coremix.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=760"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}