Deploying phpMyAdmin with Docker to manage MySQL Databases

Managing a database can be a complex and laborious part when running a web application. Softwares like phpMyAdmin exist to make the process much lighter. It is a popular administration tool that allows you to access and manage your databases much more easily.

In this tutorial you learn how to deploy the tool on a Virtual Instance using the Docker InstantApp.

Creating a Docker Instance

1. Click Instances in the Compute section of the side menu. The Instances overview displays.

2. Click + Create an Instance. The instance creation wizzard displays.

3. Configure your Instance:

   • Choose the availability zone.
   • Select the Instance type (in this tutorial we use a DEV1-S Instance)
   • Select the Image for the Instance: Click the InstantApps tab and select the Docker image.
   • If required, configure storage options
   • Enter a name for the instance and optionally tags for it

4. Click Create a new Instance to launch its creation. Once the instance is ready, you are redirected to it’s information page.

Deploying phpMyAdmin

1. Connect to your instance using SSH:

   ssh root@<your_instance_ip>
   Copy code

2. Download the official Docker image by running the following command:

   docker pull phpmyadmin
   Copy code

3. Run the container with the following command:

   docker run --name phpmyadmin -d -e PMA_HOST=$DB_HOST -e PMA_PORT=$DB_PORT -p 8080:80 phpmyadmin
   Copy code

   • Replace $DB_HOST with the hostname or IP of your MySQL server.
   • Replace $DB_PORT with the port your MySQL server is listening on.
   Tip:

   If you are using a Managed Database for MySQL you can find the connection details on the Database information page:

   

4. Open a web browser tab and go to http://<your_instance_ip>:8080. The phpMyAdmin login displays:

   

5. Enter your MySQL credentials and click Go. The phpMyAdmin Dashboard displays:

   

You can now manage your MySQL databases using the graphical interface of phpMyAdmin.

docker stop phpmyadmin
Copy code