php artisan migrate error

[mianshargeel]

• Laravel Version: 5.4
• PHP Version: 7.1
• Database Driver & Version:mysql

Description:

i m running command: php artisan migrate
and getting such like Exception as
[Illuminate\Database\QueryException]
SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables
where table_schema = laravel3 and table_name = migrations)

Steps To Reproduce:

[rossjcooper]

Are you on Mac or Linux?

[mianshargeel]

I m on mac

[sisve]

Could you update this issue with your mysql version?

[amadeann]

If this is a fresh install, do you see the migrations table in the DB (i.e. what happens when you execute the query from the exception directly in mysql)? I had once a similar issue and it was caused by the wrong configuration of DB connection parameters (in my case it was hostname).

[mianshargeel]

Sisve I have already updated mysql

[rossjcooper]

You may have to specify a connection socket in your config or use 127.0.0.1 as your DB_HOST rather than localhost

Stack Overflow Solution

[hakuno]

It seems a database schema issue. Can you test without schema or whatever? By the way, does MySQL have schema like PostgreSQL?

[mianshargeel]

this is my config/database.php
'mysql' => [
'driver' => 'mysql',
'host' => env('DB_HOST', '127.0.0.1'),
'port' => env('DB_PORT', '3306'),
'database' => env('DB_DATABASE', 'forge'),
'username' => env('DB_USERNAME', 'forge'),
'password' => env('DB_PASSWORD', ''),
'unix_socket' => env('DB_SOCKET', ''),
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
'prefix' => '',
'strict' => true,
'engine' => null,
],

and this is my .env file

DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=laravel_5
DB_USERNAME=root
DB_PASSWORD=root

[neoacevedo]

For me, is a bug on artisan in all Laravel versions. I have a similar issue on Laravel 4.2 using server variables for database connection. If I configure on database.php each value with direct values, artisan works, but if I use environment or server variables, artisan displays the mentioned error.

[mianshargeel]

i also tried to submit all connection data(DB_name, username, pass etc) in my database.php but i did't works

[znsstudio]

As far as I know you can not have both .env file and environment settings done via shell.

[neoacevedo]

'host' =>  '127.0.0.1:3306', //or localhost
'database' =>  'forge',
'username' =>  'forge',
'password' =>  '',

Without unix_socket. In my case works for migrations and commands. Just I tried to log a server custom variable on command and it goes empty, so for .env files on >=L5 or using directly server variables I think we will need to do something like this StackOverflow question

[themsaid]

Looks like a configuration issue, the query you shared is for postgres grammar not MySQL, please double check your config because a fresh laravel installation works with no issues.

Closing but feel free to continue discussion.

[mianshargeel]

again getting thie kind of error
[Illuminate\Database\QueryException]
SQLSTATE[HY000] [1049] Unknown database 'blog' (SQL: select * from information_schem
a.tables where table_schema = blog and table_name = migrations)

[PDOException]
SQLSTATE[HY000] [1049] Unknown database 'blog'