blocks|key|137400|text|这种行为在这里有完整的文档：(host)，并按预期工作。我会引用它：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|137401|默认情况下，MySQL创建'root'@'localhost‘命令。此帐户只能从容器内部连接，需要使用MySQL命令行客户端连接到MySQL下的docker命令。若要允许来自其他主机的连接，请设置此环境变量。例如，值"172.17.0.1“是默认的Docker网关IP，它将允许来自Docker主机的连接。|blockquote|137402|您可以看到实际的.sh脚本，它从env变量：https://github.com/mysql/mysql-docker/blob/mysql-server/5.7/docker-entrypoint.sh#L63-L68中设置了允许的主机。|style|CODE|137403|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/mysql/mysql-docker#mysql_root_host|1|https://github.com/mysql/mysql-docker/blob/mysql-server/5.7/docker-entrypoint.sh#L63-L68^0|F|4|0|0|0|8|3|M|2G|1|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|F|7|Y|8|@]|9|@]|C|$]]|$1|G|3|H|5|6|7|Z|8|@$A|10|B|11|I|J]]|9|@$A|12|B|13|1|14]]|C|$]]|$1|K|3|-4|5|6|7|15|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]|S|$5|N|O|P|C|$Q|T]]]]

This behaviour is fully documented here: (<a href="https://github.com/mysql/mysql-docker#mysql_root_host" rel="nofollow noreferrer">https://github.com/mysql/mysql-docker#mysql_root_host</a>) and works as expected.
I'll quote it:

<blockquote>
 By default, MySQL creates the 'root'@'localhost' command. This account
 can only be connected to from inside the container, requiring the use
 of the docker exec command as noted under Connect to MySQL from the
 MySQL Command Line Client. To allow connections from other hosts, set
 this environment variable. As an example, the value "172.17.0.1",
 which is the default Docker gateway IP, will allow connections from
 the Docker host machine.
</blockquote>

You can see actual <code>.sh</code> script which set allowed host from this env variable: <a href="https://github.com/mysql/mysql-docker/blob/mysql-server/5.7/docker-entrypoint.sh#L63-L68" rel="nofollow noreferrer">https://github.com/mysql/mysql-docker/blob/mysql-server/5.7/docker-entrypoint.sh#L63-L68</a>

blocks|key|3537323|text|我必须在Django容器上授予根用户访问DB的权限：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3537324|GRANT+ALL+PRIVILEGES+ON+*.*+TO+'root'@'172.17.0.3'+IDENTIFIED+BY+'password'+WITH+GRANT+OPTION;
SET+PASSWORD+FOR+root@'172.17.0.3'+=+PASSWORD('root');
FLUSH+PRIVILEGES;|code-block|syntax|javascript|3537325|其中172.17.0.3是带有应用程序的容器的IP。不需要MYSQL_ROOT_HOST。|offset|length|style|CODE|3537326|entityMap^0|0|0|2|A|T|F|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@$I|R|J|S|K|L]|$I|T|J|U|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|N|$]]

I had to grant the root user at the Django container permissions to access the DB:

<pre><code>GRANT ALL PRIVILEGES ON *.* TO 'root'@'172.17.0.3' IDENTIFIED BY 'password' WITH GRANT OPTION;
SET PASSWORD FOR root@'172.17.0.3' = PASSWORD('root');
FLUSH PRIVILEGES;
</code></pre>

Where <code>172.17.0.3</code> is the IP of the container with the app. <code>MYSQL_ROOT_HOST</code> is not needed.

blocks|key|622721|text|正如@valignatev所建议的那样，使用env变量解决了一个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|622722|我确实是这样创建容器的：|622723|+docker+run+--rm+-dit+-e+MYSQL_ROOT_PASSWORD=pass+-e+MYSQL_ROOT_HOST=172.17.0.1+--name+mysql_container+-p+3306:3306+mysql-mysql-server|code-block|syntax|javascript|622724|172.17.0.1是我默认的对接网关|622725|一旦容器启动，我就可以像这样从我的主机连接：|622726|+mysql+-h+localhost+-P+3306+--protocol=tcp+-u+root+-p|622727|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|F|7|V|8|@]|9|@]|A|$G|H]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

As @valignatev suggested, using this env variable solves an issue.
I did create container this way:
<pre><code> docker run --rm -dit -e MYSQL_ROOT_PASSWORD=pass -e MYSQL_ROOT_HOST=172.17.0.1 --name mysql_container -p 3306:3306 mysql-mysql-server
</code></pre>
172.17.0.1 is my default docker gateway
Once container gets started I can connect from my host like this:
<pre><code> mysql -h localhost -P 3306 --protocol=tcp -u root -p
</code></pre>

blocks|key|3537362|text|docker+run+--rm+-d+-p+9999:3306+-e+MYSQL_ROOT_PASSWORD=root+-e+MYSQL_ROOT_HOST='%25'+mysql/mysql-server:5.7|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3537363|重要的部分是MYSQL_ROOT_HOST='%25'|3537364|entityMap^0|0|2X|0|6|J|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|P|8|@]|D|@]|E|$]]]|I|$]]

<code>docker run --rm -d -p 9999:3306 -e MYSQL_ROOT_PASSWORD=root -e MYSQL_ROOT_HOST='%' mysql/mysql-server:5.7</code>
The important part is <code>MYSQL_ROOT_HOST='%'</code>

blocks|key|3537379|text|不确定这是否有帮助，但我遇到了类似的问题，并通过添加MYSQL_ROOT_HOST=%25使其工作--这是我的坞-复合数据库的样子：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3537380|mysql:
++platform:+linux/x86_64
++image:+mysql
++environment:
++++-+MYSQL_ROOT_HOST=%25
++++-+MYSQL_ROOT_PASSWORD=foobar123
++++-+MYSQL_USER=test_user
++++-+MYSQL_PASSWORD=foobar123
++volumes:
++++-+./init:/docker-entrypoint-initdb.d
++ports:
++++-+3306:3306
++container_name:+"mysql"|code-block|syntax|javascript|3537381|资料来源：mysql-root-host|3537382|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/8.0/en/docker-mysql-more-topics.html#docker_var_mysql-root-host^0|Q|H|0|0|5|F|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|Y|8|@]|D|@$9|Z|A|10|1|11]]|E|$]]|$1|M|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]]]

Not sure if this will be helpful but I had a similar issue and got it to work by adding <code>MYSQL_ROOT_HOST=%</code>
This is what my docker-compose looks like for the db:
<pre class="lang-yaml prettyprint-override"><code>mysql:
 platform: linux/x86_64
 image: mysql
 environment:
 - MYSQL_ROOT_HOST=%
 - MYSQL_ROOT_PASSWORD=foobar123
 - MYSQL_USER=test_user
 - MYSQL_PASSWORD=foobar123
 volumes:
 - ./init:/docker-entrypoint-initdb.d
 ports:
 - 3306:3306
 container_name: &quot;mysql&quot;
</code></pre>
Source documentation: <a href="https://dev.mysql.com/doc/refman/8.0/en/docker-mysql-more-topics.html#docker_var_mysql-root-host" rel="nofollow noreferrer">https://dev.mysql.com/doc/refman/8.0/en/docker-mysql-more-topics.html#docker_var_mysql-root-host</a>

When I try to connect from a docker container running my Django app to a container running MySQL, I get the following error:

<pre><code>django.db.utils.OperationalError: (2003, "Can't connect to MySQL server on '172.17.0.2' (111)")
</code></pre>

Here's how I'm running the MySQL container:

<pre><code>$ docker run --name mysql -e MYSQL_ROOT_PASSWORD=root -e MYSQL_DATABASE=testdb -e MYSQL_ROOT_HOST=172.17.0.2 -d mysql/mysql-server:5.7
</code></pre>

If I don't specify <code>MYSQL_ROOT_HOST</code>, I get this error when I try to connect from the container with the Django app:

<pre><code>django.db.utils.OperationalError: (1130, "Host '172.17.0.3' is not allowed to connect to this MySQL server")
</code></pre>

Here are my Django settings:

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

I've verified the MySQL container is using IP 172.17.0.2:

<pre><code>$ docker inspect mysql |grep -i ipaddress
 "SecondaryIPAddresses": null,
 "IPAddress": "172.17.0.2",
 "IPAddress": "172.17.0.2",
</code></pre>

Cannot connect to MySQL docker container from container with Django app

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

当我试图从运行我的Django应用程序的docker容器连接到运行MySQL的容器时，我会得到以下错误：django.db.utils.OperationalError: (2003, "Can't connect to MySQL server on '172.17.0.2' (111)")下面是我如何运行MySQL...

问无法用Django应用程序从容器连接到MySQL码头容器
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法用Django应用程序从容器连接到MySQL码头容器EN