How to fix " php artisan migrate" error in Laravel

Question

I'm setting up my project after restoring my macOS Mojave and getting an error. I install MySQL with homebrew.

I tried to change localhost to 127.0.0.1 but it didn't help me

This is my .env

DB_CONNECTION = mysql,
DB_HOST = localhost
DB_PORT = 3306
DB_DATABASE= example
DB_USERNAME=root
DB_PASSWORD=

This is an error message

1 Doctrine\DBAL\Driver\PDOException::("SQLSTATE[HY000] [2002] No such file or directory") /Documents/cleaning/example/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:31

2 PDOException::("SQLSTATE[HY000] [2002] No such file or directory") /Documents/cleaning/example/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:27

Possible duplicate of PDOException SQLSTATE[HY000] [2002] No such file or directory — dparoli
– dparoli, Commented Sep 2, 2019 at 7:24

dılo sürücü · Accepted Answer · 2019-09-02 13:09:20Z

1

If not exist .env file ,create one from .env-example and in set declare database configs and run command If you not callin key:generate

php artisan key:generate

If you have been all,exec below command


php artisan config:cache

And try

php artisan migrate

If your still get error try localhost or http://127.0.0.1 ,edit it And again run below command

php artisan config:cache

Import -2002 error given error when user and password wrong to host

answered Sep 2, 2019 at 13:09

dılo sürücü

4,2692 gold badges31 silver badges32 bronze badges

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

Comments

G.D Udara Lahiru Sampath · Accepted Answer · 2019-09-02 12:29:14Z

-2

Try 127.0.0.1 instead of localhost in your .env file.
Run php artisan cache:clear
php artisan migrate --env=production

Above steps works for me.

answered Sep 2, 2019 at 12:29

G.D Udara Lahiru Sampath

1477 bronze badges

Collectives™ on Stack Overflow

How to fix " php artisan migrate" error in Laravel

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related