Some months ago I needed to restore a sensitive database to run some import scripts. The backup was a Mysql database. So the idea was to spin a local Mysql instance and install a GUI to navigate through the data.
That annoyed me a bit, because it was a one-time job and then I will have my machine dirty. So I thought Docker could have been a good fit.
I followed the great post wrote by Luiz Felipe F M Costa “How to install MySQL and phpMyAdmin with Docker” to get up and running the basic idea.
His solution was great and worked fine, but it required multiple docker run commands and to create a network, which I found difficult to script.
So I found that was the right job for docker compose, that allows to create multi-container app.
Now I can commit the .yml file in GIT, and everyone can replicate my setup.
So my final solution is this docker-compose.yml file. Run it using docker-compose up -d and stop it using docker-compose down.
Some notes:
- Navigate to http://localhost:8080/ to access the phpMyAdmin web interface. The default user is “root” and use the password specified in MYSQL_ROOT_PASSWORD.
- I used Docker Desktop on Windows, WSL2 and Linux containers
- Change the password as fit best to you. A improved step could be to use an environment file and remove it from the .yml file. In my specific case this was not a security problem.
- The subfolder /data/ is required, and the database data will be mounted/bound here. This means also that you can start/shutdown the server without losing your data.
- I increased the UPLOAD_LIMIT so you can restore also big backup files (up to 2GB)
Leave a comment if you found it useful, or just to share your thoughts!
version: "3.8"
services:
mysql:
image: mysql:8.0.12
container_name: w3snet-mysql
command: --default-authentication-plugin=mysql_native_password
environment:
- MYSQL_ROOT_PASSWORD=yourpassword
networks:
- w3snet
volumes:
- type: bind
source: ./data
target: /var/lib/mysql
ports:
- target: 3306
published: 3306
# PMA_HOST is the IP or domain of the MySQL server, so we can use the MySQL container name as the domain
# because the Docker network create the route as a DNS server.
# more info on -e environment variables: https://github.com/phpmyadmin/docker#environment-variables-summary
phpmyadmin:
image: phpmyadmin/phpmyadmin
container_name: w3snet-phpmyadmin
networks:
- w3snet
environment:
- PMA_HOST=w3snet-mysql
- UPLOAD_LIMIT=2048M
ports:
- target: 80
published: 8080
networks:
w3snet:
