{"id":2238,"date":"2023-06-09T13:37:36","date_gmt":"2023-06-09T05:37:36","guid":{"rendered":"https:\/\/blog.kingsbestone.com\/?p=2238"},"modified":"2023-06-09T14:02:58","modified_gmt":"2023-06-09T06:02:58","slug":"centos7-9%e6%90%ad%e5%bb%bamariadbphpmyadmin-_-docker-compose%e7%89%88","status":"publish","type":"post","link":"https:\/\/blog.kingsbestone.com\/?p=2238","title":{"rendered":"Centos7.9\u642d\u5efaMariadb+phpmyadmin _ Docker-compose\u7248"},"content":{"rendered":"<p><span style=\"font-family: 'comic sans ms', sans-serif;\">\u7531\u4e8e\u5f88\u591a\u9879\u76ee\u8fd0\u884c\u90fd\u5fc5\u987b\u4f9d\u8d56\u6570\u636e\u5e93\uff0c\u53c8\u56e0\u4e3a\u6570\u636e\u5e93\u7ba1\u7406\u8f83\u4e3a\u590d\u6742\u6240\u4ee5\u5c31\u6709\u4e86\u672c\u6559\u7a0b\u3002<\/span><\/p>\n<hr \/>\n<p><span style=\"font-family: 'comic sans ms', sans-serif;\">1.\u73af\u5883\uff1a<\/span><\/p>\n<ul>\n<li><span style=\"font-family: 'comic sans ms', sans-serif;\">centos7.9<\/span><\/li>\n<li><span style=\"font-family: 'comic sans ms', sans-serif;\">docker<\/span><\/li>\n<li><span style=\"font-family: 'comic sans ms', sans-serif;\">docker-compose<\/span><\/li>\n<li><span style=\"font-family: 'comic sans ms', sans-serif;\">portainer<\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: 'comic sans ms', sans-serif;\">2.\u9009\u62e9\u642d\u5efa\u9879\u76ee\uff1a<\/span><\/p>\n<ul>\n<li><span style=\"font-family: 'comic sans ms', sans-serif;\">Mariadb\uff1a<a href=\"https:\/\/hub.docker.com\/r\/linuxserver\/mariadb\" target=\"_blank\" rel=\"noopener\">https:\/\/hub.docker.com\/r\/linuxserver\/mariadb<\/a><\/span><\/li>\n<li><span style=\"font-family: 'comic sans ms', sans-serif;\">phpmyadmin\uff1a<a href=\"https:\/\/hub.docker.com\/r\/linuxserver\/phpmyadmin\" target=\"_blank\" rel=\"noopener\">https:\/\/hub.docker.com\/r\/linuxserver\/phpmyadmin<\/a><\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: 'comic sans ms', sans-serif;\">3.\u7f16\u8f91YAML\u6587\u4ef6<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"yaml\">---\r\nversion: \"2.1\"\r\nservices:\r\n  mariadb:\r\n    image: lscr.io\/linuxserver\/mariadb:latest\r\n    container_name: mariadb\r\n    environment:\r\n      - PUID=1000\r\n      - PGID=1000\r\n      - TZ=Asia\/Shanghai\r\n      - MYSQL_ROOT_PASSWORD=Admin@000\r\n      - MYSQL_DATABASE=data\r\n      - MYSQL_USER=admin\r\n      - MYSQL_PASSWORD=Admin@111\r\n    volumes:\r\n      - \/home\/docker\/mariadb\/config:\/config\r\n    restart: unless-stopped\r\n  phpmyadmin:\r\n    image: lscr.io\/linuxserver\/phpmyadmin:latest\r\n    container_name: phpmyadmin\r\n    depends_on:\r\n      - mariadb\r\n    environment:\r\n      - PUID=1000\r\n      - PGID=1000\r\n      - TZ=Asia\/Shanghai\r\n      - PMA_ARBITRARY=0\r\n      - PMA_HOST=mariadb\r\n    volumes:\r\n      - \/home\/docker\/phpmyadmin\/config:\/config\r\n    ports:\r\n      - 20000:80\r\n    restart: unless-stopped<\/pre>\n<p><span style=\"font-family: 'comic sans ms', sans-serif;\">4.\u76f4\u63a5\u628aYAML\u6587\u4ef6\u590d\u5236\u5230portainer\u521b\u5efa\u5373\u53ef\uff0c\u4f7f\u7528IP:20000\u8bbf\u95ee\u3002<\/span><\/p>\n<hr \/>\n<p><span style=\"font-family: 'comic sans ms', sans-serif;\">\u5982\u679c\u4f60\u9047\u5230BUG\uff0c\u53ef\u4ee5\u770b\u4e0b\u9762\uff1a<\/span><\/p>\n<p><span style=\"font-family: 'comic sans ms', sans-serif;\">1.\u5982\u679c\u4f60\u518d\u5207\u6362\u4e2d\u6587\u7684\u65f6\u5019\u62a5\u9519\uff0c\u63d0\u793a\u548c\u89e3\u51b3\u65b9\u6848\u5982\u4e0b\u6240\u793a\uff1a<\/span><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"shell\">BUG-1:\r\n#1231 - Variable 'lc_messages' can't be set to the value of 'zh_CN'\r\n\r\n\u4fee\u590d\u65b9\u6848\uff1a\r\n\u627e\u5230\u6587\u4ef6mariadb\/config\/custom.cnf\u5e76\u641c\u7d22\u7f16\u8f91\uff0c\u4ece\u5982\u4e0b\u5185\u5bb9\uff1a\r\nlc_messages_dir = \/usr\/share\/mysql\r\nlc_messages     = en_US\r\n\u4fee\u6539\u4e3a\u5982\u4e0b\u5185\u5bb9\uff1a\r\nlc_messages_dir = \/usr\/share\/mariadb\r\nlc_messages     = zh_CN\r\n<\/pre>\n<hr \/>\n<p><span style=\"font-family: 'comic sans ms', sans-serif;\">end&#8230;<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u7531\u4e8e\u5f88\u591a\u9879\u76ee\u8fd0\u884c\u90fd\u5fc5\u987b\u4f9d\u8d56\u6570\u636e\u5e93\uff0c\u53c8\u56e0\u4e3a\u6570\u636e\u5e93\u7ba1\u7406\u8f83\u4e3a\u590d\u6742\u6240\u4ee5\u5c31\u6709\u4e86\u672c\u6559\u7a0b\u3002 1.\u73af\u5883\uff1a centos7.9 docker docker-compose portainer 2.\u9009\u62e9\u642d\u5efa\u9879\u76ee\uff1a Mariadb\uff1ahttps:\/\/hub.docker.com\/r\/linuxserver\/mariadb phpmyadmin &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Centos7.9\u642d\u5efaMariadb+phpmyadmin _ Docker-compose\u7248\" class=\"read-more button\" href=\"https:\/\/blog.kingsbestone.com\/?p=2238#more-2238\" aria-label=\"\u66f4\u591a Centos7.9\u642d\u5efaMariadb+phpmyadmin _ Docker-compose\u7248\">\u67e5\u770b\u66f4\u591a<\/a><\/p>\n","protected":false},"author":1,"featured_media":212,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[59,4],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.kingsbestone.com\/index.php?rest_route=\/wp\/v2\/posts\/2238"}],"collection":[{"href":"https:\/\/blog.kingsbestone.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.kingsbestone.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.kingsbestone.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.kingsbestone.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2238"}],"version-history":[{"count":4,"href":"https:\/\/blog.kingsbestone.com\/index.php?rest_route=\/wp\/v2\/posts\/2238\/revisions"}],"predecessor-version":[{"id":2242,"href":"https:\/\/blog.kingsbestone.com\/index.php?rest_route=\/wp\/v2\/posts\/2238\/revisions\/2242"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.kingsbestone.com\/index.php?rest_route=\/wp\/v2\/media\/212"}],"wp:attachment":[{"href":"https:\/\/blog.kingsbestone.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2238"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.kingsbestone.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2238"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.kingsbestone.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2238"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}