Host '172.19.0.3' is not allowed to connect to this MySQL server

Viewed 38

I have a docker-compose application with 2 containers: for mysql database and spring-boot application. When I run docker-compose up database container sets up normally but then when another container tries to start it crashes with this error. I don't understand a lot in this, I tried everything I found. I didn't see topics where mysql was run in container.

docker-compose.yml

version: "3"
services:
  server:
    build: .
    ports:
      - "8080:8080"
    restart: always
    environment:
      - spring.datasource.url=jdbc:mysql://mysqld:3306/filesdb?useSSL=false
    depends_on:
      - mysqldb

  mysqldb:
    image: mysql:5.7
    ports:
      - "3306:3306"
    restart: always
    command: --init-file /.docker/init.sql
    environment:
      - MYSQL_ROOT_HOST='%'
      - MYSQL_USER='root'
      - MYSQL_PASSWORD='root'
      - MYSQL_DATABASE='filesdb'
    volumes:
      - ./init.sql:/.docker/init.sql
      - db_data:/var/lib/mysql

volumes:
  db_data:
    driver: local

init.sql

CREATE DATABASE IF NOT EXISTS filesdb;
CREATE USER 'root'@'172.19.0.3' IDENTIFIED BY 'root';
GRANT ALL PRIVILEGES on *.* TO 'root'@'172.19.0.3' WITH GRANT OPTION;
FLUSH PRIVILEGES;
0 Answers
Related