Connect laravel container to existing mysql container via docker compose

Question

I am new to docker, I am trying to connect the existing MySQL container to my Laravel application through docker-compose.

Where MySQL docker-compose.yml file is like

version: '3'

services:
  web:
    container_name: ${APP_NAME}_web
    build:
     context: ./docker/web
    ports:
      - "9000:80"
    volumes:
      - ./:/var/www/app
    depends_on:
      - db
  db:
    container_name: ${APP_NAME}_db
    image: mysql:5.7
    ports:
      - "3307:3306"
    restart: always
    volumes: 
      - dbdata:/var/lib/mysql/
    environment:
      - MYSQL_ROOT_PASSWORD=root
      - MYSQL_DATABASE=laravel_docker_db
volumes:
  dbdata:
    driver: local
    driver_opts:
       type: none
       device: /storage/docker/laravel_mysql_data
       o: bind

This script is downloading the latest mysql version and making a new container. I just want to connect MYSQL container with my application

Where my existing MYSQL container is created with a specific IP using a bridge network and running on docker-machine.

I am wondering, can I define the existing MYSQL container configurations on the db context?

What's the specific problem you're encountering? Have you read through Networking in Compose in the Docker documentation? — David Maze
– David Maze, Commented Nov 5, 2019 at 10:59

Vasyl Zhuryk · Accepted Answer · 2019-11-05 08:14:17Z

3

Try this docker-compose file:

version: '3.5'
services:
  db:
    container_name: myapp_db
    image: mysql:5.7
    ports:
      - "3307:3306"
    restart: always
    volumes:
      - dbdata:/var/lib/mysql/
    environment:
      - MYSQL_ROOT_PASSWORD=root
      - MYSQL_DATABASE=laravel_docker_db
    networks:
      - myapp-network

networks:
  myapp-network:
    driver: bridge

Situation has two cases: 1. If your laravel instance is in docker too - just add to .env file next rows:

DB_HOST=myapp_db
DB_PORT=3306
DB_DATABASE=laravel_docker_db
DB_USERNAME=root
DB_PASSWORD=root

2.If you don't use docker for laravel - just change variable DB_HOST=localhost

edited Nov 5, 2019 at 8:14

answered Nov 5, 2019 at 7:50

Vasyl Zhuryk

1,25810 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Muhammad Sipra Over a year ago

the issue is still the same, I have the case 1: I am using laravel on docker. and the script created 2 containers 1st for laravel 2nd for mysql

Vasyl Zhuryk Over a year ago

Have you added networks: - myapp-network to your laravel container? docker connects containers in one network, and inside container you can call other container by name

Vasyl Zhuryk Over a year ago

also, if you use 1 option - change DB_PORT=3306

Muhammad Sipra Over a year ago

Yes , as per your answer i haeve added the networks in db context as well as I have also defined networks: myapp-network: driver: bridge in it.

Muhammad Sipra Over a year ago

I think, if I have an MYSQL docker container that is already running on docker-machine, I just need to add the configuration in my laravel .env file. and remove MYSQL configs from the docker-compose.yml file. What do say?

|

Dmitry Leiko · Accepted Answer · 2019-11-06 08:22:00Z

1

In .env file:

DB_HOST=db
DB_PORT=3306
DB_DATABASE=your database name
DB_USERNAME=root
DB_PASSWORD=root

edited Nov 6, 2019 at 8:22

answered Nov 5, 2019 at 8:07

Dmitry Leiko

4,5023 gold badges29 silver badges48 bronze badges

1 Comment

nmfzone Over a year ago

3007 is the published port. Since you're using db as host, then port should be 3006.

Collectives™ on Stack Overflow

Connect laravel container to existing mysql container via docker compose

2 Answers 2

8 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related