• Home
  • Get Noticed 2017
  • PHP
  • Quick Tips
  • Contact
  • About me

Bartosz Sosna Blog

Bartosz Sosna Blog

PHP BLOG

How to connect PHP container with MySql container
Docker, Get Noticed 2017, MySQL, PHP

How to connect PHP container with MySql container

How to connect PHP container with MySql container

In post "PHP development environment with Docker" I did show you how to create LAMP server using Docker. I use this solution for my project "Image optimizer API". I did not know how to connect PHP container with MySql container. I did see an error:

mysqli::__construct(): (HY000/2002): Connection refused in...

I did try to use 0.0.0.0 as host and that was a problem. I could connect with database using my mysql client Sequel Pro but PHP container did not see MySql container.

I did quick research and I did found a solution. I did use this command to find MySql container IP:

docker inspect CONTAINER-ID* | grep -i ipaddress

Results:

"SecondaryIPAddresses": null,
"IPAddress": "",
"IPAddress": "172.20.0.2";

I did change host to 172.20.0.2 and that solved the problem with connection.

I hope that helps you!

*To get container id you can use:

docker ps

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on Google+ (Opens in new window)

Related

Written by Bartosz Sosna in April 23, 2017 / 3826 Views
Tags | Docker, get notice 2017, mysql, php
AUTHOR
Bartosz Sosna

I'm Web and App developer. I love gadgets and new technologies. I'm also productivity freak.

You Might Also Like

Postman – powerful tool to work with API

May 7, 2017
Top 5 PhpStorm shortcuts

Top 5 PhpStorm useful shortcuts

April 9, 2017

How to convert cURL syntax to PHP, Node.js or Python

February 22, 2017

1 Comment

  • Rafael August 7, 2018 at 6:18 pm

    That was exactly what I needed.

    Thanks bro !

    Reply
  • Please Post Your Comments & Reviews
    Cancel reply

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Previous Post
    Next Post

    Serach

    Newsletter

    Latest Posts

    • API, Get Noticed 2017, PHP“Image Optimizer API” is ready“Get Notice 2017” contest is over My project “Image Optimizer…May 21, 2017
    • Get Noticed 2017, Quick Tips, zshZ shell (zsh) – better bashWhy zsh is better? I use console from years and…May 18, 2017
    • API, Get Noticed 2017, Quick TipsPostman – powerful tool to work with APIPostman – powerful tool to work with API I’m creating…May 7, 2017
    • Capistrano, Get Noticed 2017, PHP, Quick TipsHow to add tasks to capistranoHow to add tasks to Capistrano I wrote in post…May 5, 2017
    • Get Noticed 2017, MySQL, PHP, Quick TipsPhinx – PHP database migrationWhat is “database migration” I meet migrations first time in…April 30, 2017

    STAY UPDATED

    About Me

    About Me

    Web and App developer.

    I'm Web and App developer. I love gadgets and new technologies. I'm also productivity freak.

    About me (de)

    Latest Posts

    • API, Get Noticed 2017, PHP“Image Optimizer API” is ready“Get Notice 2017” contest is over My project “Image Optimizer…May 21, 2017
    • Get Noticed 2017, Quick Tips, zshZ shell (zsh) – better bashWhy zsh is better? I use console from years and…May 18, 2017
    • API, Get Noticed 2017, Quick TipsPostman – powerful tool to work with APIPostman – powerful tool to work with API I’m creating…May 7, 2017
    • Capistrano, Get Noticed 2017, PHP, Quick TipsHow to add tasks to capistranoHow to add tasks to Capistrano I wrote in post…May 5, 2017
    • Get Noticed 2017, MySQL, PHP, Quick TipsPhinx – PHP database migrationWhat is “database migration” I meet migrations first time in…April 30, 2017
    Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
    To find out more, including how to control cookies, see here: Cookie Policy

    FOLLOW ME ON TWITTER

    • W końcu MacBook Pro bez bezużytczego touch bara? https://t.co/5tweGBUxP28 days ago
    • Ostatnio dodałem wpis o tym jak zintegrować PhpStorm z WSL2 i Docker, a dzisiaj powstał nowy wpis jak taki zestaw z… https://t.co/fcbezzzy5L23 days ago
    Bartosz Sosna Blog

    Copyright © Bartosz Sosna