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-<version tag>
arm64	✅	arm64v8-<version tag>
armhf	❌

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.

Usage¶

To help you get started creating a container from this image you can either use docker-compose or the docker cli.

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.

Ports (`-p`)¶

Parameter	Function
`80`	Port for web frontend

Environment Variables (`-e`)¶

Env	Function
`PUID=1000`	for UserID - see below for explanation
`PGID=1000`	for GroupID - see below for explanation
`TZ=Etc/UTC`	specify a timezone to use, see this list.
`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)
`PMA_ABSOLUTE_URI=https://phpmyadmin.example.com`	Set the URL you will use to access the web frontend

Volume Mappings (`-v`)¶

Volume	Function
`/config`	Persistent config files

Miscellaneous Options¶

Parameter	Function

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:
```
docker exec -it phpmyadmin /bin/bash
```
To monitor the logs of the container in realtime:
```
docker logs -f phpmyadmin
```

Container version number:

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

Image version number:

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:
```
docker-compose pull
```
Single image:
```
docker-compose pull phpmyadmin
```

Update containers:

All containers:
```
docker-compose up -d
```
Single container:
```
docker-compose up -d phpmyadmin
```

You can also remove the old dangling images:
```
docker image prune
```

Via Docker Run¶

Update the image:

docker pull lscr.io/linuxserver/phpmyadmin:latest

Stop the running container:
```
docker stop phpmyadmin
```
Delete the container:
```
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:
```
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 x86_64 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¶

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.

linuxserver/phpmyadmin¶