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

user_9929583 0
Viewed 11728

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.

laravel-8 laravel mysql php
4 Answers

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"

user_126594580

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.

user_18380980

in this case need check the .env file and update DB_HOST=mysql to DB_HOST=localhost I got the same issue after install the laravel.

user_131781200

I had the same problem I installed two php environments first that of the xamp and the second that of the computer go to computer location. "C:\Program Files\php-8.0.3" open file "php.ini" and add without ;

extension=php_pdo_mysql
extension=php_pdo_mysql.so

And the second click on the xamp configuration button to change the configuration and add this two line in the file php.ini

extension=php_pdo_mysql
extension=php_pdo_mysql.so

Warning without the semicolon, do not add semicolon ;

user_155213330
Related