Docker: container with mysql, do you really need to manually expose the host to the user?

Question

PHP

Contents of docker-compose (for mysql):

mysql:
    image: mysql:8.0.4
    container_name: mysql
    restart: on-failure
    ports:
      - '3306:3306'
    environment:
      MYSQL_ROOT_PASSWORD: ${MYSQL_ROOT_PASSWORD}
      MYSQL_DATABASE: ${MYSQL_DATABASE}
      MYSQL_USER: ${MYSQL_USER}
      MYSQL_PASSWORD: ${MYSQL_PASSWORD}

After starting the container, the user MYSQL_USER is created, whose host=localhost is set.

Because of this, from another container, on the same network, for example, from php, you cannot reach mysql, because rights are missing. and you have to manually set the host
UPDATE user SET host='%' where user='my_user';

Is everyone facing this problem?
if so, how do they decide? And if not, why do I have such a problem?

Answer 1

I remember that I didn’t have such a problem, did you accurately configure the internal network?) There you need to create an internal network and specify it in the containers
my example

Answer 2

Official README - read Initializing a fresh instance .

Answer 3

if so, how do they decide?

They create their own Dockerfile, in which they do all the necessary manipulations with the config.
PS: and don't deploy the database into containers