Need help with docker?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.

About the developer

phpmyadmin
479 Stars 370 Forks GNU General Public License v3.0 500 Commits 40 Opened issues

Description

Docker container for phpMyAdmin

Services available

!
?

Need anything else?

Contributors list

Official phpMyAdmin Docker image

Note that since phpMyAdmin has been accepted in to the official DockerHub repository, you can use either that or this older phpMyAdmin repository for your Docker installation. This is maintained as a courtesy to users who have not migrated.

Run phpMyAdmin with Alpine, Apache and PHP FPM.

GitHub CI build status badge update.sh build status badge amd64 build status badge arm32v5 build status badge arm32v6 build status badge arm32v7 build status badge arm64v8 build status badge i386 build status badge mips64le build status badge ppc64le build status badge s390x build status badge Docker Pulls Docker Stars Docker Layers Docker Version

All of the following examples will bring you phpMyAdmin on

http://localhost:8080
where you can enjoy your happy MySQL administration.

Credentials

phpMyAdmin connects using your MySQL server credentials. Please check your corresponding database server image for information on the default username and password or how to specify your own custom credentials during installation.

The official MySQL and MariaDB images use the following environment variables to define these:

  • MYSQL_ROOT_PASSWORD
    - This variable is mandatory and specifies the password that will be set for the
    root
    superuser account.
  • MYSQL_USER
    ,
    MYSQL_PASSWORD
    - These variables are optional, used in conjunction to create a new user and to set that user's password.

Supported Docker Hub tags

The following tags are available:

  • latest
    ,
    fpm
    , and
    fpm-alpine
    are always the most recent released version
  • Major versions, such as
    5
    ,
    5-fpm
    , and
    5-fpm-alpine
  • Specific minor versions, such as
    5.0
    ,
    5.0-fpm
    , and
    5-fpm-alpine
  • Specific patch versions, such as
    5.0.0
    ,
    5.0.0-fpm
    , and
    5.0.0-alpine
    . Note that, on rare occasion, there may be an intermediary "docker-only" release, such as 4.9.2-1

A complete list of tags is available at Docker Hub

Image variants

We provide three variations:

  • "apache" includes a full Apache webserver with PHP and includes everything needed to work out of the box. This is the default when only a version number is requested.
  • "fpm" only starts a PHP FPM container. Use this variant if you already have a separate webserver. This includes more tools and is therefore a larger image than the "fpm-alpine" variation.
  • "fpm-alpine" has a very small footprint. It is based on Alpine Linux and only starts a PHP FPM process. Use this variant if you already have a separate webserver. If you need more tools that are not available on Alpine Linux, use the fpm image instead.

Usage with linked server

First you need to run a MySQL or MariaDB server in Docker, and the phpMyAdmin image needs to be linked to the running database container:

docker run --name myadmin -d --link mysql_db_server:db -p 8080:80 phpmyadmin

Usage with external server

You can specify a MySQL host in the

PMA_HOST
environment variable. You can also use
PMA_PORT
to specify the port of the server in case it's not the default one:
docker run --name myadmin -d -e PMA_HOST=dbhost -p 8080:80 phpmyadmin

Usage with arbitrary server

You can use arbitrary servers by adding the environment variable

PMA_ARBITRARY=1
to the startup command:
docker run --name myadmin -d -e PMA_ARBITRARY=1 -p 8080:80 phpmyadmin

Usage with docker-compose and arbitrary server

This will run phpMyAdmin with the arbitrary server option - allowing you to specify any MySQL/MariaDB server on the login page.

version: '3.1'

services: db: image: mariadb:10.3 restart: always environment: MYSQL_ROOT_PASSWORD: notSecureChangeMe

phpmyadmin: image: phpmyadmin restart: always ports: - 8080:80 environment: - PMA_ARBITRARY=1

Run the E2E tests with docker-compose

You can run the E2E tests with the local test environment by running MariaDB/MySQL databases. Adding ENV variable

PHPMYADMIN_RUN_TEST=true
already added on docker-compose file. Simply run:

Using the docker-compose.testing.yml from https://github.com/phpmyadmin/docker

docker-compose -f docker-compose.testing.yml up phpmyadmin

Adding Custom Configuration

You can add your own custom config.inc.php settings (such as Configuration Storage setup) 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:
-v /some/local/directory/config.user.inc.php:/etc/phpmyadmin/config.user.inc.php

On the

docker run
line like this:
docker run --name myadmin -d --link mysql_db_server:db -p 8080:80 -v /some/local/directory/config.user.inc.php:/etc/phpmyadmin/config.user.inc.php phpmyadmin

See the following links for config file information:

  • https://docs.phpmyadmin.net/en/latest/config.html#config
  • https://docs.phpmyadmin.net/en/latest/setup.html

Usage behind a reverse proxy

Set the variable

PMA_ABSOLUTE_URI
to the fully-qualified path (
https://pma.example.net/
) where the reverse proxy makes phpMyAdmin available.

Environment variables summary

  • PMA_ARBITRARY
    - when set to 1 connection to the arbitrary server will be allowed
  • PMA_HOST
    - define address/host name of the MySQL server
  • PMA_VERBOSE
    - define verbose name of the MySQL server
  • PMA_PORT
    - define port of the MySQL server
  • PMA_HOSTS
    - define comma separated list of address/host names of the MySQL servers
  • PMA_VERBOSES
    - define comma separated list of verbose names of the MySQL servers
  • PMA_PORTS
    - define comma separated list of ports of the MySQL servers
  • PMA_USER
    and
    PMA_PASSWORD
    - define username and password to use only with the
    config
    authentication method
  • PMA_ABSOLUTE_URI
    - the full URL to phpMyAdmin. Sometimes needed when used in a reverse-proxy configuration. Don't set this unless needed. See documentation.
  • PMA_CONFIG_BASE64
    - if set, this option will override the default
    config.inc.php
    with the base64 decoded contents of the variable
  • PMA_USER_CONFIG_BASE64
    - if set, this option will override the default
    config.user.inc.php
    with the base64 decoded contents of the variable
  • PMA_CONTROLHOST
    - when set, this points to an alternate database host used for storing the phpMyAdmin Configuration Storage database database
  • PMA_CONTROLPORT
    - if set, will override the default port (3306) for connecting to the control host for storing the phpMyAdmin Configuration Storage database database
  • PMA_PMADB
    - define the name of the database to be used for the phpMyAdmin Configuration Storage database. When not set, the advanced features are not enabled by default (they can still potentially be enabled by the user when logging in with the zero conf (zero configuration) feature. Suggested values:
    phpmyadmin
    or
    pmadb
  • PMA_CONTROLUSER
    - define the username for phpMyAdmin to use for advanced features (the controluser)
  • PMA_CONTROLPASS
    - define the password for phpMyAdmin to use with the controluser
  • PMA_QUERYHISTORYDB
    - when set to true, enables storing SQL history to the phpMyAdmin Configuration Storage database. When false, history is stored in the browser and is cleared when logging out
  • PMA_QUERYHISTORYMAX
    - when set to an integer, controls the number of history items. See documentation. Defaults to
    25
    .
  • MAX_EXECUTION_TIME
    - if set, will override the maximum execution time in seconds (default 600) for phpMyAdmin ($cfg['ExecTimeLimit']) and PHP maxexecutiontime (format as
    [0-9+]
    )
  • MEMORY_LIMIT
    - if set, will override the memory limit (default 512M) for phpMyAdmin ($cfg['MemoryLimit']) and PHP memory_limit (format as
    [0-9+](K,M,G)
    )
  • UPLOAD_LIMIT
    - if set, this option will override the default value for apache and php-fpm (format as
    [0-9+](K,M,G)
    default value is 2048K, this will change
    upload_max_filesize
    and
    post_max_size
    values)
  • HIDE_PHP_VERSION
    - if defined, this option will hide the PHP version (
    expose_php = Off
    ). Set to any value (such as
    HIDE_PHP_VERSION=true
    ).

For usage with Docker secrets, appending

_FILE
to the
PMA_PASSWORD
environment variable is allowed (it overrides
PMA_PASSWORD
if it is set):
docker run --name myadmin -d -e PMA_PASSWORD_FILE=/run/secrets/db_password.txt -p 8080:80 phpmyadmin

Variables that can be read from a file using
_FILE

  • PMA_PASSWORD
  • MYSQL_ROOT_PASSWORD
  • MYSQL_PASSWORD
  • PMA_HOSTS
  • PMA_HOST
  • PMA_CONTROLPASS

For more detailed documentation see https://docs.phpmyadmin.net/en/latest/setup.html#installing-using-docker

Please report any issues with the Docker container to https://github.com/phpmyadmin/docker/issues

Please report any issues with phpMyAdmin to https://github.com/phpmyadmin/phpmyadmin/issues

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.