{"id":1389,"date":"2025-10-17T17:14:25","date_gmt":"2025-10-17T09:14:25","guid":{"rendered":"http:\/\/learning.sino-vt.com:8988\/?p=1389"},"modified":"2025-10-17T17:14:25","modified_gmt":"2025-10-17T09:14:25","slug":"%e6%95%b0%e6%8d%ae%e5%ba%93%e4%b8%bb%e4%bb%8e%e9%85%8d%e7%bd%ae%e5%90%8eslave_io_running%e7%8a%b6%e6%80%81%e4%b8%baconnecting","status":"publish","type":"post","link":"http:\/\/learning.sino-vt.com:8988\/index.php\/2025\/10\/17\/%e6%95%b0%e6%8d%ae%e5%ba%93%e4%b8%bb%e4%bb%8e%e9%85%8d%e7%bd%ae%e5%90%8eslave_io_running%e7%8a%b6%e6%80%81%e4%b8%baconnecting\/","title":{"rendered":"\u6570\u636e\u5e93\u4e3b\u4ece\u914d\u7f6e\u540eSlave_IO_Running\u72b6\u6001\u4e3aConnecting"},"content":{"rendered":"<p>\u4e2a\u522b\u9879\u76ee\u6709\u8981\u6c42\u6570\u636e\u5e93\u505a\u4e3b\u4ece\u540c\u6b65\uff0c\u5f00\u53d1\u5df2\u7ecf\u63d0\u4f9b\u4e86\u300a\u5173\u4e8eMysql\u9ad8\u53ef\u7528\u90e8\u7f72\u89e3\u51b3\u65b9\u6848.docx\u300b\u6587\u6863\uff0c\u4f46\u6839\u636e\u6587\u6863\u64cd\u4f5c\u540e\uff0c\u5982\u679c\u4f7f\u7528SHOW SLAVE STATUS\\G;\u547d\u4ee4\u67e5\u5230\u7684Slave_IO_Running\u72b6\u6001\u4e3aConnecting\uff0c\uff08\u5982\u4e0b\u56fe\uff09<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1390\" src=\"http:\/\/learning.sino-vt.com:8988\/wp-content\/uploads\/2025\/10\/\u5fae\u4fe1\u56fe\u7247_2025-10-17_171112_801.png\" alt=\"\" width=\"646\" height=\"699\" srcset=\"http:\/\/learning.sino-vt.com:8988\/wp-content\/uploads\/2025\/10\/\u5fae\u4fe1\u56fe\u7247_2025-10-17_171112_801.png 646w, http:\/\/learning.sino-vt.com:8988\/wp-content\/uploads\/2025\/10\/\u5fae\u4fe1\u56fe\u7247_2025-10-17_171112_801-277x300.png 277w\" sizes=\"auto, (max-width: 646px) 100vw, 646px\" \/><\/p>\n<p>\u4e00\u822c\u662f\u56e0\u4e3a\u4e3b\u8282\u70b9\u7684root\u7528\u6237\u6216\u8005\u6307\u5b9a\u7684\u7528\u6237\u6ca1\u6709\u6388\u6743\u590d\u5236\u6743\u9650\uff0c\u9700\u8981\u5728\u4e3b\u8282\u70b9\u6388\u6743\u540e\uff0c\u4ece\u8282\u70b9\u91cd\u542fslave\u5373\u53ef\u3002<\/p>\n<p>\u64cd\u4f5c\u65b9\u6cd5\uff1a<\/p>\n<p>1\u3001\u67e5\u770b\u662f\u5426\u6709\u590d\u5236\u6743\u9650\uff1aSELECT user, host, Repl_slave_priv FROM mysql.user WHERE user = &#8216;root&#8217; AND host = &#8216;%&#8217;;<\/p>\n<p>\u7ed3\u679c\u4e2dRepl_slave_priv\u5b57\u6bb5\u9700\u8981\u65f6yes<\/p>\n<p>2\u3001\u6388\u6743<\/p>\n<p>GRANT REPLICATION SLAVE ON *.* TO &#8216;root&#8217;@&#8217;%&#8217;;<\/p>\n<p>FLUSH PRIVILEGES;<\/p>\n<p>3\u3001\u4ece\u8282\u70b9\u91cd\u65b0\u505c\u6b62\u518d\u5f00\u542fslave\u3002<\/p>\n<p>stop slave;<\/p>\n<p>start slave;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e2a\u522b\u9879\u76ee\u6709\u8981\u6c42\u6570\u636e\u5e93\u505a\u4e3b\u4ece\u540c\u6b65\uff0c\u5f00\u53d1\u5df2\u7ecf\u63d0\u4f9b\u4e86\u300a\u5173\u4e8eMysql\u9ad8\u53ef\u7528\u90e8\u7f72\u89e3\u51b3\u65b9\u6848.docx\u300b\u6587\u6863\uff0c\u4f46\u6839\u636e\u6587\u6863\u64cd [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[21],"class_list":["post-1389","post","type-post","status-publish","format-standard","hentry","category-12","tag-mysql"],"_links":{"self":[{"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/posts\/1389","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/comments?post=1389"}],"version-history":[{"count":1,"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/posts\/1389\/revisions"}],"predecessor-version":[{"id":1391,"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/posts\/1389\/revisions\/1391"}],"wp:attachment":[{"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/media?parent=1389"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/categories?post=1389"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/learning.sino-vt.com:8988\/index.php\/wp-json\/wp\/v2\/tags?post=1389"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}