Public | Automated Build

Last pushed: a day ago
Short Description
A web interface for MySQL and MariaDB.
Full Description

Official phpMyAdmin Docker image

Run phpMyAdmin with Alpine, supervisor, nginx and PHP FPM.





All following examples will bring you phpMyAdmin on http://localhost:8080
where you can enjoy your happy MySQL administration.

Credentials

phpMyAdmin does use MySQL server credential, please check the corresponding
server image for information how it is setup.

The official MySQL and MariaDB use 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.

Docker hub tags

You can use following tags on Docker hub:

  • latest - latest stable release
  • 4.6 - latest stable release from the 4.6 branch
  • 4.7 - latest stable release from the 4.7 branch
  • edge - bleeding edge docker image (contains stable phpMyAdmin, but the Docker image changes might not yet be fully tested)
  • edge-4.7 - bleeding edge docker image + latest snapshots from 4.7 branch
  • edge-4.8 - bleeding edge docker image + latest snapshots from 4.8 branch (currently master)

Usage with linked server

First you need to run MySQL or MariaDB server in Docker, and this image need
link a running mysql instance container:

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

Usage with external server

You can specify MySQL host in the PMA_HOST environment variable. You can also
use PMA_PORT to specify 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/phpmyadmin

Usage with arbitrary server

You can use arbitrary servers by adding ENV variable PMA_ARBITRARY=1 to the startup command:

docker run --name myadmin -d --link mysql_db_server:db -p 8080:80 -e PMA_ARBITRARY=1 phpmyadmin/phpmyadmin

Usage with docker-compose and arbitrary server

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

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

docker-compose up -d

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/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 reverse proxys

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_USER and PMA_PASSWORD - define username to use for config authentication method
  • PMA_ABSOLUTE_URI - define user-facing URI

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

Docker Pull Command
Owner
phpmyadmin
Source Repository

Comments (23)
bamhm182
5 days ago

@fanyeqing, if you haven't figured it out already, I'm assuming you will need to do something like I just posted about to break out the nginx.conf file and make your changes there.

bamhm182
5 days ago

I managed to get ssl working if anyone is interested. It took me a couple tries to figure out due to my very basic, but growing, knowledge of docker. I ended up having to do a few things. Let's call my phpmyadmin server phpmyadmin.home with an ip address of 1.1.1.1. I went ahead and went into pfsense to generate a server key for phpmyadmin.home with the additional alias of 1.1.1.1 using an internal CA and intermediate CA that I created previously. Then I downloaded the certs for the CA, IntCA, and phpmyadmin and combined them with a command similar to "cat CA.crt IntCA.crt phpmyadmin.crt >> phpmyadmin_cert_chain.crt" and put both phpmyadmin_cert_chain.crt and phpmyadmin.key into a place that I would map to a location in the docker. Let's call it /dockerFiles/phpmyadmin. Then I had to get into my docker container with docker exec -it phpmyadmin /bin/sh and copy the file /etc/nginx.conf to that local /dockerFile/phpmyadmin directory. I created a temporary path at -v "/dockerFiles/phpmyadmin/copyOut":"/copyOut" and restarted the container, then just copied the nginx.conf file to /copyOut, left the docker container, then moved /dockerFiles/phpmyadmin/copyOut/nginx.conf to /dockerFiles/phpmyadmin/nginx.conf. At this point, I had nginx.conf, phpmyadmin_cert_chain.crt, and phpmyadmin.key in /dockerFiles/phpmyadmin/. I then modified the nginx.conf file to replace "listen 80 default_server" with "listen 443 default_server" and added the following lines just after it:

ssl on;
ssl_certificate /etc/ssl/phpmyadmin_cert_chain.crt;
ssl_certificate_key /etc/ssl/phpmyadmin.key;

Finally, I made sure that the permissions on /dockerFiles/phpmyadmin/phpmyadmin.key were 400 with the owner:group of root:root and started it with the following paths:
-v "/dockerFiles/phpmyadmin/phpmyadmin.key":"/etc/ssl/phpmyadmin.key" -v "/dockerFiles/phpmyadmin/phpmyadmin_cert_chain.crt":"/etc/ssl/phpmyadmin_cert_chain.crt" -v "/dockerFiles/phpmyadmin/nginx.conf":"/etc/nginx.conf"

Once it was booted, I was able to obtain an ssl connection either via https://1.1.1.1 or https://phpmyadmin.home

I used the following resources to help me figure this one out:
https://www.namecheap.com/support/knowledgebase/article.aspx/9419//installing-a-certificate-on-nginx
https://www.youtube.com/watch?v=vZpAIKJ9jyA

Hope this helps someone!

fanyeqing
3 months ago

Is there anyway to to make the access URL become http://localhost:8080/phpmyadmin ???
Any plan to support this ?

ericfjosne
3 months ago

Hi Guys,

I used to run multiple dockerized MySQL servers on a same host, exposed to the network via port mapping, and access them via a dockerized phpmyadmin, referencing those MySQL servers via the PMA_HOSTS environment variable, as follow:

PMA_HOSTS="my-lovely-server:3306,my-lovely-server:6603,my-lovely-server:7777"

This was working perfectly with version 4.6.5. However, version 4.6.6 does not seem to like this, at all.

Would you have anything to recommend regarding this use case ?

Many thanks for your help !

Eric

drevilkuko
3 months ago

Hi Guys,

Can anyone advice how to install the latest version from master? I understand that tags 4.7 or master are not available, right? The :edge is currently 4.6 stable (4.6.6), but how can I install the latest from master?

Thanks,
George

fanyeqing
4 months ago

Is there anyway to to make the access URL become http://localhost:8080/phpmyadmin ???

azote
5 months ago

I cannot go trough PMA login

gfelot
6 months ago

I cannot go trough PMA login. See here

Thank for any help

rslid
7 months ago

I had a lot of struggle with creating custom config - more specific increasing the upload limit. I have changed all required php.ini properties and phpinfo was showing proper results. However I was eternally stuck with 128 Mib on phpmyadmin import screen. I decided to use another unofficial image and I had no issues there.

russellmd
7 months ago

Hi,
Can someone confirm that adding custom configuration works? I tried to add a custom file as a volume, using docker-compose, but no changes are applied to PMA

volumes:

- ./docker-config/pma/config.user.inc.php:/config.user.inc.php

config.user.inc.php:
<?php

$cfg['ExecTimeLimit'] = 0;
$cfg['MaxNavigationItems'] = 999;
$cfg['MemoryLimit'] = '1280M';

?>

Thanks