Changing database port does not work

[flip111]

I changed these lines

PMA_PORT: 3307

and

      - ${IP}:3307:3307 # change ip if required

in docker-compose.yml. Then i run docker-compose up

Then when i run sudo netstat -tulpn | rg 3306 i get

tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN      7992/docker-proxy

When CTRL + C in docker compose terminal, and i do netstat again i see that port 3306 is no longer in use.

[nezhar]

The database container will always run on 3306 in the internal network. The mapping is only required if you want to access the container from outside the network with an additional database tool (such as DataGrip, HeidiSQL...).

In other words the PMA_PORT should remain configured to 3306.

You can change although the ports in the db service. Changing it to ${IP}:3307:3306 will allow you to access the database remotely on port IP:3307

[flip111]

The problem is that when you boot this container you get a port conflict on your local machine when it also has mysql/mariadb

The database container will always run on 3306 in the internal network.

Why is this the case? Surely it must be configurable somewhere?