MySQL + phpMyAdmin Docker Compose

Here is a simple docker-compose file to run MySQL + phpMyAdmin services for your development needs.

Create a file docker-compose.yml.

Copy and paste the below code.

Run it using the command docker-compose up.

version: "3"

services:
  # Database
  db:
    platform: linux/x86_64
    image: mysql:5.7
    volumes:
      - db_data:/var/lib/mysql
    restart: always
    ports:
      - "3306:3306"
    environment:
      MYSQL_ROOT_PASSWORD: password
      MYSQL_DATABASE: yourdb
      MYSQL_PASSWORD: password
    networks:
      - mysql-phpmyadmin

  # phpmyadmin
  phpmyadmin:
    depends_on:
      - db
    image: phpmyadmin
    restart: always
    ports:
      - "8090:80"
    environment:
      PMA_HOST: db
      MYSQL_ROOT_PASSWORD: password
    networks:
      - mysql-phpmyadmin

networks:
  mysql-phpmyadmin:

volumes:
  db_data:

You can access the phpMyAdmin at http://localhost:8090/

Comments

[CharlesDerek]

Returns:
mysqli::real_connect(): (HY000/1045): Access denied for user 'root'@'{LocalHostIpAddress}' (using password: YES)

Same thing happens with any other user made.