blocks|key|1898640|text|您必须在docker-come.yml文件中设置环境下的用户名和密码。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1898641|version:+'3'
services:
++db:
++++image:+mysql
++++restart:+always
++++environment:
++++++MYSQL_DATABASE:+'db'
++++++MYSQL_USER:+'user'
++++++MYSQL_PASSWORD:+'password'
++++++MYSQL_ROOT_PASSWORD:+'password'
++++ports:
++++++-+'3306:3306'
++++volumes:
++++++-+my-db:/var/lib/mysql
volumes:
++my-db:|code-block|syntax|javascript|1898642|对于phpmyadmin，我使用了来自docker集线器的phpmyadmin映像：|1898643|phpmyadmin:
++image:+phpmyadmin/phpmyadmin
++ports:
++++-+80:80
++environment:
++++MYSQL_USERNAME:+'user'
++++MYSQL_ROOT_PASSWORD:+'password'|1898644|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

you have to setup username and password under environment in docker-compose.yml file.

<pre><code>version: '3'
services:
 db:
 image: mysql
 restart: always
 environment:
 MYSQL_DATABASE: 'db'
 MYSQL_USER: 'user'
 MYSQL_PASSWORD: 'password'
 MYSQL_ROOT_PASSWORD: 'password'
 ports:
 - '3306:3306'
 volumes:
 - my-db:/var/lib/mysql
volumes:
 my-db:
</code></pre>

and for phpmyadmin, I had used a phpmyadmin image from docker hub:

<pre><code>phpmyadmin:
 image: phpmyadmin/phpmyadmin
 ports:
 - 80:80
 environment:
 MYSQL_USERNAME: 'user'
 MYSQL_ROOT_PASSWORD: 'password'
</code></pre>

blocks|key|21329|text|将mysqlclient依赖项添加到requirements.txt中。需要允许Django与MySQL连接。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|21330|在Dockerfile中，将以下内容添加到Dockerfile中：|21331|Dockerfile|style|BOLD|21332|FROM+python:3.7


ENV+TZ=Africa/Nairobi
RUN+ln+-snf+/usr/share/zoneinfo/$TZ+/etc/localtime+&&+echo+$TZ+>+/etc/timezone



ENV+PYTHONUNBUFFERED+1

#+add+requirements.txt+to+the+image
ADD+requirements.txt+/app/

#+set+working+directory+to+/app/
WORKDIR+/app/


RUN+pip+install+--upgrade+pip


RUN+pip+install+-r+requirements.txt|code-block|syntax|javascript|21333|在django+settings.py上设置MYSQL配置：|CODE|21334|settings.py|21335|DATABASES+=+{
++++'default':+{
++++++++'ENGINE':+'django.db.backends.mysql',+
++++++++'NAME':+'django_mysql_docker',
++++++++'USER':+'root',
++++++++'PASSWORD':+'mysqladmin',
++++++++'HOST':+'db',
++++++++'PORT':+'3306',
++++}
}|21336|​|21337|我在**docker-组合**文件中添加了以下内容：|21338|docker-compose.yml|21339|++db:
++++restart:+always
++++image:+mysql:5.7
++++command:+--default-authentication-plugin=mysql_native_password
++++volumes:
++++++#+-+./init-db:/docker-entrypoint-initdb.d
++++++-+./data-db:/var/lib/mysql
++++environment:
++++++MYSQL_ROOT_PASSWORD:+mysqladmin
++++++MYSQL_DATABASE:+django_mysql_docker
++++ports:
++++++-+"3306:3306"


++phpmyadmin:
++++image:+phpmyadmin/phpmyadmin
++++environment:
++++++MYSQL_USERNAME:+'root'
++++++MYSQL_ROOT_PASSWORD:+'mysqladmin'
++++restart:+always
++++ports:
++++++-+8082:80
++++volumes:
++++++-+/sessions|21340|在端口:8082+(http://0.0.0.0:8082/)上，您可以找到phpmyadmin：|21341|phpMyAdmin仪表板|21342|21343|📷|atomic|21344|21345|entityMap|0|LINK|mutability|MUTABLE|url|https://pypi.org/project/mysqlclient/|1|http://0.0.0.0:8082/|2|IMAGE|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/c9a70691d0de3e461096454acb021040.png|imageAlt^0|1|B|0|0|0|0|A|0|0|8|B|0|0|B|0|0|0|0|0|I|0|0|A|K|1|0|0|D|0|0|0|1|2|0|0^^$0|@$1|2|3|4|5|6|7|1S|8|@]|9|@$A|1T|B|1U|1|1V]]|C|$]]|$1|D|3|E|5|6|7|1W|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|1X|8|@$A|1Y|B|1Z|H|I]]|9|@]|C|$]]|$1|J|3|K|5|L|7|20|8|@]|9|@]|C|$M|N]]|$1|O|3|P|5|6|7|21|8|@$A|22|B|23|H|Q]]|9|@]|C|$]]|$1|R|3|S|5|6|7|24|8|@$A|25|B|26|H|I]]|9|@]|C|$]]|$1|T|3|U|5|L|7|27|8|@]|9|@]|C|$M|N]]|$1|V|3|W|5|6|7|28|8|@]|9|@]|C|$]]|$1|X|3|Y|5|6|7|29|8|@]|9|@]|C|$]]|$1|Z|3|10|5|6|7|2A|8|@$A|2B|B|2C|H|I]]|9|@]|C|$]]|$1|11|3|12|5|L|7|2D|8|@]|9|@]|C|$M|N]]|$1|13|3|14|5|6|7|2E|8|@]|9|@$A|2F|B|2G|1|2H]]|C|$]]|$1|15|3|16|5|6|7|2I|8|@$A|2J|B|2K|H|I]]|9|@]|C|$]]|$1|17|3|W|5|6|7|2L|8|@]|9|@]|C|$]]|$1|18|3|19|5|1A|7|2M|8|@]|9|@$A|2N|B|2O|1|2P]]|C|$]]|$1|1B|3|W|5|6|7|2Q|8|@]|9|@]|C|$]]|$1|1C|3|-4|5|6|7|2R|8|@]|9|@]|C|$]]]|1D|$1E|$5|1F|1G|1H|C|$1I|1J]]|1K|$5|1F|1G|1H|C|$1I|1L]]|1M|$5|1N|1G|1O|C|$1P|1Q|1R|-4]]]]

Added <a href="https://pypi.org/project/mysqlclient/" rel="nofollow noreferrer">mysqlclient</a> dependency into requirements.txt. required to allow Django to connect with MySQL.

In the Dockerfile, added the following into the Dockerfile:
 

Dockerfile
 

<pre><code>FROM python:3.7


ENV TZ=Africa/Nairobi
RUN ln -snf /usr/share/zoneinfo/$TZ /etc/localtime &amp;&amp; echo $TZ &gt; /etc/timezone



ENV PYTHONUNBUFFERED 1

# add requirements.txt to the image
ADD requirements.txt /app/

# set working directory to /app/
WORKDIR /app/


RUN pip install --upgrade pip


RUN pip install -r requirements.txt
</code></pre>

 

Set up MYSQL configurations on django <code>settings.py</code>:
 
 

settings.py
 
<code>

<pre><code>DATABASES = {
 'default': {
 'ENGINE': 'django.db.backends.mysql', 
 'NAME': 'django_mysql_docker',
 'USER': 'root',
 'PASSWORD': 'mysqladmin',
 'HOST': 'db',
 'PORT': '3306',
 }
}
</code></pre>

</code>

I added the following in the **docker-compose** file:

 
docker-compose.yml
 

<pre><code> db:
 restart: always
 image: mysql:5.7
 command: --default-authentication-plugin=mysql_native_password
 volumes:
 # - ./init-db:/docker-entrypoint-initdb.d
 - ./data-db:/var/lib/mysql
 environment:
 MYSQL_ROOT_PASSWORD: mysqladmin
 MYSQL_DATABASE: django_mysql_docker
 ports:
 - "3306:3306"


 phpmyadmin:
 image: phpmyadmin/phpmyadmin
 environment:
 MYSQL_USERNAME: 'root'
 MYSQL_ROOT_PASSWORD: 'mysqladmin'
 restart: always
 ports:
 - 8082:80
 volumes:
 - /sessions
</code></pre>

On the port :8082 (http://0.0.0.0:8082/) you will find phpmyadmin:

 
phpMyAdmin Dashboard

<a href="https://i.stack.imgur.com/jdr5e.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jdr5e.png" alt="enter image description here"></a>

I need an example of setting up MySQL and phpmyadmin on a docker compose file.

How set up MySQL and phpmyadmin on a docker compose file

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我需要一个设置MySQL和phpmyadmin的例子。

问如何在坞文件上设置MySQL和phpmyadmin
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在坞文件上设置MySQL和phpmyadminEN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在坞文件上设置MySQL和phpmyadmin
EN