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;