Official phpMyAdmin Docker image
Run phpMyAdmin with Alpine, supervisor, nginx and PHP FPM.
All following examples will bring you phpMyAdmin on
where you can enjoy your happy MySQL administration.
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
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
edge- bleeding edge docker image (contains stable phpMyAdmin, but the Docker image changes might not yet be fully tested)
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
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
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:
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.
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_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
I cannot go trough PMA login
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.
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
$cfg['ExecTimeLimit'] = 0;
$cfg['MaxNavigationItems'] = 999;
$cfg['MemoryLimit'] = '1280M';
I want to store sessions on my volume. But I cant run docker container with phpmyadmin with sessions in my volume. Where you store sessions? I tried to take them from /var/ /var/lib/php /var/lib/php5 /tmp /etc and so on. But I cant find them on container. Where are they?
Solved. You need to put the internal IP of the docker and root user
Default username / password is what you set as MYSQL_USER and MYSQL_ROOT_PASSWORD
Seems an iptables issue; when I disable iptables, I can connect to 192.168.1.1;
...so what do I have to add to iptables?
It works great with a MySQL docker container.
However, I cannot get it to work with my local MySQL install (native, not docker). This is a first step I want to take before migrating also the my MySQL to docker...
The configuration I use:
$ docker run --detach --name test-phpmyadmin -e PMA_HOST=192.168.1.1 -d phpmyadmin/phpmyadmin:latest
I get either a "cannot connect MySQL server error"(127.0.0.1) or a time out (192.168.1.1).
$ mysql --host=192.168.1.1 (or 127.0.0.1) does work.
What am I doing wrong here?
Great small alpine image! Thanks!