Home / Questions / 360640
Accepted
Diego Ulloa
Asked: 2020-05-30 16:13:33 +0800 CST 2020-05-30 16:13:33 +0800 CST

Laravel 7 Connection refused: You're using the default database name homestead. This database does not exist

  • 772

enter image description here

When logging the user I am having this problem with Laravel 7. All the data in my database seems to be correct. I use port 3307 and I am using Docker for the project.

My .env are:

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3307
DB_DATABASE=homestead
DB_USERNAME=homestead
DB_PASSWORD=secret

For the mysql service in docker I use:

version: '3'


networks:
  laravel:


services:
  nginx:
    image: nginx:stable-alpine
    container_name: e-learning-app_nginx
    ports:
      - "8087:80"
    volumes:
      - ./src:/var/www/html
      - ./nginx/default.conf:/etc/nginx/conf.d/default.conf
    depends_on:
      - php
      - mysql
    networks:
      - laravel


  mysql:
    image: mysql:5.7
    container_name: e-learning-app_mysql
    restart: always
    tty: true
    ports:
      - "3307:3306"
    environment:
      MYSQL_DATABASE: homestead
      MYSQL_USER: homestead
      MYSQL_PASSWORD: secret
      MYSQL_ROOT_PASSWORD: secret
      SERVICE_TAGS: dev
      SERVICE_NAME: mysql
    networks:
      - laravel
    volumes:
      - ./mysql:/var/lib/mysql


  php:
    build:
      context: .
      dockerfile: Dockerfile
    container_name: e-learning-app_php
    volumes:
      - ./src:/var/www/html
    ports:
      - "9007:9000"
    networks:
      - laravel

Edit: I put the docker-compose.ymlcomplete.

I do not know what is the problem. The strange thing is that the migrations run fine for me and from client to db I can connect everything fine. I already tried clearing cache of routes and configurations... I'm using auth.

php

4 Answers

  1. In my local environment I also use Docker Compose for projects with Laravel. Try using the container name as DB_HOST. For more information, you can consult the documentation on this here .

    DB_HOST=mysql

    • 1

  2. If your MySQL database is called homestead you should not have a problem, if it has another name you must change it in the configuration to the database in the .env file

    The error is because the database with the name "homestead" does not exist.

    • 0

  3. Solution 1:

    Hello, try changing your file .envso that instead of 127.0.0.1connect with localhostas follows:

    DB_HOST=localhost
DB_PORT=3307

    Then from the container execute:

    php artisan migrate

    Solution 2:

    If that didn't work then modify your file config/database.phpand add

    'mysql' => [
...
    'port' => env('DB_PORT', 3307),
    'database'  => env('DB_DATABASE', 'homestead'),
...
],

    Then from the container execute:

    php artisan migrate

    This answer was given on Stackoverflow in English and I have tried to adapt it for your case.

    • 0
  4. Best Answer

    SOLVED! although I don't know if in the most " correct " way.

    I detail the steps that led me to the solution:

    1. get the gateway IP with docker inspect container_id(at the end of the json)
    2. add in .envthat IP as host instead of 127.0.0.1 or localhost DB_HOST=172.18.0.1
    3. add my docker-compose.ymlservice for artisan
    4. do docker-compose downand then docker-compose up(maybe it's better to delete the containers and volumes to start clean)

    Artisan service added in docker-compose.yml :

      artisan:
    build:
      context: .
      dockerfile: Dockerfile
    container_name: e-learning-app_artisan
    volumes:
      - ./src:/var/www/html
    depends_on:
      - mysql
    working_dir: /var/www/html
    entrypoint: ['php', '/var/www/html/artisan']
    networks:
      - laravel

    My Dockerfile :

    FROM php:7.4-fpm-alpine

WORKDIR /var/www/html

RUN docker-php-ext-install pdo pdo_mysql

    Then the logging issue was fixed and I was able to perform the migrations and seeds using artisan from the container:

    docker-compose run --rm artisan migrate --seed

    To connect from an external client like TablePlus I make the connection with the data:

    host: 127.0.0.1
port: 3307

database: homestead
username: homestead
password: secret

    To access the app I still use http://127.0.0.1:8087or http://localhost:8087.

    Everything working fine.

    The docker that I am using to mount the project can be found at https://github.com/diegoulloao/laravel-docker-startpoint

    • -1