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

[QBANIN]

GLPI deployed with docker- compose. When i try to set mysql server I get this error

What am I doing wrong?

[DiouxX]

What is your docker-compose file ? The mysql server is also on docker ?

If yes, the mysql server deployed with docker on the same docker-compose or a different docker deployment ?

[QBANIN]

mysql.env

MYSQL_ROOT_PASSWORD=diouxx
MYSQL_DATABASE=glpidb
MYSQL_USER=glpi_user
MYSQL_PASSWORD=glpi

docker-compose.yml

version: "3.2"

services:
#Mysql Container
  mysql:
    image: mysql:5.7.23
    container_name: mysql
    hostname: mysql
    volumes:
      - /var/lib/mysql:/var/lib/mysql
    env_file:
      - ./mysql.env
    restart: always

#GLPI Container
  glpi:
    image: diouxx/glpi
    container_name : glpi
    hostname: glpi
    ports:
      - "7780:80"
    volumes:
      - /etc/timezone:/etc/timezone:ro
      - /etc/localtime:/etc/localtime:ro
      - /var/www/html/glpi/:/var/www/html/glpi
    environment:
      - TIMEZONE=Europe/Brussels
    restart: always

The only change I made is exposed port number

[DiouxX]

I have tested now and I don't have the databse initialization problem.

Are you sure that the /var/lib/mysql folder is empty ? Is there not data from a previous install ?

Have you tested with another database mapping folder ?

[QBANIN]

Facepalm You're right, /var/lib/mysql was already in use by another mariadb container :)

Everything works fine now. Thanks.

[DiouxX]

I'm glad I could help you :)