How can I access my docker maria db?

mysql docker mariadb
MorRich picture MorRich · Oct 16, 2015 · Viewed 29k times · Source

My main question is that after I have created a docker container for my mariadb with the command docker run --name db -e MYSQL_ROOT_PASSWORD=test -d -p 3306:3306 mariadb how can I access the sql db?

Somewhere I have seen a solution using a temporal (after exit the container is deleted) container, but cannot find it anymore.

I am searching for a command like: sudo docker exec -it [other flags] [command] db.

Answer

michaelbahr picture michaelbahr · Oct 16, 2015

Just mysql-client, no extra docker container

Install the mysql client on your host,

apt-get install mysql-client

then use the following command to access your database container.

mysql -u<user> -p<pass> -h $(docker inspect --format '{{ .NetworkSettings.IPAddress }}' <db-container>)

The command will automatically get the IP of your docker container.

Make sure to replace <user>, <pass> and <db-container> with your respective values. In your case:

mysql -uroot -ptest -h $(docker inspect --format '{{ .NetworkSettings.IPAddress }}' db)

Your command lets mariadb run at the standard port 3306. If not, you have to tell the mysql command the new port.

Related questions

Install mysql in dockerfile?

I want to write simple python application and put in docker conteiner with dockerfile. My dockerfile is: FROM ubuntu:saucy # Install required packages RUN apt-get update RUN DEBIAN_FRONTEND=noninteractive apt-get -y install python RUN DEBIAN_FRONTEND=noninteractive apt-get -y …

Read More
Connect to mysql in a docker container from the host

(It's probably a dumb question due to my limited knowledge with Docker or mysql administration, but since I spent a whole evening on this issue, I dare to ask it.) In a nutshell I want to run mysql in a …

Read More
How can I initialize a MySQL database with schema in a Docker container?

I am trying to create a container with a MySQL database and add a schema to these database. My current Dockerfile is: FROM mysql MAINTAINER (me) <email> # Copy the database schema to the /data directory COPY files/epcis_…

Read More