如何通过Docker连接到本地的MySQL服务器? [英] How to connect to local MySQL server through Docker?
问题描述
理想情况下,都可以从同一个地方获取设置,所以我可以把 mysql_server:host_ip
。这似乎是一个典型的用例。这样的事情目前是否可行?
我正在使用Boot2Docker与MySQL服务器上运行的主机MAC的Yosemite不在容器中运行。
$(.docker.com / engine / reference / run /rel =nofollow b $ b
有时您需要从容器内连接到Docker主机。要启用此功能,请使用
- add-host
标志将Docker主机的IP地址传递到容器。要查找主机的地址,请使用ip addr show
命令。
您传递给
ip addr show
取决于您是否在容器中使用IPv4或IPv6网络。对于名为eth0
的网络设备使用以下标志进行IPv4地址检索:
$ HOSTIP =`ip -4 addr show scope global dev eth0 | grep inet | awk'{print \ $ 2}'| cut -d / -f 1`
$ docker run --add-host = docker:$ {HOSTIP} --rm -it debian
然后容器内的名称 docker
将映射到主机的IP地址。对于您的情况,您可以使用 docker run --add-host = mysql_server:$(hostip)...
如果使用Boot2Docker,它将以预定义的地址设置到主机的映射,所以在该平台上,等同于上述只是一个命令:
$ docker run --add-host = docker:192.168.59.3 --rm -it debian
This is more a general question for how to connect to local services through Docker. There's a similar question in a Github issue here that doesn't seem to have any resolution. What I'm really looking for is to be able to do development locally against my local development MySQL server, then once I'm ready to deploy, to test locally against a newly created deploy candidate docker image.
Ideally, both get settings from the same place as well, so I could put mysql_server: host_ip
. This seems like a typical use case. Is anything like this currently possible?
I'm using Boot2Docker specifically with MySQL server running on my host mac's OS X Yosemite NOT in a container. Would be cool to have a more general answer for future readers though.
The Docker CLI docs give this solution (which assumes you are running on a Linux host with ):
Sometimes you need to connect to the Docker host from within your container. To enable this, pass the Docker host’s IP address to the container using the
--add-host
flag. To find the host’s address, use theip addr show
command.The flags you pass to
ip addr show
depend on whether you are using IPv4 or IPv6 networking in your containers. Use the following flags for IPv4 address retrieval for a network device namedeth0
:
$ HOSTIP=`ip -4 addr show scope global dev eth0 | grep inet | awk '{print \$2}' | cut -d / -f 1`
$ docker run --add-host=docker:${HOSTIP} --rm -it debian
Then the name docker
inside the container will map to the host's IP address. For your case, you could use docker run --add-host=mysql_server:$(hostip) ...
If using Boot2Docker, it sets up a mapping to the host at a predefined address, so on that platform the equivalent to the above is just the one command:
$ docker run --add-host=docker:192.168.59.3 --rm -it debian
这篇关于如何通过Docker连接到本地的MySQL服务器?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!