加入收藏 | 设为首页 | 会员中心 | 我要投稿 商洛站长网 (https://www.0914zz.com/)- AI应用、CDN、边缘计算、云计算、物联网!
当前位置: 首页 > 数据库 > MySql > 正文

如何使用运行MySQL构建Docker容器?

发布时间:2020-11-18 12:17:22 所属栏目:MySql 来源:互联网
导读:我的目标是拥有一个具有运行MySQL服务的docker容器.所以每当我启动容器时,数据库都处于初始状态并且MySQL正在运行.几乎一切都很好但是当我启动容器时MySQL服务没有运行.每次在控制台中我都必须像这样启动它:service mysql start.以下是我构建和运行容器的步

我的目标是拥有一个具有运行MySQL服务的docker容器.所以每当我启动容器时,数据库都处于初始状态并且MySQL正在运行.
几乎一切都很好但是当我启动容器时MySQL服务没有运行.每次在控制台中我都必须像这样启动它:service mysql start.
以下是我构建和运行容器的步骤:

$docker build -t executer:mysql .
Sending build context to Docker daemon 15.87 kB
Sending build context to Docker daemon 
Step 0 : FROM debian:wheezy
#
# ... Many steps without error
#
Step 17 : RUN mysql_install_db --user=mysql --basedir=/usr/ --ldata=/var/lib/mysql/
 ---> Using cache
 ---> 1c71bf4524f0
Step 18 : RUN service mysql start
 ---> Running in b4643765b79b

......
MySQL Community Server 5.6.24 is started.
 ---> ac26b749a3c0
Removing intermediate container b4643765b79b
Successfully built ac26b749a3c0 

$docker run --rm -it executer:mysql /bin/bash
root@1d9208c19af0:/# mysql
ERROR 2002 (HY000): Cant connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
root@1d9208c19af0:/# service mysql start
No directory,logging in with HOME=/
......
[info] MySQL Community Server 5.6.24 is started.
root@1d9208c19af0:/# mysql
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 1
Server version: 5.6.24 MySQL Community Server (GPL)

Copyright (c) 2000,2015,Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

mysql> 

这是Dockerfile的内容:

FROM debian:wheezy

# add our user and group first to make sure their IDs get assigned consistently,regardless of whatever dependencies get added
RUN groupadd -r mysql && useradd -r -g mysql mysql

# FATAL ERROR: please install the following Perl modules before executing /usr/local/mysql/scripts/mysql_install_db:
# File::Basename
# File::Copy
# Sys::Hostname
# Data::Dumper
RUN apt-get update && apt-get install -y perl --no-install-recommends && rm -rf /var/lib/apt/lists/*

# gpg: key 5072E1F5: public key "MySQL Release Engineering 

运行我的容器后,如何更改我的Dockerfile以运行MySQL服务? 最佳答案 我试过你的设置

见https://github.com/BITPlan/docker-stackoverflowanswers/tree/master/33299303

我先得到了

E: Version '5.6.24*' for 'mysql-server' was not found

这与你的问题无关,但需要修复.
所以我注释掉你的大部分Dockerfile并添加:

RUN apt-get install mysql-server-5.5

这给了:
E:无法找到包mysql-server-5.5

这是特定于发行版的,所以我将FROM行更改为

FROM ubuntu:14.04

我更熟悉

然后我修改了Dockerfile来改变

RUN service mysql start

CMD service mysql start

正如michaelbahr的评论中所提到的那样

./run 

root@96ff34b4e0c0:/# service --status-all 2>&1 | grep mysql

结果显示:

[ ? ]  mysql

你在那里 – mysql运行.
您可能希望相应地修复Dockerfile.

(编辑:商洛站长网)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读