Local development with docker compose - Using Mysql localhost

Question

I am a beginner with Docker and docker-compose for local development on my Mac. Currently, if I restart my containers, the MySql data is wiped out.

I would like to enable persistent storage for MySql local development.

Is there a way I can connect my application running inside docker container to the MySql running on my Mac Host machine?

My docker-compose.yaml file:

   mysql:
        build: ./mysql
        container_name: mysql
        environment:
            MYSQL_ROOT_PASSWORD: ******
        restart: on-failure
        ports:
            - 3306:3306

Apart from connecting docker application to MySql on local machine, is there any other way to achieve this?

Read about docker volumes, or documentation for MySQL docker image. In fact, read both. — Cthulhu
– Cthulhu, Commented Nov 3, 2017 at 5:15

Pratheesh M · Accepted Answer · 2017-11-03 06:51:38Z

2

you can solve this problem by using volumes in docker-compose.yaml file. please refer the following links link1, link2. whenever a docker container runs, it will map the volume to the container. Syntax for the volumes in docker-compose.yaml is as follows:

volumes:
 - <path in host>:<path in container>

answered Nov 3, 2017 at 6:51

Pratheesh M

1,0788 silver badges13 bronze badges

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

4 Comments

Sid Over a year ago

What path does this refer to?

Pratheesh M Over a year ago

path in container means ..the path of data that you want to map to host path

Pratheesh M Over a year ago

simply copying data from container to host

Sid Over a year ago

That worked like a charm. Thanks. My next question is, how can I point my applications from within container to the MySql on my localhost?

Collectives™ on Stack Overflow

Local development with docker compose - Using Mysql localhost

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related