{"id":398,"date":"2019-01-22T14:24:42","date_gmt":"2019-01-22T06:24:42","guid":{"rendered":"https:\/\/wp.winter-weng.cc\/work\/?p=398"},"modified":"2021-03-08T01:21:49","modified_gmt":"2021-03-07T17:21:49","slug":"docker-%e5%ae%89%e8%a3%9d-mysql-phpmyadmin","status":"publish","type":"post","link":"https:\/\/wp.winter-weng.cc\/work\/?p=398","title":{"rendered":"Docker \u5b89\u88dd MySQL\u3001phpMyAdmin"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_75 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"\u986f\u793a\/\u96b1\u85cf\u5167\u5bb9\u76ee\u9304\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/wp.winter-weng.cc\/work\/?p=398\/#MySQL\" >MySQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/wp.winter-weng.cc\/work\/?p=398\/#phpMyAdmin\" >phpMyAdmin<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/wp.winter-weng.cc\/work\/?p=398\/#%E6%9F%A5%E7%9C%8B%E7%8F%BE%E6%9C%89%E7%9A%84_container_%E5%92%8C_images\" >\u67e5\u770b\u73fe\u6709\u7684 container \u548c images<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/wp.winter-weng.cc\/work\/?p=398\/#%E7%96%91%E9%9B%A3%E9%9B%9C%E7%97%87\" >\u7591\u96e3\u96dc\u75c7<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/wp.winter-weng.cc\/work\/?p=398\/#Docker_%E5%B8%B8%E7%94%A8%E6%8C%87%E4%BB%A4\" >Docker \u5e38\u7528\u6307\u4ee4<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/wp.winter-weng.cc\/work\/?p=398\/#%E5%8F%83%E8%80%83%E8%B3%87%E6%96%99\" >\u53c3\u8003\u8cc7\u6599<\/a><\/li><\/ul><\/nav><\/div>\n\n<p>\u9996\u5148\u5148\u5b89\u88dd <a href=\"https:\/\/hub.docker.com\/editions\/community\/docker-ce-desktop-mac\">docker desktop for mac<\/a>\u3002\u5b89\u88dd\u5b8c\u7562\u5f8c\u628a MySQL \u548c phpmyadmin \u7684 image \u62c9\u4e0b\u4f86\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">docker pull mysql\ndocker pull phpmyadmin\/phpmyadmin<\/pre>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"MySQL\"><\/span><strong>MySQL<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u63a5\u4e0b\u4f86\u5c31\u53ef\u4ee5 run \u4e00\u500b container\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">docker run --name &amp;lt;Container Name&amp;gt; -e MYSQL_ROOT_PASSWORD=&amp;lt;PASSWORD&amp;gt; -p 127.0.0.1:3306:3306 -d mysql<\/pre>\n\n\n\n<p>\u53c3\u6578\u8aaa\u660e\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><code>--name<\/code>&nbsp;\u6307\u5b9a container \u540d\u7a31<\/li><li><code>-p<\/code>&nbsp;\u5c07\u5916\u90e8\u7684 3306 port \u8207\u5167\u90e8\u7684\u5c0d\u7167\u8d77\u4f86<\/li><li><code>-d<\/code>&nbsp;detached \u6a21\u5f0f\uff0c\u9000\u51fa\u4e0d\u6703\u95dc\u9589 container<\/li><li><code>MYSQL_ROOT_PASSWORD<\/code> \u8a2d\u5b9a MySQL root \u5bc6\u78bc<\/li><\/ul>\n\n\n\n<p>\u4e4b\u5f8c\u9032\u5165 container \u6e2c\u8a66\u770b\u770b\u662f\u5426\u53ef\u4ee5\u4f7f\u7528 MySQL \u8cc7\u6599\u5eab\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">docker exec -it mysql bash\nmysql -u root -p<\/pre>\n\n\n\n<p class=\"has-vivid-red-color has-text-color\">\u5982\u679c Sequal Pro \u7b49\u8edf\u9ad4\u7121\u6cd5\u767b\u5165\uff0c\u8acb\u7e7c\u7e8c\u770b\u4e0b\u65b9\u8aaa\u660e\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"phpMyAdmin\"><\/span><strong>phpMyAdmin<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u63a5\u4e0b\u4f86\u5efa\u7acb phpMyAdmin \u7684 container\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">docker run --name myadmin -d --link mysql:db -p 9100:80 phpmyadmin\/phpmyadmin<\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>\u900f\u904e <code>--link<\/code>&nbsp;\u8207\u8cc7\u6599\u5eab\u9023\u63a5<\/li><li><code>-p<\/code> \u4e00\u6a23\u5c07\u5167\u5916\u90e8 port \u5c0d\u7167\u8d77\u4f86<\/li><\/ul>\n\n\n\n<p>\u5b8c\u6210\u5f8c\u5728\u7db2\u5740\u5217\u8f38\u5165 http:\/\/localhost:9100 \u5c31\u53ef\u4ee5\u770b\u5230\u767b\u5165\u4ecb\u9762\u56c9\u3002\u4f46\u6b64\u6642\u767b\u5165\u6703\u6709\u932f\u8aa4\u8a0a\u606f\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client<\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/rukiawinter-wordpress.s3.ap-northeast-1.amazonaws.com\/wp-content\/uploads\/sites\/2\/2019\/01\/\u87a2\u5e55\u5feb\u7167-2019-01-22-\u4e0a\u534811.20.49-1.png\" alt=\"\" class=\"wp-image-406\"\/><\/figure>\n\n\n\n<p>\u9019\u662f\u56e0\u70ba MySQL 8 \u4f7f\u7528\u4e86\u65b0\u7684\u5bc6\u78bc\u9a57\u8b49\u65b9\u5f0f\uff1acaching_sha2_password\uff0c\u53ef\u4ee5\u85c9\u7531\u5347\u7d1a PHP \u7248\u672c\u548c\u8f09\u5165\u6a21\u7d44\u4f86\u652f\u63f4\uff1b\u6216\u662f\u4fee\u6539\u4f7f\u7528\u8005\u7684\u5bc6\u78bc\u9a57\u8b49\u65b9\u5f0f\u4f86\u89e3\u6c7a\u3002<\/p>\n\n\n\n<p>\u9032\u5230 MySQL \u4e26\u4f7f\u7528\u4ee5\u4e0b\u6307\u4ee4\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">ALTER USER root IDENTIFIED WITH mysql_native_password BY 'PASSWORD'<\/pre>\n\n\n\n<p>\u5b8c\u6210\u5f8c\u5c31\u53ef\u4ee5\u6b63\u5e38\u767b\u5165\u4e86\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%9F%A5%E7%9C%8B%E7%8F%BE%E6%9C%89%E7%9A%84_container_%E5%92%8C_images\"><\/span><strong>\u67e5\u770b\u73fe\u6709\u7684 container \u548c images<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">docker ps -a\ndocker images -a<\/pre>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%96%91%E9%9B%A3%E9%9B%9C%E7%97%87\"><\/span><strong>\u7591\u96e3\u96dc\u75c7<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\u4e00\u958b\u59cb\u88dd\u5b8c\u5169\u500b container \u5f8c\uff0c\u767c\u73fe\u767b\u5165\u4e0d\u4e86\uff0c\u9047\u5230\u4ee5\u4e0b\u932f\u8aa4\u8a0a\u606f\uff1a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name does not resolve<\/pre>\n\n\n\n<figure class=\"wp-block-gallery columns-1 is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><img decoding=\"async\" src=\"https:\/\/rukiawinter-wordpress.s3.ap-northeast-1.amazonaws.com\/wp-content\/uploads\/sites\/2\/2019\/01\/\u87a2\u5e55\u5feb\u7167-2019-01-22-\u4e0a\u534810.40.29.png\" alt=\"\" data-id=\"405\" data-link=\"https:\/\/wp.winter-weng.cc\/work\/?attachment_id=405\" class=\"wp-image-405\"\/><\/figure><\/li><\/ul><\/figure>\n\n\n\n<p>\u63a8\u6e2c\u53ef\u80fd\u662f link \u51fa\u4e86\u4ec0\u9ebc\u554f\u984c\uff0c\u6709\u67e5\u5230<a rel=\"noreferrer noopener\" aria-label=\"\u76f8\u95dc\u6587\u7ae0 (\u5728\u65b0\u5206\u9801\u4e2d\u958b\u555f)\" href=\"https:\/\/ithelp.ithome.com.tw\/articles\/10200754\" target=\"_blank\">\u76f8\u95dc\u6587\u7ae0<\/a>\u8aaa\u5efa\u7acb container \u6642\u52a0\u5165 <code>-e PMA_HOST=\"mysql\"<\/code>\uff0c\u4f46\u6e2c\u8a66\u5f8c\u7121\u6cd5\u4ecd\u6392\u89e3\uff0c\u6700\u5f8c\u662f\u4f7f\u7528\u4e0a\u9762\u7684\u6307\u4ee4\u91cd\u65b0\u8dd1\u4e00\u500b\u624d\u6210\u529f\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>\u53e6\u4e00\u500b\u554f\u984c\u662f Sequel Pro (v1.1.2) \u9023\u5230\u672c\u5730 DB \u6293\u4e0d\u5230\u8cc7\u6599\u5eab\u6e05\u55ae\uff0c\u800c\u4e14\u4e00\u95dc\u9589\u5c31 Crash\uff0c\u63a8\u6e2c\u662f\u61c9\u7528\u7a0b\u5f0f\u7684\u554f\u984c\uff0c\u5728 MacOS Mojave 10.14.2 \u9023\u63a5 MySQL 8.0 \u6703\u51fa\u932f\uff0c\u5230\u5b98\u7db2\u4e0b\u8f09 <a rel=\"noreferrer noopener\" aria-label=\"Test Build (\u5728\u65b0\u5206\u9801\u4e2d\u958b\u555f)\" href=\"https:\/\/sequelpro.com\/test-builds\" target=\"_blank\">Test Build<\/a> \u7248\u672c\u53ef\u4ee5\u89e3\u6c7a\u6b64\u554f\u984c\u3002\u7f3a\u9ede\u662f\u9b06\u9905\u6c92\u6709\u8702\u871c\u4e86 (?)\u3002<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Docker_%E5%B8%B8%E7%94%A8%E6%8C%87%E4%BB%A4\"><\/span>Docker \u5e38\u7528\u6307\u4ee4<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">docker ps -a \/\/ \u5217\u51fa\u6240\u6709 container\ndocker start &amp;lt;container-name&amp;gt;<\/pre>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%8F%83%E8%80%83%E8%B3%87%E6%96%99\"><\/span><strong>\u53c3\u8003\u8cc7\u6599<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li><a rel=\"noreferrer noopener\" aria-label=\"Docker \u5b89\u88dd Mysql + Phpmyadmin (\u5728\u65b0\u5206\u9801\u4e2d\u958b\u555f)\" href=\"http:\/\/www.andrewchen.tw\/2017\/05\/05\/20170505_NOTE_DOCKER_MYSQL\/\" target=\"_blank\">Docker \u5b89\u88dd Mysql + Phpmyadmin<\/a><\/li><li><a rel=\"noreferrer noopener\" aria-label=\"Docker \u5b89\u88dd MySQL\u3001phpMyAdmin\u3001Redis (\u5728\u65b0\u5206\u9801\u4e2d\u958b\u555f)\" href=\"https:\/\/medium.com\/@hsiehjenhsuan\/docker-%E5%AE%89%E8%A3%9D-mysql-phpmyadmin-redis-5ec9b1465855\" target=\"_blank\">Docker \u5b89\u88dd MySQL\u3001phpMyAdmin\u3001Redis<\/a><\/li><li><a rel=\"noreferrer noopener\" aria-label=\"\u5229\u7528 Docker \u67b6\u8d77 phpMyAdmin + MySQL (MAC) (\u5728\u65b0\u5206\u9801\u4e2d\u958b\u555f)\" href=\"https:\/\/ithelp.ithome.com.tw\/articles\/10200754\" target=\"_blank\">\u5229\u7528 Docker \u67b6\u8d77 phpMyAdmin + MySQL (MAC)<\/a><\/li><li><a rel=\"noreferrer noopener\" aria-label=\" (\u5728\u65b0\u5206\u9801\u4e2d\u958b\u555f)\" href=\"https:\/\/www.cnblogs.com\/cndavidwang\/p\/9357684.html\" target=\"_blank\">PHP\u9519\u8bef\uff1aSQLSTATE[HY000] [2054] The server requested authentication method unknown to the client<\/a><\/li><li><a rel=\"noreferrer noopener\" aria-label=\"[Sequel Pro Github] Need MySQL 8.0 support (\u5728\u65b0\u5206\u9801\u4e2d\u958b\u555f)\" href=\"https:\/\/github.com\/sequelpro\/sequelpro\/issues\/2699#issuecomment-432431710\" target=\"_blank\">[Sequel Pro Github] Need MySQL 8.0 support<\/a><\/li><li><a href=\"https:\/\/joshhu.gitbooks.io\/dockercommands\/content\/Containers\/ContainersBasic.html\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Container\u6307\u4ee4\u57fa\u790e (\u5728\u65b0\u5206\u9801\u4e2d\u958b\u555f)\">Container\u6307\u4ee4\u57fa\u790e<\/a><\/li><\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u9996\u5148\u5148\u5b89\u88dd docker desktop for &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"pgc_sgb_lightbox_settings":"","footnotes":""},"categories":[11],"tags":[35],"class_list":["post-398","post","type-post","status-publish","format-standard","hentry","category-11","tag-35"],"_links":{"self":[{"href":"https:\/\/wp.winter-weng.cc\/work\/index.php?rest_route=\/wp\/v2\/posts\/398","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wp.winter-weng.cc\/work\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wp.winter-weng.cc\/work\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wp.winter-weng.cc\/work\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wp.winter-weng.cc\/work\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=398"}],"version-history":[{"count":3,"href":"https:\/\/wp.winter-weng.cc\/work\/index.php?rest_route=\/wp\/v2\/posts\/398\/revisions"}],"predecessor-version":[{"id":690,"href":"https:\/\/wp.winter-weng.cc\/work\/index.php?rest_route=\/wp\/v2\/posts\/398\/revisions\/690"}],"wp:attachment":[{"href":"https:\/\/wp.winter-weng.cc\/work\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=398"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wp.winter-weng.cc\/work\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=398"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wp.winter-weng.cc\/work\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=398"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}