php artisan migrate not working Laravel 8 [duplicate]

Question

Everything was fine until I changed my computer. I'm trying to migrate my database with php artisan migrate but I get this error

  SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = grain and table_name = migrations and table_type = 'BASE TABLE')

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:712
    708▕         // If an exception occurs when attempting to run a query, we'll format the error
    709▕         // message to include the bindings with SQL, which will make this exception a
    710▕         // lot more helpful to the developer instead of just the database's errors.
    711▕         catch (Exception $e) {
  ➜ 712▕             throw new QueryException(
    713▕                 $query, $this->prepareBindings($bindings), $e
    714▕             );
    715▕         }
    716▕     }

      +33 vendor frames 
  34  artisan:35
      Illuminate\Foundation\Console\Kernel::handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))

Any attempt to interact with the database gives me the same error

this is my .env configuration

    DB_CONNECTION=mysql
    DB_HOST=127.0.0.1
    DB_PORT=3306
    DB_DATABASE=grain
    DB_USERNAME=root
    DB_PASSWORD=

Do you have mysql set up on this new computer? I.e. can you do mysql -u root in your Terminal/Command Line? Have you run all the appropriate steps, like composer install, etc.? This seems like an issue with your new computer not being configured properly, so you'll have to do some digging to find the exact cause. — Tim Lewis
– Tim Lewis, Commented Jan 3, 2023 at 17:48
Regarding "Any attempt to interact with the database gives me the same error": check the connection to your DB via the terminal. Please specify how your database works. Are you using a docker container, a local installation, or something else? — slaff.bg
– slaff.bg, Commented Jan 3, 2023 at 17:50
Also, remember that before you can perform the migrations themselves, you must have the DB schema itself created. — slaff.bg
– slaff.bg, Commented Jan 3, 2023 at 17:57
@slaff.bg yeah but that will trigger another error "SQLSTATE[HY000] [1049] Unknown database" — N69S
– N69S, Commented Jan 3, 2023 at 17:58
@TimLewis You are right, the problem actually came from the fact that I changed pc. On the old I was using MAMP and the new XAMPP. — Tinho
– Tinho, Commented Jan 3, 2023 at 18:19

Tinho · Accepted Answer · 2023-01-03 18:29:24Z

0

The problem was because on my old pc I was using MAMP and now I'm using XAMPP so in the database.php file the unix_socket path was wrong.

So go to your my.cnf file and search the socket path then make sur that the socket path is the same as the unix_socket path in your database.php file

answered Jan 3, 2023 at 18:29

Tinho

294 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

php artisan migrate not working Laravel 8 [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related