Table of Contents

Setting up PHPmyAdmin for Raspberry Pi

Share on facebook
Share on twitter
Share on telegram
Share on linkedin
Share on whatsapp
Share on reddit
Share on email

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.

phpmyAdmin

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

Related Post
heimdall

Heimdall for your self hosted Applications

Heimdall is a great way to organize all your most used websites and self hosted web applications.
Ads

Comments

0 0 vote
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x