{"id":7710,"date":"2017-09-23T07:58:07","date_gmt":"2017-09-22T22:58:07","guid":{"rendered":"https:\/\/je1sgh.mydns.jp\/je1sghblog\/?p=7710"},"modified":"2017-09-23T07:58:07","modified_gmt":"2017-09-22T22:58:07","slug":"8%e5%b9%b4%e5%89%8d%e3%81%a8%e5%90%8c%e3%81%98%e7%bd%a0%e3%81%ab","status":"publish","type":"post","link":"https:\/\/je1sgh.mydns.jp\/je1sghblog\/?p=7710","title":{"rendered":"8\u5e74\u524d\u3068\u540c\u3058\u7f60\u306b^^;"},"content":{"rendered":"

MariaDB1<\/a><\/sup>MySQLのバイナリー置き換え可能フリーウェア．<\/span>のサーバーに，ローカルからはつながるのに，リモートからつながらない．8年前も同じことで悩んでいたのでした^^;<\/p>\n

以下，昔のWiki2<\/a><\/sup>現在は非公開で自分のデータベースとして使用してます．<\/span>の記事より．<\/p>\n

\n

接続不能その２　2009-07-03<\/span><\/h3>\n

ローカルからはつながるけど，リモート<\/strong>からつなごうとすると，<\/p>\n

ERROR 2003 (HY000): Can't connect to MySQL server on 'taropc' (61)<\/pre>\n
そこで，<\/p>\n
netstat -n  --tcp --all | grep 3306<\/pre>\n
何も出ない．つまり，外部のネットインターフェースを聞いていない^^;<\/p>\n
この場合は，mysqld_safe<\/strong>に–skip-networking<\/strong>のオプションが着いて起動させられている疑いがある．<\/p>\n
起動スクリプトを確認して，上記オプションがあれば取り除いて再起動．<\/p>\n","protected":false},"excerpt":{"rendered":"
MariaDB\u306e\u30b5\u30fc\u30d0\u30fc\u306b\uff0c\u30ed\u30fc\u30ab\u30eb\u304b\u3089\u306f\u3064\u306a\u304c\u308b\u306e\u306b\uff0c\u30ea\u30e2\u30fc\u30c8\u304b\u3089\u3064\u306a\u304c\u3089\u306a\u3044\uff0e8\u5e74\u524d\u3082\u540c\u3058\u3053\u3068\u3067\u60a9\u3093\u3067\u3044\u305f\u306e\u3067\u3057\u305f^^; \u4ee5\u4e0b\uff0c\u6614\u306eWiki\u306e\u8a18\u4e8b\u3088\u308a\uff0e \u63a5\u7d9a\u4e0d\u80fd\u305d\u306e\uff12\u30002009-07-03 \u30ed\u30fc\u30ab\u30eb\u304b\u3089\u306f\u3064\u306a\u304c\u308b\u3051\u3069\uff0c\u30ea\u30e2\u30fc\u30c8\u304b\u3089\u3064\u306a\u3054\u3046\u3068\u3059\u308b\u3068\uff0c ERROR 2003 (HY000): Can’t connect to MySQL server on ‘taropc’ (61) \u305d\u3053\u3067\uff0c netstat -n –tcp –all | grep 3306 \u4f55\u3082\u51fa\u306a\u3044\uff0e\u3064\u307e\u308a\uff0c\u5916\u90e8\u306e\u30cd\u30c3\u30c8\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u3092\u805e\u3044\u3066\u3044\u306a\u3044^^; \u3053\u306e\u5834\u5408\u306f\uff0cmysqld_safe\u306b–skip-networking\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u304c\u7740\u3044\u3066\u8d77\u52d5\u3055\u305b\u3089\u308c\u3066\u3044\u308b\u7591\u3044\u304c\u3042\u308b\uff0e \u8d77\u52d5\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u78ba\u8a8d\u3057\u3066\uff0c\u4e0a\u8a18\u30aa\u30d7\u30b7\u30e7\u30f3\u304c\u3042\u308c\u3070\u53d6\u308a\u9664\u3044\u3066\u518d\u8d77\u52d5\uff0e<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_daextam_enable_autolinks":"","footnotes":""},"categories":[8,27],"tags":[],"class_list":["post-7710","post","type-post","status-publish","format-standard","hentry","category-linux","category-rasapberry-pi"],"publishpress_future_action":{"enabled":false,"date":"2026-04-12 12:55:50","action":"change-status","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/je1sgh.mydns.jp\/je1sghblog\/index.php?rest_route=\/wp\/v2\/posts\/7710","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/je1sgh.mydns.jp\/je1sghblog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/je1sgh.mydns.jp\/je1sghblog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/je1sgh.mydns.jp\/je1sghblog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/je1sgh.mydns.jp\/je1sghblog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7710"}],"version-history":[{"count":0,"href":"https:\/\/je1sgh.mydns.jp\/je1sghblog\/index.php?rest_route=\/wp\/v2\/posts\/7710\/revisions"}],"wp:attachment":[{"href":"https:\/\/je1sgh.mydns.jp\/je1sghblog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7710"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/je1sgh.mydns.jp\/je1sghblog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7710"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/je1sgh.mydns.jp\/je1sghblog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7710"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}