I have a docker container with PHP. I can connect from PHP to my local MySQL-container with PDO:

$db = new PDO("mysql:host=mysql-docker;port=3306", "user", "pass");

I also have a remote MySQL server, which is accesible on my host machine through ssh-tunnel. From command line on my host (local) machine I can connect to it this way:

mysql -h 127.0.0.2 -P 13306 -u user -p

But when I try to connect from PDO on PHP-docker, I receive error "SQLSTATE[HY000] [2002] Connection refused"

$db = new PDO("mysql:host=127.0.0.2;port=13306", "user", "pass");

How to make it to connect?

I have a docker container with PHP. I can connect from PHP to my local MySQL-container with PDO:

$db = new PDO("mysql:host=mysql-docker;port=3306", "user", "pass");

I also have a remote MySQL server, which is accesible on my host machine through ssh-tunnel. From command line on my host (local) machine I can connect to it this way:

mysql -h 127.0.0.2 -P 13306 -u user -p

But when I try to connect from PDO on PHP-docker, I receive error "SQLSTATE[HY000] [2002] Connection refused"

$db = new PDO("mysql:host=127.0.0.2;port=13306", "user", "pass");

How to make it to connect?

• docker
• localhost
• ssh-tunnel

1 Answer 1

Ok, finally I have found a solution.

Actually, I can choose any ip address to end up my tunnel. So, instead of 127.0.0.2 I need to end up this tunnel on address 172.17.0.1 - this address is output of this command:

ip addr show docker0

After that I can simply connect from my PHP-container:

 $db = new PDO("mysql:host=172.17.0.1;port=13306", "user", "pass");