Skip to content

Examples for containerized databases

MySQL

Dockerhub

mysql

docker run -d --name mysql -e MYSQL_ROOT_PASSWORD=myql -e MYSQL_DATABASE=my-database -v mysql:/var/lib/mysql -p 3306:3306 mysql:latest

Access database from within the container via: mysql -uroot -pmyql my-database. Getting Information About Databases and Tables.

admin

docker run -d --name sql-adminer -p 8080:8080 adminer:latest

Log in with: - Server= Internal Ip of Docker Container/ container name if they are on the same user defined network - user=root - password=myql - Database: my-database

PostgreSQL

Postgre docker image

Dockerhub Nice tutorial

# create a user-defined bridge network so containers in it can address themself by the container name not only by ip address
docker network create --driver bridge pgnetwork

# create volume so db will be saved
docker volume create --driver local --name=pgvolume

# create docker container for postgres
docker run -d --rm \
--name pg-container \
-p 5432:5432 \
-e POSTGRES_USER=postgres \
-e POSTGRES_PASSWORD=postgres \
--network=pgnetwork \
--volume=pgvolume:/var/lib/postgresql/data \
postgres:latest


# standard db name is postgres. you can set it via:
# -e POSTGRES_DB=postgres

NOTE: if you restart this container with new passwords you may need to clear the volume. Inside of the container you can use the psql to interact with the database.

pgAdmin docker image

Documentation for pgAdmin image

docker run -d --rm \
--name pgAdmin-container \
-p 9080:80 \
-e PGADMIN_DEFAULT_EMAIL=example@mail.com \
-e PGADMIN_DEFAULT_PASSWORD=limoneneis \
--network=pgnetwork \
dpage/pgadmin4:4.20
  1. After starting the container
  2. Open http://localhost:9080/login in browser
  3. login with your PGADMIN_DEFAULT_EMAIL and your PGADMIN_DEFAULT_PASSWORD
  4. add server with
  5. host name address: pg-container
  6. username: postgres
  7. password: postgres

known issue

  1. An process named oka uses 100 of the cpu see
  2. When an application tries to connect to postgres for the second time the authentification fails because of an invalid password.