How to connect MySQL WorkBench about homestead-docker HOT 9 CLOSED

Hi, sorry for not replying sooner,

This project already uses Mariadb as a separate container.

To connect to mariadb use docker IP or localhost ( ifconfig to get it, it's usually 172.17.0.1 ), the username, password and port are defined in docker-compose file.

from homestead-docker.

Hello shincoder.

I modify the file docker-compose.yml to use the tutum / mysql image, and enter into the container with the instruction:

-it homestead_mysql_1 docker exec mysql

I can manage the DBMS.

What I can not connect from the host using MySQL Workbench.

I used the IP address of the container and the localhost.

Thank you very much for your time greetings.

from homestead-docker.

Are you using docker-machine to manage docker in your Mac?

If so, you need to use docker machine ip: docker-machine ip

from homestead-docker.

Hello Jaouad.

Thanks for the support.

I commented, I am using Docker for Mac, which requires no longer use docker-machine.

https://docs.docker.com/docker-for-mac/

I'm pretty novice at Docker, initially was starting to study it in GNU / Linux and now I've changed to Mac I'm studying to start using it in my work.

I mention ...

In writing:

docker exec bash -it homestead_mysql_1

I can enter without problems

and writing

docker -it homestead_mysql_1 docker exec mysql

I can manage MySQL without problems from the inside.

Now, the problem is from the outside, I have added a user, I have given all privileges to it, I have configured MySQL for remote access, but still can not get that MySQL Workbench is still connected not I'm doing wrong.

Any recommendation is welcome and timely.

Greetings.

from homestead-docker.

Paste the output of docker ps .

from homestead-docker.

49b85de0e11c shincoder/homestead:php7.0 "/usr/bin/supervisord" 10 hours ago Up 11 hours 0.0.0.0:80->80/tcp, 0.0.0.0:9876->9876/tcp, 0.0.0.0:35729->35729/tcp, 0.0.0.0:2222->22/tcp homestead_web_1 c0ccaccc1cbd tutum/mysql "/run.sh" 10 hours ago Up 45 seconds 0.0.0.0:2223->22/tcp, 0.0.0.0:33060->3306/tcp homestead_mysql_1

from homestead-docker.

Did you instruct mysqlWorkbench to use port 33060 instead of the default 3306 ?

from homestead-docker.

if a direct connection is not working for you, try the ssh tunnel via port 2223, I see tutum/mysql exposing ssh port.

from homestead-docker.

Ok, thank you very much, I'll try and then comment the results.

Greetings.

from homestead-docker.