PHPMyAdmin (MySQL Client)

Introduction

PHPMyAdmin is a web-based MySQL client that allows you to manage MySQL databases.

Run Using Containers

Container Introduction

In this example we'll use Docker containers to run a containerized version of PHPMyAdmin. Parts of this guide were taken from Dr. Yuste's How-to on Medium. A lot of this guide can easily be adapted for podman.

Pull the Docker Image

docker pull phpmyadmin/phpmyadmin:latest

Run the Docker Container

docker run \
    --name phpmyadmin \
    --network network_name \
    -p 8888:80 \
    -d phpmyadmin/phpmyadmin

This sets up a container named phpmyadmin on the network_name network, and maps port 8888 on the host to port 80 on the container. It's also possible to use Docker network links to connect the container to a MySQL container.

docker run \
    --name phpmyadmin \
    --link mysql_container_name:db \
    -p 8888:80 \
    -d phpmyadmin/phpmyadmin

Alternative Docker Run (No Network Link)

This procedure is taken from Maxim Orlov's dev.to post. First create a MySQL container of name mysql, root password root and detach it.

# MySQL Container
docker run \
    --name mysql \
    --env MYSQL_ROOT_PASSWORD=root \
    --detach \
    mysql:latest

Then create a PHPMyAdmin container, we'll explain the parameters afterwards.

# Start PHPMyAdmin Container
docker run \
    --name phpmyadmin \
    --publish 8888:80 \
    --network some-net \
    --env PMA_HOST=mysql \
    --env PMA_PORT=3306 \
    --env PMA_USER=root \
    --env PMA_PASSWORD=root \
    --detach \
    phpmyadmin/phpmyadmin:latest

--name phpmyadmin - Name of the container
--publish 8888:80 - Map port 8888 on the host to port 80 on the container
--network some-net - Connect the container to the some-net network
- This is very important when not linking the container to a MySQL container
- An alternative to this would be to pass localhost, we'll cover that with PMA_HOST
--env PMA_HOST=mysql - Connect to the MySQL container named mysql
- This is the hostname of the MySQL server
- mysql as a hostname assumes a networked container named mysql
- Without a networked container, you'd need to pass in localhost here
--env PMA_PORT=3306 - The port of the MySQL server
--env PMA_USER=root - The username of the MySQL server
--env PMA_PASSWORD=root - The password of the MySQL server
--detach - Detach the container from the terminal
phpmyadmin/phpmyadmin:latest - The image to use for the container

Access the Container

Once the container is running, you can access it by navigating to http://localhost:8888 in your browser.