Getting an error on the command: php artisan migrate

You have a space in your table schema - blog_testing. Check your database config file or your migrations to find that space.

I do not believe that is the problem. The space you see has to do with the terminal output to a new line.

try something like this

composer dump-autoload

Morning etrainerspy

Some questions:

1. Do you have a database (sorry :-)
2. If you are migrating a test database then does your non test database migrate ok?
3. Do you have your .env file set up correctly?

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=database-name
DB_USERNAME=homestead
DB_PASSWORD=secret

Yikes! I just deleted all of the tables from my non test database and tried to migrate. I am getting the same error message:

[Illuminate\Database\QueryException] SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = projLearn and table_name = migrations)

[PDOException] SQLSTATE[HY000] [2002] No such file or directory

Where should I look next to solve the problem?

in your .env file use 127.0.0.1 instead of localhost so that pdf connection is via IP rather than socket

you should not need to do this but it sounds like you have a socket configuration issue

@Screenbeetle How do I create a database???

@visheshchanana if you mean literally creating the database, I'd suggest the app Sequel Pro if you're on macOS or something like it if you're on Windows.

Hi there, Did someone find a workaround?

I got this error on macos sierra when using the built-in php (version 5.6.30). When I switched to 7.1.9 the error went away.

Check your HOST connection

PLEASE, BE SURE YOU HAVE THE CORRECT DB_PORT ON THE .env FILE

SANTI1111 is correct. I spent a couple of hours trying every possible suggested fix on the internet, and nothing had worked until I looked at the DB_PORT in the .env file. Wamperver was using 3308 instead of the default 3306. I was FINALLY usable to get php artisan migrate to run!