{"id":285,"date":"2021-09-18T17:01:55","date_gmt":"2021-09-18T08:01:55","guid":{"rendered":"https:\/\/kitayama.jp\/?p=285"},"modified":"2021-09-18T17:01:57","modified_gmt":"2021-09-18T08:01:57","slug":"docker%e3%81%aemysql%e3%81%ae%e6%8e%a5%e7%b6%9a%e3%81%97%e3%81%a6%e3%80%81mysql%e3%82%b3%e3%83%9e%e3%83%b3%e3%83%89%e3%82%92%e4%bd%bf%e3%81%86%e3%80%82","status":"publish","type":"post","link":"https:\/\/kitayama.jp\/?p=285","title":{"rendered":"DOCKER\u306eMYSQL\u306e\u63a5\u7d9a\u3057\u3066\u3001MYSQL\u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u3046\u3002"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>docker ps\nCONTAINER ID        IMAGE                COMMAND                CREATED             STATUS              PORTS                    NAMES\ne5edc5732d78        mysql:latest         \"\/entrypoint.sh mysq   49 minutes ago      Up 33 minutes       0.0.0.0:3306-&gt;3306\/tcp   mysql\n\n<\/code><\/pre>\n\n\n\n<p><code>docker exec<\/code>&nbsp;\u30b3\u30de\u30f3\u30c9\u3067\u63a5\u7d9a\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ docker exec -it e5edc5732d78 bash\n\n$ mysql -u root -p\nEnter password:\nWelcome to the MySQL monitor.  Commands end with ; or \\g.\nYour MySQL connection id is 3\nServer version: 5.6.24 MySQL Community Server (GPL)\n\nCopyright (c) 2000, 2015, Oracle and\/or its affiliates. All rights reserved.\n\nOracle is a registered trademark of Oracle Corporation and\/or its\naffiliates. Other names may be trademarks of their respective\nowners.\n\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\n\nmysql&gt;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>docker exec&nbsp;\u30b3\u30de\u30f3\u30c9\u3067\u63a5\u7d9a\u3002<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/kitayama.jp\/index.php?rest_route=\/wp\/v2\/posts\/285"}],"collection":[{"href":"https:\/\/kitayama.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kitayama.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kitayama.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kitayama.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=285"}],"version-history":[{"count":1,"href":"https:\/\/kitayama.jp\/index.php?rest_route=\/wp\/v2\/posts\/285\/revisions"}],"predecessor-version":[{"id":286,"href":"https:\/\/kitayama.jp\/index.php?rest_route=\/wp\/v2\/posts\/285\/revisions\/286"}],"wp:attachment":[{"href":"https:\/\/kitayama.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=285"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kitayama.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=285"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kitayama.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=285"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}