search

webdevops / php-docker-boilerplate

:stew: PHP Docker Boilerplate for Symfony, Wordpress, Joomla or any other PHP Project (NGINX, Apache HTTPd, PHP-FPM, MySQL, Solr, Elasticsearch, Redis, FTP)
https://webdevops.io/projects/php-docker-boilerplate/
MIT License
562 stars 186 forks source link

I can not connect to mysql with sequel pro #77

Closed mksglu closed 6 years ago

mksglu commented 6 years ago

Hey guys! What should I write to the login?

image image

htuscher commented 6 years ago

You are using the wrong hostname. Only between Containers the internal service names are used. Depending on your setup it's either localhost (docker on linux or docker for osx) or something.docker if you use docker-machine, Vagrant or Dinghy. Also our default Docker-compose.yml maps internal port 3306 to 13306 on the host.

Mert Köseoğlu notifications@github.com schrieb am So., 11. März 2018, 12:35:

Hey guys! What should I write to the login?

[image: image] https://user-images.githubusercontent.com/6067714/37252799-ff8f8a12-2538-11e8-9c11-cd5ad5e07a9e.png [image: image] https://user-images.githubusercontent.com/6067714/37252802-09de0cf0-2539-11e8-8e81-3573e3b57995.png

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/webdevops/php-docker-boilerplate/issues/77, or mute the thread https://github.com/notifications/unsubscribe-auth/AE11hB2LzP2aoC4JU_dkIo0JyVIH4QgMks5tdQwRgaJpZM4Slp9Q .

mksglu commented 6 years ago

Thank @hhoechtl image I have always used my MySQL knowledge in this way and successfully logged in. When I try with Sequel Pro, I get an error. What should I write to the hostname?

htuscher commented 6 years ago

As supposed you have port 13306 to connect to. By your Screenshot i can tell you are using osx but not how you use docker. So if you installed docker for osx the port 13306 is open on 127.0.0.1 otherwise (Vagrant, docker-machine) you must use the IP address of the virtual machine docker is running in (usually found by docker-machine ip) . The port if mapped is exposed to the host machine your docker daemon is running in.

Mert Köseoğlu notifications@github.com schrieb am So., 11. März 2018, 16:32:

Thank @hhoechtl https://github.com/hhoechtl [image: image] https://user-images.githubusercontent.com/6067714/37255214-498f31fa-255a-11e8-9263-8edb719295a1.png I have always used my MySQL knowledge in this way and successfully logged in. When I try with Sequel Pro, I get an error. What should I write to the hostname?

— You are receiving this because you were mentioned.

Reply to this email directly, view it on GitHub https://github.com/webdevops/php-docker-boilerplate/issues/77#issuecomment-372124061, or mute the thread https://github.com/notifications/unsubscribe-auth/AE11hJ0f-ovmtA6LPy6nAGWfYhIyt7L9ks5tdUN9gaJpZM4Slp9Q .

htuscher commented 6 years ago

Closed due to inactivity