phpMyAdmin on OpenMediaVault with Docker and Portainer | Raspberry Pi

In this segment, we are going to explain to you “How you can install phpMyAdmin with MariaDB on OpenMediaVault with the help of Docker and Portainer for Raspberry Pi all models”

phpMyAdmin requires MariaDB/MySQL

To start the setup first we need to install MariaDB and then we can go ahead and install phpMyAdmin.

OpenMediaVault Versions :

• OpenMediaVault-4
• OpenMediaVault-3

Software Required :

• Raspbian
• SD Card Formatter
• Etcher
• Putty
• Wireless Network Watcher

Recommended Articles

• How to install OpenMediaVault 5 on Raspberry Pi All Models
• OpenMediaVault 5 NAS Server on Raspberry Pi 4

Equipment Required		Optional
	Raspberry Pi 4		Case
	SD Card		Raspberry Pi Keyboard
	Ethernet Cable		Mouse
	Power Adapter
	External HDD
Shop now

We may earn a commission for purchases using our links. Learn more.

What is MariaDB?

MariaDB is a community-developed, commercially supported fork of the MySQL relational database management system (RDBMS), intended to remain free and open-source software under the GNU General Public License. Source // Wikipedia

Pull MariaDB through Command

• To download MariaDB through the command line, we need to log in to SSH and use the below-given command to download the image.

sudo docker pull mariadb

Credit to Linux Server

• Full Credit goes to linuxserver/mariadb
• For creating a MariaDB image for Raspberry Pi.

sudo docker pull linuxserver/mariadb

• If the first command doesn’t work you can always use the second one.
• After the image is successfully downloaded, we can go ahead and start configuring the container.

Docker Compose

---
version: "2.1"
services:
  mariadb:
    image: linuxserver/mariadb
    container_name: mariadb
    environment:
      - PUID=1000
      - PGID=1000
      - MYSQL_ROOT_PASSWORD=ROOT_ACCESS_PASSWORD
      - TZ=Europe/London
      - MYSQL_DATABASE=USER_DB_NAME #optional
      - MYSQL_USER=MYSQL_USER #optional
      - MYSQL_PASSWORD=DATABASE_PASSWORD #optional
      - REMOTE_SQL=http://URL1/your.sql,https://URL2/your.sql #optional
    volumes:
      - path_to_data:/config
    ports:
      - 3306:3306
    restart: unless-stopped

MariaDB Container Configuration

[wptabs id=”5873″]

• Once all the settings are configured correctly we can go ahead and Deploy the container.

What is phpMyAdmin?

phpMyAdmin is a free and open-source administration tool for MySQL and MariaDB. This is the most popular MySQL administration tool to manage databases and is widely used in web hosting services.

Credits to EBSPACE

• Full Credit goes to ebspace
• For creating a phpMyAdmin image for Raspberry Pi.

Command to pull Image

docker pull ebspace/armhf-phpmyadmin

Adding Custom Configuration

• You can add your own custom config.inc.php settings by creating a file named “config.user.inc.php” with the various user-defined settings in it, and then linking it into the container using:

docker run --name myadmin -d --link mysql_db_server:db -p 8080:80 -v /local_dir/config.user.inc.php:/etc/phpmyadmin/config.user.inc.php ebspace/armhf-phpmyadmin

[wptabs id=”5901″]

In conclusion

• Now, we can go ahead and access our phpMyAdmin on http://omv_ip_address:8085 because we have bound port 8085 to port 80.
• If you come across any issue with this article, please share your thoughts.

Did you find us helpful? Support us on Patreon, Follow us on Facebook