Deploying phpMyAdmin with Docker to manage MySQL Databases

Managing a database can be a complex and laborious part when running a web application. Software 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 an Instance using the Docker InstantApp.

Before you start

To complete the actions presented below, you must have:

• A Scaleway account logged into the console
• Owner status or IAM permissions allowing you to perform actions in the intended Organization
• An SSH key
• A MySQL database

Creating a Docker Instance

1. Click Instances in the Compute section of the side menu. The Instances page displays.
2. Click Create Instance. The Instance creation wizard displays.
3. Configure your Instance:
   • Choose the Availability Zone.
   • Select the Instance type (in this tutorial we use a PLAY2-NANO 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 Instance to launch its creation. Once the Instance is ready, you are redirected to its information page.

Deploying phpMyAdmin

1. Connect to your Instance using SSH:

   ssh root@<your_instance_ip>

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

   docker pull phpmyadmin

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

   • 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 Database for MySQL you can find the connection details on the Database information page:

   Open Image over content

   Close current Lightbox

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

   Open Image over content
   Close current Lightbox

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

   Open Image over content
   Close current Lightbox

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

docker stop phpmyadmin