Phpmyadmin

Phpmyadmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB.

Image details

Pulls: 1.6M

Architectures: amd64, arm64

Image size: 49 MB

Latest: 5.2.3

User: linuxserverci

Created: Jun 23, 2021

Updated: 2 days ago

Status: active

Source details

Repo: phpmyadmin/phpmyadmin

Stars: 8k

Forks: 4k

Language: PHP

License: GPL-2.0

Latest: RELEASE_5_2_3 · 9 months ago

Updated: 4 hours ago

Website: www.phpmyadmin.net/

Configuration

Type

Container

Platform

linux

Image

linuxserver/phpmyadmin:latest

Ports

80:80/tcp

Volumes

/config : /srv/lsio/phpmyadmin/config

Env vars

PUID=1000PGID=1000TZ=Etc/UTCPMA_ARBITRARY=1PMA_ABSOLUTE_URI=https://phpmyadmin.example.com

Restart

unless-stopped

Template by technorabilia

Notes

Portainer App Templates by Technorabilia, based on data provided by LinuxServer.io.

Ensure to create the following volume directories on the host file system, or modify the paths in the volume mapping section under the advanced options below, as needed.

mkdir -p /srv/lsio/phpmyadmin/config

Installation

Ensure both Docker and Portainer are installed, and up-to-date
Log into your Portainer web UI
Under Settings → App Templates, paste the below URL
Head to Home → App Templates, and the list of apps will show up
Select the app you wish to deploy, fill in any config options, and hit Deploy

Template Import URL

https://raw.githubusercontent.com/Lissy93/portainer-templates/main/templates.json

Show Me

docker run -d --name Phpmyadmin \
  -p 80:80/tcp \
  -e 'PUID=1000' \
  -e 'PGID=1000' \
  -e 'TZ=Etc/UTC' \
  -e 'PMA_ARBITRARY=1' \
  -e 'PMA_ABSOLUTE_URI=https://phpmyadmin.example.com' \
  -v /srv/lsio/phpmyadmin/config:/config \
  --restart=unless-stopped \
  linuxserver/phpmyadmin:latest

Save this file as compose.yaml and run docker compose up -d
Use this only as a guide.

services:
  phpmyadmin:
    image: linuxserver/phpmyadmin:latest
    ports:
      - 80:80/tcp
    volumes:
      - /srv/lsio/phpmyadmin/config:/config
    environment:
      PUID: '1000'
      PGID: '1000'
      TZ: Etc/UTC
      PMA_ARBITRARY: '1'
      PMA_ABSOLUTE_URI: https://phpmyadmin.example.com
    restart: unless-stopped

Save this file as phpmyadmin-stack.yml, then from a manager node, run docker stack deploy -c phpmyadmin-stack.yml phpmyadmin

version: '3.8'
services:
  phpmyadmin:
    image: linuxserver/phpmyadmin:latest
    ports:
      - 80:80/tcp
    volumes:
      - /srv/lsio/phpmyadmin/config:/config
    environment:
      PUID: '1000'
      PGID: '1000'
      TZ: Etc/UTC
      PMA_ARBITRARY: '1'
      PMA_ABSOLUTE_URI: https://phpmyadmin.example.com
    deploy:
      restart_policy:
        condition: any

Save each file below into a folder, then run kubectl apply -f .
Written for k3s, but works on any cluster: bind mounts use hostPath, named volumes get a persistent volume claim, and ports are exposed via a LoadBalancer service.

`phpmyadmin-deployment.yaml`

apiVersion: apps/v1
kind: Deployment
metadata:
  name: phpmyadmin
  labels:
    app: phpmyadmin
spec:
  replicas: 1
  selector:
    matchLabels:
      app: phpmyadmin
  template:
    metadata:
      labels:
        app: phpmyadmin
    spec:
      containers:
        - name: phpmyadmin
          image: linuxserver/phpmyadmin:latest
          env:
            - name: PUID
              value: '1000'
            - name: PGID
              value: '1000'
            - name: TZ
              value: Etc/UTC
            - name: PMA_ARBITRARY
              value: '1'
            - name: PMA_ABSOLUTE_URI
              value: https://phpmyadmin.example.com
          ports:
            - containerPort: 80
              protocol: TCP
          volumeMounts:
            - name: phpmyadmin-data-0
              mountPath: /config
      volumes:
        - name: phpmyadmin-data-0
          hostPath:
            path: /srv/lsio/phpmyadmin/config

`phpmyadmin-service.yaml`

apiVersion: v1
kind: Service
metadata:
  name: phpmyadmin
spec:
  type: LoadBalancer
  selector:
    app: phpmyadmin
  ports:
    - name: 80-tcp
      port: 80
      targetPort: 80
      protocol: TCP

Save this file as ~/.config/containers/systemd/phpmyadmin.container

[Unit]
Description=Phpmyadmin

[Container]
Image=linuxserver/phpmyadmin:latest
ContainerName=phpmyadmin
PublishPort=80:80/tcp
Environment=PUID=1000
Environment=PGID=1000
Environment=TZ=Etc/UTC
Environment=PMA_ARBITRARY=1
Environment=PMA_ABSOLUTE_URI=https://phpmyadmin.example.com
Volume=/srv/lsio/phpmyadmin/config:/config

[Service]
Restart=always

[Install]
WantedBy=default.target

Then reload systemd and start the service:

systemctl --user daemon-reload
systemctl --user start phpmyadmin

For a system-wide service, use /etc/containers/systemd/ and drop --user.

For more installation options, see the Documentation in our GitHub repo

For app-specific guidance, check Phpmyadmin's own repo at phpmyadmin/phpmyadmin

The LinuxServer.io team brings you another container release featuring:

regular and timely application updates
easy user mappings (PGID, PUID)
custom base image with s6 overlay
weekly base OS updates with common layers across the entire LinuxServer.io ecosystem to minimise space usage, down time and bandwidth
regular security updates

Find us at:

Blog - all the things you can do with our containers including How-To guides, opinions and much more!
Discord - realtime support / chat with the community and the team.
Discourse - post on our community forum.
GitHub - view the source for all of our repositories.
Open Collective - please consider helping us by either donating or contributing to our budget

linuxserver/phpmyadmin

Phpmyadmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB.

Supported Architectures

We utilise the docker manifest for multi-platform awareness. More information is available from docker here and our announcement here.
Simply pulling lscr.io/linuxserver/phpmyadmin:latest should retrieve the correct image for your arch, but you can also pull specific arch images via tags.
The architectures supported by this image are:
| Architecture | Available | Tag | | :----: | :----: | ---- | | x86-64 | ✅ | amd64-\ | | arm64 | ✅ | arm64v8-\ |

Application Setup

This image uses nginx, in contrast to the official images which offer fpm-only or Apache variants.
We support all of the official environment variables for configuration as well as directly editing the config files.
For more information check out the phpmyadmin documentation.

Read-Only Operation

This image can be run with a read-only container filesystem. For details please read the docs.

Caveats

/tmp must be mounted to tmpfs
Custom themes are not supported

Non-Root Operation

This image can be run with a non-root user. For details please read the docs.

Caveats

Custom themes are not supported

Usage

To help you get started creating a container from this image you can either use docker-compose or the docker cli.
>!NOTE >Unless a parameter is flagged as 'optional', it is mandatory and a value must be provided.

docker-compose (recommended, click here for more info)

---
services:
  phpmyadmin:
    image: lscr.io/linuxserver/phpmyadmin:latest
    container_name: phpmyadmin
    environment:
      - PUID=1000
      - PGID=1000
      - TZ=Etc/UTC
      - PMA_ARBITRARY=1 #optional
      - PMA_ABSOLUTE_URI=https://phpmyadmin.example.com #optional
    volumes:
      - /path/to/phpmyadmin/config:/config
    ports:
      - 80:80
    restart: unless-stopped

docker cli (click here for more info)

docker run -d \
  --name=phpmyadmin \
  -e PUID=1000 \
  -e PGID=1000 \
  -e TZ=Etc/UTC \
  -e PMA_ARBITRARY=1 `#optional` \
  -e PMA_ABSOLUTE_URI=https://phpmyadmin.example.com `#optional` \
  -p 80:80 \
  -v /path/to/phpmyadmin/config:/config \
  --restart unless-stopped \
  lscr.io/linuxserver/phpmyadmin:latest

Parameters

Containers are configured using parameters passed at runtime (such as those above). These parameters are separated by a colon and indicate <external>:<internal> respectively. For example, -p 8080:80 would expose port 80 from inside the container to be accessible from the host's IP on port 8080 outside the container.
| Parameter | Function | | :----: | --- | | -p 80:80 | Port for web frontend | | -e PUID=1000 | for UserID - see below for explanation | | -e PGID=1000 | for GroupID - see below for explanation | | -e TZ=Etc/UTC | specify a timezone to use, see this list. | | -e PMA_ARBITRARY=1 | Set to 1 to allow you to connect to any server. Setting to 0 will only allow you to connect to specified hosts (See Application Setup) | | -e PMA_ABSOLUTE_URI=https://phpmyadmin.example.com | Set the URL you will use to access the web frontend | | -v /config | Persistent config files | | --read-only=true | Run container with a read-only filesystem. Please read the docs. | | --user=1000:1000 | Run container with a non-root user. Please read the docs. |

Environment variables from files (Docker secrets)

You can set any environment variable from a file by using a special prepend FILE__.
As an example:

-e FILE__MYVAR=/run/secrets/mysecretvariable

Will set the environment variable MYVAR based on the contents of the /run/secrets/mysecretvariable file.

Umask for running applications

For all of our images we provide the ability to override the default umask settings for services started within the containers using the optional -e UMASK=022 setting. Keep in mind umask is not chmod it subtracts from permissions based on it's value it does not add. Please read up here before asking for support.

User / Group Identifiers

When using volumes (-v flags), permissions issues can arise between the host OS and the container, we avoid this issue by allowing you to specify the user PUID and group PGID.
Ensure any volume directories on the host are owned by the same user you specify and any permissions issues will vanish like magic.
In this instance PUID=1000 and PGID=1000, to find yours use id your_user as below:

id your_user

Example output:

uid=1000(your_user) gid=1000(your_user) groups=1000(your_user)

Docker Mods

We publish various Docker Mods to enable additional functionality within the containers. The list of Mods available for this image (if any) as well as universal mods that can be applied to any one of our images can be accessed via the dynamic badges above.

Support Info

Shell access whilst the container is running:

```bash
docker exec -it phpmyadmin /bin/bash
```

To monitor the logs of the container in realtime:

```bash
docker logs -f phpmyadmin
```

Container version number:

```bash
docker inspect -f '{{ index .Config.Labels "build_version" }}' phpmyadmin
```

Image version number:

```bash
docker inspect -f '{{ index .Config.Labels "build_version" }}' lscr.io/linuxserver/phpmyadmin:latest
```

Updating Info

Most of our images are static, versioned, and require an image update and container recreation to update the app inside. With some exceptions (noted in the relevant readme.md), we do not recommend or support updating apps inside the container. Please consult the Application Setup section above to see if it is recommended for the image.
Below are the instructions for updating containers:

Via Docker Compose

Update images:

* All images:

    ```bash
    docker-compose pull
    ```

* Single image:

    ```bash
    docker-compose pull phpmyadmin
    ```

Update containers:

* All containers:

    ```bash
    docker-compose up -d
    ```

* Single container:

    ```bash
    docker-compose up -d phpmyadmin
    ```

You can also remove the old dangling images:

```bash
docker image prune
```

Via Docker Run

Update the image:

```bash
docker pull lscr.io/linuxserver/phpmyadmin:latest
```

Stop the running container:

```bash
docker stop phpmyadmin
```

Delete the container:

```bash
docker rm phpmyadmin
```

Recreate a new container with the same docker run parameters as instructed above (if mapped correctly to a host folder, your /config folder and settings will be preserved)
You can also remove the old dangling images:

```bash
docker image prune
```

Image Update Notifications - Diun (Docker Image Update Notifier)

>!TIP >We recommend Diun for update notifications. Other tools that automatically update containers unattended are not recommended or supported.

Building locally

If you want to make local modifications to these images for development purposes or just to customize the logic:

git clone https://github.com/linuxserver/docker-phpmyadmin.git
cd docker-phpmyadmin
docker build \
  --no-cache \
  --pull \
  -t lscr.io/linuxserver/phpmyadmin:latest .

The ARM variants can be built on x8664 hardware and vice versa using lscr.io/linuxserver/qemu-static
docker run --rm --privileged lscr.io/linuxserver/qemu-static --reset

Once registered you can define the dockerfile to use with -f Dockerfile.aarch64.
Versions
05.07.26: - Rebase to Alpine 3.24.
28.12.25: - Rebase to Alpine 3.23.
23.08.25: - Add support for mTLS. Existing users will need to delete their config.inc.php and restart the container.
05.07.25: - Rebase to Alpine 3.22.
19.12.24: - Rebase to Alpine 3.21.
27.05.24: - Existing users should update their nginx confs to avoid http2 deprecation warnings.
24.05.24: - Rebase to Alpine 3.20.
28.12.23: - Rebase to Alpine 3.19 with php 8.3.
25.12.23: - Existing users should update: site-confs/default.conf - Cleanup default site conf.
06.09.23: - Add support for custom themes.
25.05.23: - Rebase to Alpine 3.18, deprecate armhf.
13.04.23: - Move ssl.conf include to default.conf.
20.01.23: - Rebase to alpine 3.17 with php8.1.
18.11.22: - Rebasing to Alpine 3.16, migrate to s6v3.
20.08.22: - Rebasing to Alpine 3.15 with php8. Restructure nginx configs (see changes announcement).
23.01.22: - Pin versions to 5.x.x.
14.06.21: - Initial Release.

Serve Phpmyadmin on your own domain behind Caddy, Nginx or Traefik. Fill in your domain and copy the result. It's a starting point, some apps need their own base URL or extra headers set too.

Proxy Domain App port Upstream

Proxying phpmyadmin.example.com to http://Phpmyadmin:80

Add this to your Caddyfile

phpmyadmin.example.com {
	reverse_proxy http://Phpmyadmin:80
}

Check the logs first

Nine times out of ten the logs tell you exactly what went wrong.

In Portainer, go to Containers, click the container, then Logs. Or run docker logs Phpmyadmin
Exit codes help too: 137 means killed, usually out of memory. 126 or 127 means the command inside the image is broken.

Port already in use

If deployment fails with "Bind for 0.0.0.0:80 failed: port is already allocated", something else on your server is using that port.

Find what's using it: sudo ss -tlnp | grep :80
Stop the other service, or pick a different host port. In 80:80 only the left number is yours to change, the right one belongs to the app.

Running but the page won't load

The container is up but nothing appears in your browser.

Use your server's real IP: http://your-server-ip:80. The 0.0.0.0 link Portainer shows isn't a real address.
Give it a minute after first deploy, Phpmyadmin can take a while to initialise.
Make sure your firewall allows the port, e.g. sudo ufw allow 80

Permission denied on volumes

If the logs show "permission denied", the app can't write to its data folder on the host.

Fix the ownership: sudo chown -R 1000:1000 /srv/lsio/phpmyadmin/config
Or set the PUID and PGID variables (defaults 1000:1000) to match your own user, found with id $USER

Image won't pull

Test the pull directly on the host: docker pull linuxserver/phpmyadmin:latest

"manifest unknown" means the tag no longer exists. This template uses latest, so try pinning a specific version instead.
"toomanyrequests" is the Docker Hub rate limit. Log in with docker login to raise it.
"no space left on device" means a full disk. Reclaim space with docker system prune

"exec format error"

This means the image was built for a different CPU architecture than your server.

This image supports: amd64, arm64
Check yours with uname -m: x86_64 is amd64, aarch64 is arm64. Raspberry Pi and other ARM boards are the usual culprits.

Container keeps restarting

The unless-stopped restart policy relaunches the app after every crash, so the real error can scroll past.

Check the logs right after a restart, the last few lines before it died are the useful ones.
Get the exit code with docker inspect Phpmyadmin --format '{{.State.ExitCode}}'
Still stuck? Redeploy once with the restart policy set to no so the failure stays visible.

Raise an issue

Found something which isn't working as it should? Here's how to report it.

Bug within the app: Open an issue on phpmyadmin/phpmyadmin
Template not working: Open an issue on technorabilia/portainer-templates
This website not working: Open an issue on lissy93/portainer-templates

Similar apps

Mariadb Databases

Mysql-workbench Databases

Sqlitebrowser Databases

Phpmyadmin

Image details

Source details

Configuration

Notes

Installation

Via Portainer

Template Import URL

Docker Run

Docker Compose

Docker Swarm

Kubernetes

phpmyadmin-deployment.yaml

phpmyadmin-service.yaml

Podman Quadlet

Alternative Methods

Container Documentation

linuxserver/phpmyadmin

Supported Architectures

Application Setup

Read-Only Operation

Caveats

Non-Root Operation

Caveats

Usage

docker-compose (recommended, click here for more info)

docker cli (click here for more info)

Parameters

Environment variables from files (Docker secrets)

Umask for running applications

User / Group Identifiers

Docker Mods

Support Info

Updating Info

Via Docker Compose

Via Docker Run

Image Update Notifications - Diun (Docker Image Update Notifier)

Building locally

Versions

Recent versions

Proxy configurator

Troubleshooting

Check the logs first

Port already in use

Running but the page won't load

Permission denied on volumes

Image won't pull

"exec format error"

Container keeps restarting

Raise an issue

Similar apps

`phpmyadmin-deployment.yaml`

`phpmyadmin-service.yaml`