Illuminate\Database\QueryException : could not find driver Error

Question

I have an error when trying to execute the command

php artisan migrate

on my Windows command prompt I've already tried many solutions from the internet by uncommenting

extension=pdo_mysql

in my php.ini configuration on Xampp but it still not working, is there any working solution to solve this problem?

ERROR:

Hello, At the end, what did you do for this issue? – mehri abbasi Aug 26 '21 at 07:06 — mehri abbasi, Aug 26 '21 at 07:06

score 2 · Answer 1 · answered Jan 03 '19 at 06:22

2

go to "config" folder of your project and open database.php

and replace with this code

   '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' => 'InnoDB',
    ],

answered Jan 03 '19 at 06:22

Boni

338
2
13

it still the same – Miyuki Ouka Jan 03 '19 at 06:30
please change your php version to 7.2 and restart your server – Boni Jan 03 '19 at 06:57
I've already installed the Xampp with php version 7.2 but it doesn't work – Miyuki Ouka Jan 03 '19 at 08:33
did you make changes in database.php if you did my suggestion is to reinstall laravel and do change in database.php and try php artisan migrate i think this will work – Boni Jan 03 '19 at 09:08
no, I didn't I just make new database in MySQL and then run php artisan make:controller CreatesContoller and php artisan make:model Article -m to create controller and migration – Miyuki Ouka Jan 03 '19 at 09:15
please do changes in database.php and try – Boni Jan 03 '19 at 09:20

score 1 · Answer 2 · answered Jan 03 '19 at 06:22

1

you can use First check php version by using php --version and install the corresponding driver.

sudo apt-get install php7-mysql

Or

sudo apt-get install php5-mysql

or

sudo apt-get install php-mysql

answered Jan 03 '19 at 06:22

Rajesh

181
1
11

@MiyukiOuka Which PHP version are you using? – Rajesh Jan 03 '19 at 06:39
@MiyukiOuka This can happen for a Number of reasons. Either the Default DB type is not set (config/database.php), or the Extension is not enabled, or you HAVE enabled the extension but have NOT restarted XAMPP, or the PATH settings under environment settings are not properly defined. I suggest you check out this answer which may solve the issue: https://stackoverflow.com/a/25336292/2745485 – Rajesh Jan 03 '19 at 06:42
I'm using php version 7.3.0 – Miyuki Ouka Jan 03 '19 at 06:49

score 0 · Answer 3 · answered Jan 03 '19 at 07:00

0

You might need to un-comment extension=php_pdo_mysql.dll.

Dont forget to restart xampp after un-commenting.

answered Jan 03 '19 at 07:00

Muhammad Bilal

2,106
1
15
24

Udhav Sarvaiya · Answer 4 · 2019-01-03T09:21:49.353

0

Run Following command:

composer require doctrine/dbal
composer update

It looks like you have a missing dependency it showing error on your image.

Also Windows users, PDO and all the major drivers ship with PHP as shared extensions, and simply need to be activated by editing the php.ini file:

extension=php_pdo.dll

Note: This step is not necessary for PHP 5.3 and above, as a DLL is no longer required for PDO.

edited Jan 03 '19 at 09:21

answered Jan 03 '19 at 07:04

Udhav Sarvaiya

9,380
13
53
64

@MiyukiOuka What happened after trying? – Udhav Sarvaiya Jan 03 '19 at 08:05
it still the same – Miyuki Ouka Jan 03 '19 at 08:30
@MiyukiOuka for testing purpose: create a new database and set in `.env` file after run `php artisan migrate` command execute, try it maybe it helps you – Udhav Sarvaiya Jan 03 '19 at 08:35
Okay, when you get a solution, please post as an answer :) – Udhav Sarvaiya Jan 03 '19 at 08:55
okay, I think I just realized something, I run php command from my cmd and after I deleting php directory on C:, the php command is gone, so I assume I have to run the command from Xampp shell in order to give a command to php in Xampp service – Miyuki Ouka Jan 03 '19 at 08:55
@MiyukiOuka xampp/php/php.ini this is correct directory structure, don't required your xampp installed only C:/ drive , you can other drive also give path of xampp – Udhav Sarvaiya Jan 03 '19 at 09:00
I'm sorry I don't understand with what you are meaning – Miyuki Ouka Jan 03 '19 at 09:04
actually, this is my first time using laravel in my project – Miyuki Ouka Jan 03 '19 at 09:05

score 0 · Answer 5 · answered Jan 03 '19 at 09:00

okay, I think I just realized something, I run php command from my cmd and after I deleting php directory on C:, the php command is gone, so I assume I have to run the command from Xampp shell in order to give a command to php in Xampp service, it works with that way, thank you

Illuminate\Database\QueryException : could not find driver Error

5 Answers5