Setting the tunnel listener to listen on 0.0.0.0:3306 will solve this problem but also will allow others on the network to connect to the forwarded database. I bash into the phpmyadmin container like this: (I'm on windows) winpty docker exec -it pmacontainername sh And then I got in by default in /var/www/html and I see all the phpmyadmin files there. The 127.0.0.1:3306 setting binds to the host's localhost interface, but at least on native Linux the request will actually arrive from the docker0 interface. 1 I can't seem to find the real installation path of my phpmyadmin. You might need to change the settings of the ssh tunnel listener for this to work. For this you don't need any special networks: or network_mode: option at all.
#DOCKER PHPMYADMIN ACCESS TO MYSQL HOST WINDOWS#
In particular, if you're on a MacOS or Windows host, host networking just doesn't work (you connect to the "host network" of a hidden Linux VM) and you'll need to use the special host name instead of localhost. You may be able to use a different approach to connect to the ssh tunnel also see From inside of a Docker container, how do I connect to the localhost of the machine?.
#DOCKER PHPMYADMIN ACCESS TO MYSQL HOST CODE#
The configuration you have creates a Compose network that happens to be named host, but it's not "the host network". 2 days ago &0183 &32 Use mysql://db:3306 as host in my dart code Log into my mysql container from my local machine (works perfectly, so the issue is the connection between dart server and mysql server) I tried a lot of things I dont recall, as I spent 2 days tweaking around to make this work.
You need to change your service configuration to say services: Which means mysql user in not allowed to access from given ip address (in this case my public ip) and i guess that's because docker container is not using ssh tunneling from my local machine even if i'm using host network (which again i'm not sure what it actually does).Īnyone got any ideas what i'm doing wrong? Answers $cfg = 24*60*60*30 Īfter i choose remote-server-name in server choice i get the following message mysqli::real_connect(): (HY000/2002): Connection refused Server choice configuration for PhpMyAdmin () $cfg = 'remote-server-name'
Since i'm using host network, docker container should be aware of local port forwarding (not really sure about this tho, but i couldn't find much information online on how host network actually works).Īfter i do ssh to remote server there should be a tunnel on my local machine on port 3306 that is pointing to 3306 on remote server. MySQL Host, Name of your Docker Container, can be found with warden env ps. usr/local/etc/php/php.ini:/php-make/upload.ini
On remote server i'm using mysql user who can only access from localhost which is why i need ssh tunneling. I am running PhpMyAdmin using Docker on my local machine with docker-compose.
0 kommentar(er)
