How to Install phpMyAdmin on Your Synology NAS

How to Install phpMyAdmin on Your Synology NAS

Synology already supports phpMyAdmin having made it downloadable via Package Center. In today’s article I want to teach you how to install the Docker version of phpMyAdmin which will help you connect to the Docker version of the MariaDB database. phpMyAdmin is a free and open source administration tool for MySQL and MariaDB. In this step by step guide I will show you how to install phpMyAdmin on your Synology NAS using Docker.

💡Note: This guide works perfectly with the latest phpMyAdmin 5.2.1 release.

  • STEP 1

Please Support My work by Making a Donation.

  • STEP 2

Install Container Manager via Synology “Package Center”. If you run an older DSM version (under 7.2), search for Docker instead of Container Manager.

Download Container Manager Synology Docker

  • STEP 3

Go to Control Panel / Task Scheduler / Create / Scheduled Task / User-defined script. Follow the instructions in the image below.

Synology User Defined Script

  • STEP 4

Once you click on User-defined script, a new window will open. Follow the instructions below:

  1. General: In the Task field type in Install phpMyAdmin. Uncheck the “Enabled” option. Select root User.
  2. Schedule: Select Run on the following date then select “Do not repeat“.
  3. Task Settings: Check “Send run details by email“, add your email then copy paste the code below in the Run command area. After that, click OK.
docker run -d --name=phpmyadmin \
-p 2500:80 \
-e PMA_HOST=YOURNASLOCALIP \
-e PMA_PORT=3306 \
--restart always \
phpmyadmin

Note: Before you paste the code above in the Run command area below, change the value of PMA_HOST and add your own LOCAL NAS IP.

phpMyAdmin Synology NAS Set up 2 new 2023

  • STEP 5

After you click OK on STEP 4 a new warning pop up window will open. Click OK.

phpMyAdmin Synology NAS Set up 3

After you click OK, type in your DSM Password then click Submit. Follow the instructions in the image below.

Synology Task Scheduler Confirm Admin Password

  • STEP 6

After you click Submit on STEP 5, select your “Install phpMyAdmin” Task then click the “Run” tab. You will be asked to run Install phpMyAdmin – click OK. Follow the instructions in the image below.

phpMyAdmin Synology NAS Set up 4

  • STEP 7

Go back to STEP 1 or you will deal with karma 🙂

  • STEP 8

The installation process can take up to a few seconds/minutes. It will depend on your Internet speed connection. Now open your browser and type in http://Synology-ip-address:2500 Connect to your MariaDB using root as Username and add the Password you have chosen at STEP 5 in the MariaDB article. Click Log in. Follow the instructions in the image below.
Note: If you don’t want to use MariaDB as a database, you can go for MySQL and use root as Username and the Password you have chosen at STEP 5 in the MySQL article. Click Go. Follow the instructions in the image below.

phpMyAdmin Synology NAS Set up 5

Enjoy phpMyAdmin!

phpMyAdmin Synology NAS Set up 6

Note: If you want to run the phpMyAdmin container over HTTPS, check my guide on How to Run Docker Containers Over HTTPS.

Note: Can I run Docker on my Synology NAS? See the supported models.
Note: How to Back Up Docker Containers on your Synology NAS.
Note: Find out how to update the phpMyAdmin container with the latest image.
Note: How to Free Disk Space on Your NAS if You Run Docker.
Note: How to Schedule Start & Stop For Docker Containers.
Note: How to Activate Email Notifications.
Note: How to Add Access Control Profile on Your NAS.
Note: How to Change Docker Containers Restart Policy.
Note: How to Use Docker Containers With VPN.
Note: Convert Docker Run Into Docker Compose.
Note: How to Clean Docker.
Note: How to Clean Docker Automatically.
Note: Best Practices When Using Docker and DDNS.
Note: Some Docker Containers Need WebSocket.
Note: Find out the Best NAS Models For Docker.
Note: Activate Gmail SMTP For Docker Containers.

This post was updated on Monday / July 22nd, 2024 at 7:26 PM