{"id":5496,"date":"2016-11-09T14:01:11","date_gmt":"2016-11-09T06:01:11","guid":{"rendered":"https:\/\/sdeno.com\/?p=5496"},"modified":"2016-11-16T00:35:24","modified_gmt":"2016-11-15T16:35:24","slug":"mysql%e5%85%81%e8%ae%b8%e8%bf%9c%e7%a8%8b%e8%bf%9e%e6%8e%a5","status":"publish","type":"post","link":"https:\/\/sdeno.com\/?p=5496","title":{"rendered":"\u89e3\u51b3\uff1aCan't connect to MySQL server on 10061 mysql\u5141\u8bb8\u8fdc\u7a0b\u8fde\u63a5"},"content":{"rendered":"<p>\u9ed8\u8ba4\u5b89\u88c5mysql\u65f6\uff0cmysql\u53ea\u80fd\u662f\u672c\u5730\u624d\u80fd\u8fde\u63a5\uff0c\u8981\u8ba9mysql\u5141\u8bb8\u8fdc\u7a0b\u8fde\u63a5\u64cd\u4f5c\u6570\u636e\u5e93\uff1a<\/p>\n<p>1\uff0c\u627e\u5230\/etc\/mysql\/my.cnf\u8fd9\u4e2a\u6587\u4ef6\uff0c\u5c06bind-address=127.0.0.1\u6539\u4e3a bind-address=0.0.0.0 \u6216\u5c06\u5176\u6ce8\u91ca\u6389<\/p>\n<p>\u53ef\u80fd\u5728\u6b64\u6587\u4ef6\/etc\/mysql\/mysql.conf.d\/mysqld.cnf<\/p>\n<p>&nbsp;<\/p>\n<p>2\uff0c\u66f4\u6539 \u201cmysql\u201d \u6570\u636e\u5e93\u91cc\u7684 \u201cuser\u201d \u8868\u91cc\u7684 \u201chost\u201d \u9879\uff0c\u4ece\u201dlocalhost\u201d\u6539\u79f0&#8217;%&#8217;\u3002 \u6216\u8005\u65b0\u52a0\u6761\u8bb0\u5f55\uff0c\u201chost\u201d \u9879\u4e3a\u8981\u8bbf\u95ee\u7684ip\u5730\u5740\uff0c\u5e76\u6388\u6743\u3002\u91cd\u542fmysql\u670d\u52a1\u3002<\/p>\n<p>\u6216\u8005\u5728mysql\u547d\u4ee4\u4e2d\u6267\u884c\u8fd9\u4e24\u884c\u8bed\u53e5<\/p>\n<pre>grant all on *.* to root@\"%\" identified by \"xxx\u5bc6\u7801\";\r\nflush privileges;<\/pre>\n<p>&nbsp;<\/p>\n<p>3\uff0c\u5728\u7cfb\u7edf\u9632\u706b\u5899\u6dfb\u52a0\u4f8b\u5916\u7aef\u53e3\uff1a3306\uff0c\u5e76\u5141\u8bb8\u4f8b\u5916<\/p>\n<p>\u91cd\u542fmysql<\/p>\n<pre>sudo \/etc\/init.d\/mysql restart<\/pre>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/wwwlouxuemingcom.blog.163.com\/blog\/static\/209747822013411103950266\/\" target=\"_blank\">\u00a0http:\/\/wwwlouxuemingcom.blog.163.com\/blog\/static\/209747822013411103950266\/<\/a><\/p>\n<p>ubuntu\u5b89\u88c5mysql\u53c2\u8003\uff1a<a href=\"https:\/\/sdeno.com\/?p=5262\" target=\"_blank\">https:\/\/sdeno.com\/?p=5262<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u9ed8\u8ba4\u5b89\u88c5mysql\u65f6\uff0cmysql\u53ea\u80fd\u662f\u672c\u5730\u624d\u80fd\u8fde\u63a5\uff0c\u8981\u8ba9mysql\u5141\u8bb8\u8fdc\u7a0b\u8fde\u63a5\u64cd\u4f5c\u6570\u636e\u5e93\uff1a 1\uff0c\u627e\u5230\/etc\/ [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[39,9],"tags":[],"class_list":["post-5496","post","type-post","status-publish","format-standard","hentry","category-ubuntu","category-9"],"_links":{"self":[{"href":"https:\/\/sdeno.com\/index.php?rest_route=\/wp\/v2\/posts\/5496","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sdeno.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sdeno.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sdeno.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sdeno.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5496"}],"version-history":[{"count":0,"href":"https:\/\/sdeno.com\/index.php?rest_route=\/wp\/v2\/posts\/5496\/revisions"}],"wp:attachment":[{"href":"https:\/\/sdeno.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5496"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdeno.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5496"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdeno.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5496"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}