Use PHPMyAdmin with Docker to connect to MySQL
Posted by James Kruss on 21 September 2021 09:57 am
Running PHPMyAdmin locally to connect to a remote MySQL instance is made fast and easy with Docker.
Download Docker. This can be installed on Windows.
Open a cmd prompt and enter the following
docker pull phpmyadmin
This will install the PHPMyAdmin docker image
In the command prompt enter the following, changing IP with the IP of the MySQL server (this will work for MySQL hosted on AWS amongst others).
docker run --name myadmin -d -e PMA_HOST=IP -p 8080:80 phpmyadmin
Now access PHPMyAdmin in a web browser at http://localhost:8080/
Full documentation on docker commands for PHPMyAdmin is at: https://hub.docker.com/_/phpmyadmin