Can't run migrations in Laravel 8: SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known [closed]

Question

I don't get why my migrations are failing on a clean install of Laravel 8. This is what am getting:

 Illuminate\Database\QueryException 

  SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known (SQL: select * from information_schema.tables where table_schema = bunny and table_name = migrations and table_type = 'BASE TABLE')

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:678
    674▕         // If an exception occurs when attempting to run a query, we'll format the error
    675▕         // message to include the bindings with SQL, which will make this exception a
    676▕         // lot more helpful to the developer instead of just the database's errors.
    677▕         catch (Exception $e) {
  ➜ 678▕             throw new QueryException(
    679▕                 $query, $this->prepareBindings($bindings), $e
    680▕             );
    681▕         }
    682▕ 

      +33 vendor frames 
  34  artisan:37
      Illuminate\Foundation\Console\Kernel::handle()

I am using Kali linux with a perfect Laravel environment, but version 8 just won't work.

Answer 1

just in .env file change the value of DB_HOST to 127.0.0.1

"change DB_HOST=mysql to DB_HOST=127.0.0.1"

Answer 2

Changing the value of DB_HOST to 127.0.0.1 within the .env file did not solve my problem completely, I also had to rebuild the whole docker/sail with:

sail down -v

and

sail build --no-cache

and first then after running

sail up -d

I could run:

./artisan migrate:fresh

Rebuilding is required when there was changes to the database credentials.