Setting up PHPmyAdmin for Raspberry Pi

Need to manage your SQL Databases? Use PHPmyAdmin!

More information on DockerHub, GitHub.

1. Installation

Create a new directory and cd into it.

mkdir phpmyadmin && cd phpmyadmin

Then nano a docker-compose.yml

nano docker-compose.yml

And past this: (replace the passwords)

version: "2.1"
services:
  mariadb_test:
    image: linuxserver/mariadb
    container_name: mariadb_test
    environment:
      - PUID=1000
      - PGID=1000
      - MYSQL_ROOT_PASSWORD=root_password
      - TZ=Europe/Berlin
      - MYSQL_USER=username
      - MYSQL_PASSWORD=password
    volumes:
      - ./config:/config
    ports:
      - 3308:3306
    restart: unless-stopped

  myadmin:
    image: ebspace/armhf-phpmyadmin
    container_name: myadmin
    volumes:
      - ./config:/etc/phpmyadmin/config.user.inc.php
    restart: always
    ports:
      - 8085:80
    depends_on:
      - mariadb_test
    links:
      - mariadb_test:db

Now spin up the Stack.

docker-compose up -d

2. Logging in

Visit the IP of your Pi with  “:8085/phpmyadmin” added at the end.

Log in with the username and password you provided in the docker-compose.yml.