Commands to Install & Run Mariadb on Docker Container

MariaDB which is a fork of open supply MySQL may be simply put in on a Docker container to create Database for varied internet purposes comparable to WordPress, OwnCoud, and so on. The advantage of utilizing MariaDB on Docker container is you’ll not want a devoted server to separate your Database server from the remainder of the purposes.

However, studying curves might be there to handle containers. And right here we’ll provide help to perceive the fundamental steps to set up the MariaDB container and the way to run and entry it remotely to handle databases.

Steps to set up MariaDB container on Docker CE

Setup Docker Engine

The very first thing that have to be on your Windows or Linux server is the Docker. Although in case you are right here then you definitely would have already got it, if not then see the below-given hyperlinks:



Install MariaDB Docker Image

To arrange containers, we want the Image of the actual software that we would like to set up in that. You can create a Docker app picture by your self, nevertheless, fortunately the builders of Docker additionally present a repository of photos known as Docker Hub. From the place we will simply pull the newest photos of tons of of purposes to immediately create and begin with containers. And MariaDB can be current within the Hub. Here is the Hub Page featuring MariaDB. 

To set up the newest model of MariaDB on Docker merely run the pull command-

docker pull mariaDB

Note: In case you need to set up some earlier model, then see the hyperlink given for its Hub web page above and use the out there tags.


Run MariaDB Container and likewise ahead 3306 port

Now, there are a number of issues we will carry out whereas beginning the put in MariaDB container. Here are completely different situations and instructions corresponding to them.

Scenario 1: Set MariaDB docker container root password

You need to run MariaDB that may be accessed solely by the host and different containers. Then, run:

docker run --name mariadbh2s -e MYSQL_ROOT_PASSWORD=password -d mariadb

Note: Change the daring objects within the above command as per your selection.

Flags used within the above command:

--name mariadbh2s – To set the identify of the container in any other case it is going to get assigned one randomly.

-e MYSQL_ROOT_PASSWORD=password – For setting root password to Mariadb.

-d is to run the container within the background.


Scenario 2: Forward Container port to host

You need to run the MariaDB container and likewise need to entry the Database server from distant computer systems. Then map container’s MySQL port 3306 to host port 3306 port.

For this we’ve to add a syntax or flag:  -p host-port:conainer-port

For example- Here will probably be like this: -p 3306:3306  and simply add it within the command to ahead the port.

docker run --name mariadbh2s -p 3306:3306  -e MYSQL_ROOT_PASSWORD=password -d mariadb

You can even assign some host port dynamically to the container, in case the one you need is occupied by another service.

For that, the syntax might be like this: -p or -p 3306. However, if you assign a dynamic port, to discover out which port has been assigned and run-

docker ps

In the consequence, you’ll get the energetic container particulars together with the ports which were mapped with the host.

Command to find which docker port is dynamically assigned


Scenario 3: MariaDB Docker Container quantity mapping

As we all know Database is a vital factor for any software and in such a situation in case your container will get deleted, all the info might be gone. Thus, it is going to a good suggestion if we create a mirror copy of Docker MariaDB Volume on the host filesystem. As you add something to the MariaDB Docker container database server’s inside quantity this may even get copied to the mapped host listing. In this manner, we at all times have a backup copy of all our container knowledge.

Let’s create a listing, say /choose/mariadb/backup on the host to map it with the docker container of mariadb.

On the host system terminal type-

sudo mkdir -p /choose/mariadb/backup

-p stands for mother or father listing – means it is going to maintain different recordsdata.

Now, coming to the principle command. The default quantity or listing the place all the info of mariadb container shops is – /var/lib/mysql on docker. Thus, to map it with the one we’ve created, use the next command syntax with the -v flag.

-v  hostdirectory:container-direcotry

Hence, in case you go together with the one we’ve created then the above syntax might be like this –

-v /choose/mariadb/backup:/var/lib/mysql

And within the docker command-

docker run --name mariadbh2s -p 3306:3306 -v /choose/mariadb/backup:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=password -d mariadb

So, within the command, we’ve not solely forwarded the port but additionally have mapped the quantity that can stay on the host even after destroying the container.


Check Install MariaDB model

If you need to test the put in MariaDB container model with out switching to its bash. Then right here is the syntax-

docker exec -it container-name mysql -V

Note: Replace the container-name with the one you’ve set.


Access MariaDB Docker Container bash

Once the container is working you may entry its command bash immediately out of your host terminal utilizing this command-

docker exec -it contain-name /bin/bash

Here, in our case the container identify is mariadbh2s, thus the above command might be like this-

docker exec -it mariadbh2s /bin/bash

Note: Use your assigned container identify within the above command.

To give up, type-



Log in to Docker working container’s Database server from the host terminal

Although as soon as you might be in container’s bash utilizing the above command, you may  entry the database server by merely typing mysql -p

However, in case you don’t need to change each time to its container root shell, then it’s attainable to immediately entry MariaDB from the host terminal. For that set up MySQL shopper on Host.

For instance, in case your host is on Debian or Ubuntu-

sudo apt set up mysql-client

Whereas, RHEL primarily based methods can use-

sudo yum set up mysql-client

Now, discover out the IP handle of Mariabd working container-

docker examine container-name | grep IPAddress

Note– Replace the Container-name with the one you’ve assigned.

Find conainer IP address

Connect to the Ip-address you’ve got to log in to your MariaDB container.

mysql -u root -p -h ip-address


mysql -u root -p -h

Login to MariabDB database from Host terminal

Other Docker Container instructions


docker cease container-name


docker pause container-name


docker restart container-name


docker rm container-name

If you get some error then use pressure flag-

docker rm --force container-name


Well, in case you are utilizing Kitematic or another Focker GUI then the above command may be simpler to deal with. –




Related Posts