nextcloud can't create an admin user

Question

error while trying to create the admin user:

Error while trying to create admin user: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [1045] Access denied for user 'nextcloud'@'172.22.0.6' (using password: YES)

docker-compose.yml

version: '3'

volumes:
  nextcloud-data:
  nextcloud-db:

networks:
  nginx_network:
    external: true

services:

  app:
    image: nextcloud
    restart: always
    volumes:
      - nextcloud-data:/var/www/html
    environment:
      - MYSQL_PASSWORD=test
      - MYSQL_DATABASE=nextcloud
      - MYSQL_USER=nextcloud
      - MYSQL_HOST=db
    networks:
      - nginx_network

  db:
    image: mariadb
    restart: always
    command: --transaction-isolation=READ-COMMITTED --binlog-format=ROW
    volumes:
      - nextcloud-db:/var/lib/mysql
    environment:
      - MYSQL_ROOT_PASSWORD=test
      - MYSQL_PASSWORD=test
      - MYSQL_DATABASE=nextcloud
      - MYSQL_USER=nextcloud
    networks:
      - nginx_network

I couldn't find any similar problems with a solution that works for me and the docker compose seems okay to me

Answer 1

I had the same error message at least up to SQLSTATE[HY000]. For me the solution was to put the IP-Adress listed for the maria-db container in the portainer.io GUI in the field host without a port. I also removed and added again the Nextcloud container and Maria-db stack (which automatically adds a container), but I do not think that that did the trick. I followed this guide.