docker启动mysql容器后又退出_为什么docker容器启动成功几分钟后又自己关闭了？...

╰+攻爆jí腚メ 2023-01-11 13:26 219阅读 0赞

总结

问题描述

通过docker run启动一个 WordPress 应用的 docker 容器时，显示启动成功为UP状态，但无法访问

WordPress 应用，并且几分钟后 container 的状态变为excited。

启动命令

docker run -d -p 9090:80 --name wordpress -e WORDPRESS\_DB\_HOST=10.10.4.182 -e WORDPRESS\_DB\_USER=admin -e WORDPRESS\_DB\_PASSWORD=csphere2015 csphere/wordpress:4.2

网卡信息

\[root@Optimus /\]\# ifconfig

docker0 Link encap:Ethernet HWaddr 02:C4:0F:42:9D:A4

inet addr:172.17.42.1 Bcast:0.0.0.0 Mask:255.255.0.0

inet6 addr: fe80::ac31:7eff:fe21:61bb/64 Scope:Link

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

RX packets:99200 errors:0 dropped:0 overruns:0 frame:0

TX packets:149257 errors:0 dropped:0 overruns:0 carrier:0

collisions:0 txqueuelen:0

RX bytes:5452754 (5.2 MiB) TX bytes:222793983 (212.4 MiB)

eth0 Link encap:Ethernet HWaddr 00:1E:67:4E:3D:7B

UP BROADCAST MULTICAST MTU:1500 Metric:1

RX packets:0 errors:0 dropped:0 overruns:0 frame:0

TX packets:0 errors:0 dropped:0 overruns:0 carrier:0

collisions:0 txqueuelen:1000

RX bytes:0 (0.0 b) TX bytes:0 (0.0 b)

Memory:d0960000-d097ffff

eth1 Link encap:Ethernet HWaddr 00:1E:67:4E:3D:7C

inet addr:10.10.4.182 Bcast:10.10.4.255 Mask:255.255.255.0

inet6 addr: fe80::21e:67ff:fe4e:3d7c/64 Scope:Link

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

RX packets:225323670 errors:0 dropped:0 overruns:0 frame:0

TX packets:78415571 errors:0 dropped:0 overruns:0 carrier:0

collisions:0 txqueuelen:1000

RX bytes:42781224797 (39.8 GiB) TX bytes:107201976978 (99.8 GiB)

Memory:d0940000-d095ffff

背景补充

构建DB容器时，使用的端口映射为3307:3306.

解决方法

改为使用docker0网卡地址172.17.42.1，指定3307端口号。网页访问地址为eth1:9090,也就是10.10.4.182:9090.访问成功！

\[root@Optimus /\]\# docker run -d -p 9090:80 --name wordpress -e WORDPRESS\_DB\_HOST=172.17.42.1:3307 -e WORDPRESS\_DB\_USER=admin -e WORDPRESS\_DB\_PASSWORD=csphere2015 csphere/wordpress:4.2

6472364a37f5db3cee78608a649b0a9772952343914212fa8125faa0bcdc4152

![56edc1e181ba48481482d4c4088baf77.png][]

感谢@CrazyCodes和@Feng\_Yu两位的帮助！

原问题

补充信息

出错信息1(第一次docker run的日志显示的是admin'@'172.17.0.22)

\[root@Optimus wordpress\]\# docker logs -f wordpress

PHP Notice: Undefined offset: 1 in - on line 4

PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'admin'@'172.17.0.22' (using password: YES) in - on line 7

MySQL Connection Error: (1045) Access denied for user 'admin'@'172.17.0.22' (using password: YES)

PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'admin'@'172.17.0.22' (using password: YES) in - on line 7

MySQL Connection Error: (1045) Access denied for user 'admin'@'172.17.0.22' (using password: YES)

PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'admin'@'172.17.0.22' (using password: YES) in - on line 7

MySQL Connection Error: (1045) Access denied for user 'admin'@'172.17.0.22' (using password: YES)

PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'admin'@'172.17.0.22' (using password: YES) in - on line 7

MySQL Connection Error: (1045) Access denied for user 'admin'@'172.17.0.22' (using password: YES)

PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'admin'@'172.17.0.22' (using password: YES) in - on line 7

MySQL Connection Error: (1045) Access denied for user 'admin'@'172.17.0.22' (using password: YES)

PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'admin'@'172.17.0.22' (using password: YES) in - on line 7

MySQL Connection Error: (1045) Access denied for user 'admin'@'172.17.0.22' (using password: YES)

PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'admin'@'172.17.0.22' (using password: YES) in - on line 7

MySQL Connection Error: (1045) Access denied for user 'admin'@'172.17.0.22' (using password: YES)

PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'admin'@'172.17.0.22' (using password: YES) in - on line 7

MySQL Connection Error: (1045) Access denied for user 'admin'@'172.17.0.22' (using password: YES)

PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'admin'@'172.17.0.22' (using password: YES) in - on line 7

MySQL Connection Error: (1045) Access denied for user 'admin'@'172.17.0.22' (using password: YES)

PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'admin'@'172.17.0.22' (using password: YES) in - on line 7

MySQL Connection Error: (1045) Access denied for user 'admin'@'172.17.0.22' (using password: YES)

\[root@Optimus wordpress\]\#

错误信息2(删除容器，再重新docker run，显示的错误信息变成了admin'@'172.17.0.25)

\[root@Optimus ~\]\# docker logs -f wordpress

PHP Notice: Undefined offset: 1 in - on line 4

PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'admin'@'172.17.0.25' (using password: YES) in - on line 7

MySQL Connection Error: (1045) Access denied for user 'admin'@'172.17.0.25' (using password: YES)

PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'admin'@'172.17.0.25' (using password: YES) in - on line 7

MySQL Connection Error: (1045) Access denied for user 'admin'@'172.17.0.25' (using password: YES)

PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'admin'@'172.17.0.25' (using password: YES) in - on line 7

MySQL Connection Error: (1045) Access denied for user 'admin'@'172.17.0.25' (using password: YES)

PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'admin'@'172.17.0.25' (using password: YES) in - on line 7

MySQL Connection Error: (1045) Access denied for user 'admin'@'172.17.0.25' (using password: YES)

PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'admin'@'172.17.0.25' (using password: YES) in - on line 7

MySQL Connection Error: (1045) Access denied for user 'admin'@'172.17.0.25' (using password: YES)

PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'admin'@'172.17.0.25' (using password: YES) in - on line 7

MySQL Connection Error: (1045) Access denied for user 'admin'@'172.17.0.25' (using password: YES)

PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'admin'@'172.17.0.25' (using password: YES) in - on line 7

MySQL Connection Error: (1045) Access denied for user 'admin'@'172.17.0.25' (using password: YES)

PHP Notice: Undefined offset: 1 in - on line 4

PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'admin'@'172.17.0.25' (using password: YES) in - on line 7

MySQL Connection Error: (1045) Access denied for user 'admin'@'172.17.0.25' (using password: YES)

PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'admin'@'172.17.0.25' (using password: YES) in - on line 7

MySQL Connection Error: (1045) Access denied for user 'admin'@'172.17.0.25' (using password: YES)

PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'admin'@'172.17.0.25' (using password: YES) in - on line 7

MySQL Connection Error: (1045) Access denied for user 'admin'@'172.17.0.25' (using password: YES)

PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'admin'@'172.17.0.25' (using password: YES) in - on line 7

MySQL Connection Error: (1045) Access denied for user 'admin'@'172.17.0.25' (using password: YES)

PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'admin'@'172.17.0.25' (using password: YES) in - on line 7

MySQL Connection Error: (1045) Access denied for user 'admin'@'172.17.0.25' (using password: YES)

PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'admin'@'172.17.0.25' (using password: YES) in - on line 7

MySQL Connection Error: (1045) Access denied for user 'admin'@'172.17.0.25' (using password: YES)

PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'admin'@'172.17.0.25' (using password: YES) in - on line 7

MySQL Connection Error: (1045) Access denied for user 'admin'@'172.17.0.25' (using password: YES)

PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'admin'@'172.17.0.25' (using password: YES) in - on line 7

MySQL Connection Error: (1045) Access denied for user 'admin'@'172.17.0.25' (using password: YES)

PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'admin'@'172.17.0.25' (using password: YES) in - on line 7

MySQL Connection Error: (1045) Access denied for user 'admin'@'172.17.0.25' (using password: YES)

PHP Warning: mysqli::mysqli(): (28000/1045): Access denied for user 'admin'@'172.17.0.25' (using password: YES) in - on line 7

MySQL Connection Error: (1045) Access denied for user 'admin'@'172.17.0.25' (using password: YES)

\[root@Optimus ~\]\#

改用docker0网卡的IP地址172.17.42.1仍然不行。

查看数据库用户信息如下

查看数据库用户

MariaDB \[(none)\]> select \* from mysql.user;

Host

User

Password

Select\_priv

Insert\_priv

Update\_priv

Delete\_priv

Create\_priv

Drop\_priv

Reload\_priv

Shutdown\_priv

Process\_priv

File\_priv

Grant\_priv

References\_priv

Index\_priv

Alter\_priv

Show\_db\_priv

Super\_priv

Create\_tmp\_table\_priv

Lock\_tables\_priv

Execute\_priv

Repl\_slave\_priv

Repl\_client\_priv

Create\_view\_priv

Show\_view\_priv

Create\_routine\_priv

Alter\_routine\_priv

Create\_user\_priv

Event\_priv

Trigger\_priv

Create\_tablespace\_priv

ssl\_type

ssl\_cipher

x509\_issuer

x509\_subject

max\_questions

max\_updates

max\_connections

max\_user\_connections

plugin

authentication\_string

localhost

root

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

0

0

0

0

9ad32fb968fe

root

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

0

0

0

0

127.0.0.1

root

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

0

0

0

0

::1

root

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

0

0

0

0

localhost

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

0

0

0

0

9ad32fb968fe

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

0

0

0

0

%

admin

\*318BF8C339F1F04B052E3D1ED22C2B5873740C5A

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

0

0

0

0

localhost

admin

\*318BF8C339F1F04B052E3D1ED22C2B5873740C5A

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

0

0

0

0

127.0.0.1

admin

\*318BF8C339F1F04B052E3D1ED22C2B5873740C5A

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

N

0

0

0

0

构建镜像过程

构建过程中的几个小问题：

使用的WORDPRESS\_DB\_HOST地址是eth1网卡的地址。原本应该用eth0网卡的地址，但是ifconfig eth0显示没有IP地址。我就拿eth1网卡代替了。

\[root@Optimus ~\]\# ifconfig eth0

eth0 Link encap:Ethernet HWaddr 00:1E:67:4E:3D:7B

UP BROADCAST MULTICAST MTU:1500 Metric:1

RX packets:0 errors:0 dropped:0 overruns:0 frame:0

TX packets:0 errors:0 dropped:0 overruns:0 carrier:0

collisions:0 txqueuelen:1000

RX bytes:0 (0.0 b) TX bytes:0 (0.0 b)

Memory:d0960000-d097ffff

\[root@Optimus ~\]\# ifconfig eth1

eth1 Link encap:Ethernet HWaddr 00:1E:67:4E:3D:7C

inet addr:10.10.4.182 Bcast:10.10.4.255 Mask:255.255.255.0

inet6 addr: fe80::21e:67ff:fe4e:3d7c/64 Scope:Link

UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1

RX packets:225279050 errors:0 dropped:0 overruns:0 frame:0

TX packets:78413400 errors:0 dropped:0 overruns:0 carrier:0

collisions:0 txqueuelen:1000

RX bytes:42774258179 (39.8 GiB) TX bytes:107200782231 (99.8 GiB)

Memory:d0940000-d095ffff

2. 构建DB容器 docker run的时候，使用的是3307:3306做端口映射。本应该用3306:3306作为端口映射，但是由于3306端口被占用，所以我自己用了3307做了替换。

启动docker容器

\[root@Optimus /\]\# docker run -d -p 9090:80 --name wordpress -e WORDPRESS\_DB\_HOST=10.10.4.182 -e WORDPRESS\_DB\_USER=admin -e WORDPRESS\_DB\_PASSWORD=csphere2015 csphere/wordpress:4.2

a6aae74c483a9d662594695dc420d183bdb0ad52fdc844783456d40a22e5114a

这里启动一个WordPress的docker容器，端口映射为9090，因为80端口已经占用了。

容器名为WordPress，宿主机地址是eth1的网卡地址10.10.4.182。(这里原本要用内网网卡eth0的IP地址，但是ifconfig eth0 显示没有IP地址，我换成了eth1的IP地址)

三个环境变量WORDPRESS\_DB\_HOST、WORDPRESS\_DB\_USER、WORDPRESS\_DB\_PASSWORD在脚本init.sh中定义。

使用的是csphere/wordpress:4.2 这个镜像。

查看docker容器

查看docker容器状态，是UP状态，启动成功

\[root@Optimus /\]\# docker ps -a

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES

a6aae74c483a csphere/wordpress:4.2 "/init.sh /usr/bin/s 5 seconds ago Up 4 seconds 22/tcp, 443/tcp, 0.0.0.0:9090->80/tcp wordpress

8e266cd27a63 csphere/mysql:5.5 "/scripts/start" 23 hours ago Up 23 hours 22/tcp, 0.0.0.0:3307->3306/tcp newdb

e274049db704 csphere/php-fpm:5.4 "/usr/bin/supervisor 6 days ago Up 6 days 22/tcp, 443/tcp, 0.0.0.0:8080->80/tcp website

2d36dbfc72a0 csphere/centos:7.1 "/usr/bin/supervisor 7 days ago Up 7 days 0.0.0.0:2222->22/tcp base

0d1f6225836b centos "/bin/bash" 8 days ago Exited (127) 8 days ago naughty\_engelbart

说明：这里使用的DB容器端口映射使用的3307端口，因为3306端口本地已经被占用了。

访问应用

访问页面的时候，出错。

![1e67f946021aa44eda4c31d7058445c8.png][]

查看容器状态

此时，再次查看容器，已经关闭了，状态为excited

\[root@Optimus /\]\# docker ps -a

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES

a6aae74c483a csphere/wordpress:4.2 "/init.sh /usr/bin/s About a minute ago Exited (1) About a minute ago wordpress

8e266cd27a63 csphere/mysql:5.5 "/scripts/start" 23 hours ago Up 23 hours 22/tcp, 0.0.0.0:3307->3306/tcp newdb

e274049db704 csphere/php-fpm:5.4 "/usr/bin/supervisor 6 days ago Up 6 days 22/tcp, 443/tcp, 0.0.0.0:8080->80/tcp website

2d36dbfc72a0 csphere/centos:7.1 "/usr/bin/supervisor 7 days ago Up 7 days 0.0.0.0:2222->22/tcp base

0d1f6225836b centos "/bin/bash" 8 days ago Exited (127) 8 days ago naughty\_engelbart

删除WordPress容器，用同样的方法再重新启动，还是同样的问题：显示启动成功UP状态后，再次查看又变成excited状态，无法访问网页应用。

下面是一些操作过程中的步骤：

[56edc1e181ba48481482d4c4088baf77.png]: /images/20221119/7f6ac1d516c5441eb9223e6d9c451ba6.png
[1e67f946021aa44eda4c31d7058445c8.png]: https://img-blog.csdnimg.cn/img_convert/1e67f946021aa44eda4c31d7058445c8.png

发表评论取消回复

表情：

评论列表（有 0 条评论，219人围观）

还没有评论，来说两句吧...

相关阅读

相关 docker启动mysql容器后又退出_为什么docker容器启动成功几分钟后又自己关闭了？...

总结问题描述通过docker run启动一个 WordPress 应用的 docker 容器时，显示启动成功为UP状态，但无法访问 WordPress 应用，并且几分

╰+攻爆jí腚メ/ 2023年01月11日 13:26/ 0 赞/ 220 阅读

相关 Docker启动关闭所有容器命令

docker中启动所有的容器命令 `docker start $(docker ps -a | awk '{ print $1}' | tail -n +2)` dock

绝地灬酷狼/ 2022年10月10日 12:49/ 0 赞/ 230 阅读

相关 Docker mysql容器修改配置文件后无法启动

情景复现: 在docker中修改了mysql容器的配置文件/etc/mysql/my.cnf , 修改后发现mysql容器无法启动了,想要修改回来,提示容器未启动,怎么办呢

阳光穿透心脏的1/2处/ 2022年08月28日 15:57/ 0 赞/ 735 阅读

相关 docker容器启动后马上退出解决方案

最近在看docker如何让容器在启动时直接运行某些进程，后来发现Dockerfile可以在容器启动的时候指定容器运行命令。 CMD指定，但是每个Dockerfile只能有一条

朴灿烈づ我的快乐病毒、/ 2022年05月19日 02:49/ 0 赞/ 1069 阅读

相关在win 10关闭并启动后，Docker将无法启动容器

<table> <tbody> <tr> <td style="width:698px;"> <h3>预期的行为</h3> <p>在正常情况下击败胜利10并且

迷南。/ 2022年04月03日 03:13/ 0 赞/ 343 阅读

相关 Docker MySQL 容器备份启动

1. 首先打开你们安装好docker的终端，你得从官网拉取一个mysql镜像（image），我这里选择tag为5.7。 docker pull my

末蓝、/ 2022年03月25日 16:06/ 0 赞/ 237 阅读

相关开机后Docker自启动，容器自启动

1.系统开机自启动docker容器开机启动 docker systemctl enable docker 2.docker启动后，容器自启动

ゝ一世哀愁。/ 2021年11月26日 22:10/ 0 赞/ 525 阅读

相关 docker容器启动后修改或添加端口

docker容器启动后怎么修改端口映射？在docker run创建并运行容器的时候，可以通过-p指定端口映射规则。但是，也会遇到刚开始忘记设置端口映射或者设置错了需要修改的情况

￡神魔★判官ぃ/ 2021年09月07日 06:20/ 1 赞/ 731 阅读

相关 docker更改mysql配置文件后，无法启动mysql容器

首先经过这次事件，建议docker里面不要放数据库了，真的太危险了。修改了mysql的配置文件后，没有做配置文件映射，然后容器启动不了，导致整个数据库停掉真的太可怕了。 ...

红太狼/ 2021年01月19日 11:11/ 0 赞/ 1001 阅读

相关 Docker 启动容器

启动容器有两种方式，一种是基于镜像新建一个容器并启动，另外一个是将在终止状态（`stopped`）的容器重新启动。

朱雀/ 2020年05月17日 13:25/ 0 赞/ 2234 阅读