How can I run the Local Docker image with my local host DB & without docker compose yml

Question

I have only the Docker image file. I don't have docker-compose.yml file. I want to test it my local database with the Docker image. I tried to run the docker image with localhost database. But not able to connect my xampp Mysql

docker run -d -t -i -e MYSQL_DATABASE='database' -e MYSQL_HOSTNAME='localhost' -e MYSQL_PORT='3306' -e MYSQL_USER='root' -e MYSQL_PASSWORD='example' -p 8081:80 <DOCKERIMGID>

I tried 192.168.0.1 & 127.0.0.1, localhost, host.docker.internal

But, it's not working.

score 0 · Answer 1 · answered Jan 21 '22 at 16:31

0

At a first glance. MYSQL_HOSTNAME should be "host.docker.internal" instead of "mysql".

You may also need to grant access to the database to 'root'@'%'.

answered Jan 21 '22 at 16:31

Sergiu Badan

11
1

I tried it with localhost, host.docker.internal & 127.0.0.1 But no luck – Thirsty Six Jan 21 '22 at 16:39
What is the exact error that you're getting? – Sergiu Badan Jan 21 '22 at 16:57
It's not connecting with my xampp local sever DB. it's still searching the DB. – Thirsty Six Jan 24 '22 at 06:13
Yes, i have removed all the Docker image & i tried to connect the DB using host.docker.internal . now it's working fine. – Thirsty Six Jan 24 '22 at 07:27

How can I run the Local Docker image with my local host DB & without docker compose yml

1 Answers1