Run mysql instance in Docker container

Question

I want to run a mysql container in Docker. The Dockerfile that I use is the Dockerfile defined in the official repo[here]. I only extended this Dockerfile with 2 more lines so I can import a init sql file, like this :

    ADD my-init-file.sql /my-init-file.sql 
    CMD ["mysqld", "--init-file=/my-init-file.sql"]

I want to run this instance as a daemon but when I execute this command, from the documentation:

docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=mysecretpassword -d mysql

The container exits automatically. I want to run it as a daemon so I can link apps(like a wordpress site) in another container to the mysql database.

Maybe I am missing something. Can anyone show me how ?

[EDIT] I forgot to say that I ran docker logs my-container after starting the container and there is no error :

Running mysql_install_db ...
Finished mysql_install_db

docker ps shows no running container. My guess is the command executes successfully but the mysqld daemon does not start.

Nathaniel Waisbrot · Accepted Answer · 2015-01-24 16:56:42Z

1

Your Dockerfile seems fine. Your init file may be buggy, though. If MySQL terminates, then the container will terminate.

The first debug step is to look at the logs:

docker logs some-mysql

You can use this whether the container is stopped or running. Hopefully, you'll see something obvious, like you missed some semicolons.

If the logs don't help, the next thing to try is to get inside the container and see what's happening first-hand

docker run -e MYSQL_ROOT_PASSWORD=mysecretpassword -it mysql /bin/bash

This will get you a Bash shell inside your container. Then you can run

mysqld --init-file=/my-init-file.sql

And see what happens. Maybe something in your init file tells MySQL to exit cleanly, so you get no logs but the command terminates.

answered Jan 24, 2015 at 16:56

Nathaniel Waisbrot

24.7k7 gold badges77 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Dimitri Over a year ago

I edit my question. I will try your suggestion later

Dimitri Over a year ago

The command you provide with docker run does not start any shell. Is it normal?

Nathaniel Waisbrot Over a year ago

Then maybe your dockerfile does more than you posted. When I run docker run -it mysql:latest /bin/bash, I get a shell on the mysql container.

Dimitri Over a year ago

Hi, can you confirm that this Dockerfile starts the mysqld daemon? github.com/docker-library/mysql/blob/…

Dimitri Over a year ago

Can execute this command docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=mysecretpassword -d mysql for confirmation?

|

Vladis Spirenskas · Accepted Answer · 2015-01-24 16:45:33Z

0

Dmitri, after you made docker run with -d argument your container detached and already working as daemon if only CMD command not returned exit code.

You can check running containers by docker ps command. You can check all containers by running docker ps -a.

Also i think you will need to open mysql port outside the container. You can do it with -P argument or better way to make communication between containers is docker links.

answered Jan 24, 2015 at 16:45

Vladis Spirenskas

1315 bronze badges

Collectives™ on Stack Overflow

Run mysql instance in Docker container

2 Answers 2

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related