Artisan migrate could not find driver

Question

I am trying to install Laravel. I have installed Xampp, but when I try to setup my database using php artisan migrateI get the error:

[Illuminate\Database\QueryException] could not find driver (SQL: select * from information_schema.tables where table_schema = homestead and table_name = migrations) [PDOException] could not find driver

config/database.php file has the relevant connections:

'connections' => [      'sqlite' => [         'driver' => 'sqlite',         'database' => env('DB_DATABASE', database_path('database.sqlite')),         'prefix' => '',     ],      '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,     ],      'pgsql' => [         'driver' => 'pgsql',         'host' => env('DB_HOST', '127.0.0.1'),         'port' => env('DB_PORT', '5432'),         'database' => env('DB_DATABASE', 'forge'),         'username' => env('DB_USERNAME', 'forge'),         'password' => env('DB_PASSWORD', ''),         'charset' => 'utf8',         'prefix' => '',         'schema' => 'public',         'sslmode' => 'prefer',     ],      'sqlsrv' => [         'driver' => 'sqlsrv',         'host' => env('DB_HOST', 'localhost'),         'port' => env('DB_PORT', '1433'),         'database' => env('DB_DATABASE', 'forge'),         'username' => env('DB_USERNAME', 'forge'),         'password' => env('DB_PASSWORD', ''),         'charset' => 'utf8',         'prefix' => '',     ],  ], 

Any ideas?

Answer 1

In your php.ini configuration file simply uncomment the extension:

;extension=php_pdo_mysql.dll 

(You can find your php.ini file in the php folder where your stack server is installed.)

If you're on Windows make it: extension=php_pdo_mysql.dll

If you're on Linux make it: extension=pdo_mysql.so

And do a quick server restart.

If this isn't working for you, you may need to install pdo_mysql extension into your php library.