Learn to install phpmyadmin with Docker in one minute (share)

This article gives you a minute to learn how to install phpmyadmin with Docker (share). It has certain reference value. Friends in need can refer to it. I hope it will be helpful to everyone.

Our MySQL database on the cloud server is very unsafe when the port is exposed and the remote connection is opened. Yes, one of my servers was attacked by a ransomware virus yesterday, and I was asked to pay 0.06 Bitcoin to redeem my data. Fortunately, there was no important data in that database. It was just a database that had been abandoned for half a year. I had forgotten the password. Fortunately, I found the password through some means. After I logged in, I was dumbfounded. So what should we do if we don’t want to enable remote login but still want to operate the database? what to do? It can be solved with phpmyadmin, but phpmyadmin also has certain risks. Let's see how to play it below.

Use Docker to publish phpmyadmin and connect to the existing MySQL container

1. First download the docker image of phpmyadmin

   # 先查询镜像仓库里有哪些镜像
   docker search phpmyadmin
   
   # 拉取star最多的镜像or拉取你想用的镜像
   docker pull docker.io/phpmyadmin/phpmyadmin
   
   拉取镜像需要一段时间，这个要看服务器的带宽网速了

2. Start the image and connect to the existing MySQL container

   # 启动镜像
   docker run --name myadmin -p 80:80 -d --link mysql-db:db docker.io/phpmyadmin/phpmyadmin
   
   # 修改容器配置文件
   ## 将配置文件复制到宿主机中
   docker cp myadmin:/etc/phpmyadmin/config.inc.php .
   
   ## 修改配置文件信息(这里修改的db就是在启动的时候--link后面指定的别名)
   $cfg['Servers'][$i]['host'] = 'localhost' ——> $cfg['Servers'][$i]['host'] = 'db'
   
   ## 将修改后的配置文件复制回容器中
   docker cp ./config.inc.php myadmin:/etc/phpmyadmin/
   
   # 重启phpmyadmin容器

3. You can connect here. Of course, you can also modify the configuration file to limit the connected users, and then in MySQL Authorize the connection user

Use docker-compose to create

1. Install docker-compose, I won’t go into details here,

2. Write the docker-compose.yml file

   version: "2"
   services:
     mysql:
       image: hub.c.163.com/library/mysql
       container_name: test-mysql
       restart: always
       ports:
         - "3306:3306"
       environment:
         MYSQL_USER: "root"
         MYSQL_PASSWORD: "root"
         MYSQL_ROOT_PASSWORD: "root"
       networks:
         - net-mysql
   
     phpmyadmin:
       image: docker.io/phpmyadmin/phpmyadmin
       container_name: test-myadmin
       ports:
         - "80:80"
       environment:
         MYSQL_USER: "root"
         MYSQL_PASSWORD: "root"
         MYSQL_ROOT_PASSWORD: "root"
       networks:
         - net-mysql
   
   networks:
     net-mysql:

3. Publish the container

   # 使用命令发布容器
   docker-compose up -d

4. Then you can use it without modification. Any configuration file

Recommended learning: "PHP Video Tutorial"

The above is the detailed content of Learn to install phpmyadmin with Docker in one minute (share). For more information, please follow other related articles on the PHP Chinese website!