Official phpMyAdmin Docker image
Run phpMyAdmin with Alpine and PHP built in web server.
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 theroot
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.
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
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:/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:/config.user.inc.php phpmyadmin/phpmyadmin
See the following links for config file information. http://docs.phpmyadmin.net/en/latest/config.html#config http://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 allowedPMA_HOST
- define address/host name of the MySQL serverPMA_PORT
- define port of the MySQL serverPMA_HOSTS
- define comma separated list of address/host names of the MySQL serversPMA_USER
andPMA_PASSWORD
- define username to use for config authentication methodPMA_ABSOLUTE_URI
- define user-facing URIPHP_UPLOAD_MAX_FILESIZE
- define upload_max_filesize and post_max_size PHP settingsPHP_MAX_INPUT_VARS
- define max_input_vars PHP setting
For more detailed documentation see https://docs.phpmyadmin.net/en/latest/setup.html#installing-using-docker