laravel php artisan migrate Error (timeout)

Question

I am using Laravel 5.6

when I use the command 'php artisan migrate' I get this error (after a minute) :

"Illuminate\Database\QueryException : SQLSTATE[HY000] [2002] Operation timed out (SQL: select * from information_schema.tables where table_schema = MYDATABASE and table_name = migrations)"

I have set up the correct database configuration in .env and config/database.php

I checked that my db connection works : if(DB::connection()->getDatabaseName()) { echo "Yes! successfully connected to the DB: " . DB::connection()->getDatabaseName(); }

And it works.

if i run the query directly in mysql, it will not work because of the lack of quotes. if instead I run this in mysql it will work:

select * from information_schema.tables where table_schema = 'MYDATABASE' and table_name = 'migrations'

the issue in php artisan seem to be : "Operation timed out" (not the usual "File not found" when i tried to look for an answer here.

How to solve the php artisan migrate issue ??? thank you!

amflare · Accepted Answer · 2018-03-13 15:13:14Z

1

I had this same problem and it turned out my host was incorrect.

In my .env file I set DB_HOST to the correct value and it all worked like a charm.

answered Mar 13, 2018 at 15:13

amflare

4,1413 gold badges28 silver badges48 bronze badges

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

1 Comment

Anns Rahim Over a year ago

I do have the same problem when using valet in Mac can u please help me on this.

Collectives™ on Stack Overflow

laravel php artisan migrate Error (timeout)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related