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?

On your `database.php` Does the `default connection name` was set to this? `'default' => env('DB_CONNECTION', 'mysql'),`? — Marylyn Lajato, Oct 14 '17 at 14:09
Possible duplicate of [Laravel: PDOException: could not find driver](https://stackoverflow.com/questions/42557693/laravel-pdoexception-could-not-find-driver) — Sakthivel A R, Sep 28 '19 at 16:54

score 123 · Accepted Answer · answered Dec 21 '17 at 16:39

123

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.

answered Dec 21 '17 at 16:39

Krishna Kant Chourasiya

1,381
1
10
4

25

it can also be the whole php-mysql extension missing. so maybe also something like: sudo apt install php7.3-mysql (change 7.3 whit your php ver) – andymnc Mar 31 '19 at 21:54
@Krishna Kant Chourasiya , hello i am also getting error in migration please help me , i have tried all the solution given in this page nothing working . here is the link https://stackoverflow.com/questions/60716326/php-laravel-artisan-migrate-error-in-model – Kiran Patel Mar 17 '20 at 05:51
The error is the same for all SQL drivers, so for who are not using MySQL try install your SQL driver... like php-pgsql or php-sqlite3. – Fellipe Sanches May 14 '22 at 22:46
2

for php version 8.2.5 its: `extension=pdo_mysql` just search for `pdo_mysql` in your php.ini file instead of `php_pdo_mysql`, and then uncomment. – bvk Jun 12 '23 at 17:03

score 56 · Answer 2 · edited Apr 01 '20 at 12:42

We have solved the same error by following the below steps.

linux command for this type of error occurred then, first of all, check your php.ini file

If your php.ini file exists then in configuration file simply uncomment the extension:

;extension=php_pdo_mysql.dll 

Else follow below steps

step1:php -v

step2: Install php mysql extension

php 7.0 sudo apt-get install php7.0-mysql

php 7.1 sudo apt-get install php7.1-mysql

php 7.2 sudo apt-get install php7.2-mysql

php 7.3 sudo apt-get install php7.3-mysql

step3: service apache2 restart

step4: php artisan migrate

score 42 · Answer 3 · answered Jun 02 '20 at 06:44

42

if you've installed php and mysql in your linux machine, php needs php-mysql extention to communicate with mysql. so make sure you've also installed this extention using:

sudo yum install php-mysql in redhat based machines.

and

sudo apt-get install php-mysql in debian machines.

answered Jun 02 '20 at 06:44

Ali_Hr

4,017
3
27
34

3

This answer worked for me in ubuntu 18.04 thanks @Ali_Hr – Nelson Katale Jul 02 '20 at 11:55
1

This answer worked for me on Ubuntu 20.04 LTS, i was using Xampp as my localhost environment thanks for saving my day @Ali_Hr – matynjr May 28 '21 at 10:23
1

This worked for me on Ubuntu 20.04 LTS. – Kennedy Owusu Mar 16 '22 at 17:57
1

Worked on Ubuntu 22.04 LTS. – pasindu Jun 02 '22 at 04:53

score 30 · Answer 4 · answered Mar 25 '21 at 14:23

30

You also need to install the PHP-MySQL drivers:

sudo apt install php-mysql

answered Mar 25 '21 at 14:23

Happy Patel

2,259
1
16
25

score 12 · Answer 5 · answered Oct 19 '20 at 12:06

12

Make sure that you've installed php-mysql, the pdo needs php-mysql to operate properly. If not you could simply type

sudo apt install php-mysql

answered Oct 19 '20 at 12:06

MD Nasirul Islam

501
5
17

score 11 · Answer 6 · answered Oct 09 '18 at 08:56

I know this is a little late, nevertheless i'm answering this for anyone still experiencing this issue on windows (USING XAMPP).

Step 1. Verify that there is a mismatch in your PHP version. To do this, open routes/web.php and create a simple route to return the php information like so:

Route::get('/', function() {
   return response()->json([
    'stuff' => phpinfo()
   ]);
})

and compare this with output from your command line

As we can see, in my case there is a mismatch, this usually happens if you have multiple versions of php installed.

Step 2. Add the php version being used by your xampp to your system path

Step 3. Verify that you have the extension enabled in your php.ini file. NB. Make sure you are editing the php.ini file that is shown under the 'loaded configuration file' entry in the results of phpinfo() command.

score 11 · Answer 7 · answered Feb 21 '22 at 10:13

11

the same problem I got but after I run this line of code.

sudo apt install php-mysql

Done.

answered Feb 21 '22 at 10:13

Y. Joy Ch. Singha

3,056
24
26

score 9 · Answer 8 · answered Feb 26 '21 at 11:48

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

;extension=pdo_mysql

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

make this to

extension=pdo_mysql

now you need to configure your .env file in find DB_DATABASE= write in that database name which you used than migrate like if i used my database and database name is "abc" than i need to write there DB_DATABASE=abc and save that .env file and run command again

php artisan migrate

so after run than you got some msg like as:

php artisan migrate
Migration table created successfully.

score 6 · Answer 9 · edited Oct 28 '19 at 21:25

6

I am a Windows and XAMPP user. What works for me is adding extension=php_pdo_mysql.dll in both php.ini of XAMPP and php.ini in C:\php\php.ini.

Run this command in your cmd to know where your config file is

php -i | find /i "Configuration File

edited Oct 28 '19 at 21:25

halfer

19,824
17
99
186

answered Oct 25 '19 at 22:14

Phuc Le

141
2
4

score 6 · Answer 10 · answered Apr 29 '20 at 04:45

6

In Windows and PHP 7.4.5 go to php.ini and uncomment this line

extension=pdo_mysql

answered Apr 29 '20 at 04:45

Kevin Montalvo

751
7
5

score 5 · Answer 11 · answered May 14 '22 at 22:50

5

This error is the same for all SQL drivers, so for who are not using MySQL try install your SQL driver...

SQL Lite:

sudo apt install php-sqlite3

PostgreSQL:

sudo apt install php-pgsql

answered May 14 '22 at 22:50

Fellipe Sanches

7,395
4
32
33

2

for me, i need to install exactly the php version for it, such as php7.4-pgsql – fudu Jun 20 '23 at 07:35

score 3 · Answer 12 · answered May 16 '20 at 11:34

3

If you are on linux systems please try running sudo php artisan migrate As for me,sometimes database operations need to run with sudo in laravel.

answered May 16 '20 at 11:34

lwin moe hein

179
2
11

score 3 · Answer 13 · answered Feb 08 '21 at 02:10

3

For anyone trying to enable the extension inside a Docker image:

RUN docker-php-ext-install pdo pdo_mysql \
    && docker-php-ext-enable pdo_mysql

Based on this answer.

Also props to @Krishna for shedding some light on the extension issue.

answered Feb 08 '21 at 02:10

gyohza

736
5
18

score 3 · Answer 14 · answered Jul 07 '22 at 10:39

Install by running sudo apt install php-mysql and enabling extension=pdo_mysql in php.ini

Then reload apache by running sudo systemctl reload apache2

To quickly find your php.ini in your server, just run this command: php -i | grep "Loaded Configuration File"

Laravel Side:

php artisan config:clear

php artisan migrate

It works for me and good luck!

score 1 · Answer 15 · edited Mar 22 '20 at 07:50

1

If you are matching with sqlite database:
In your php folder open php.ini file, go to:

;extension=pdo_sqlite

Just remove the semicolon and it will work.

edited Mar 22 '20 at 07:50

סטנלי גרונן

2,917
23
46
68

answered Mar 22 '20 at 07:23

Ho360Code.dev

11
3

score 1 · Answer 16 · answered Sep 09 '21 at 18:16

I am so embarrassed. I know this doesn't help those using XAMPP, but I had to share. I have an out-of-the-box Laravel installation in Vagrant using a ScotchBox virtual machine running in Windows 10. And I am following the Digital Ocean tutorial. This should just work.

Like you, I ran php artisan migrate and I got

could not find driver (SQL: select * from sqlite_master where type = 'table' and name = migrations)

A few hours later, I thought

Maybe I should try inside of the Vagrant shell?

I opened vagrant ssh and ran php artisan migrate again. There I got a different message:

Could not open input file: artisan

A few more hours later, I got it right.

vagrant ssh

cd \var\www\

php artisan migrate

Migration table created successfully

So, yeah. I was in the wrong shell and the wrong folder.

score 0 · Answer 17 · answered Jan 09 '19 at 06:05

0

whilst sometimes you might have multiple php versions, you might also have a held-back version of php-mysql.. do a sudo dpkg -l | grep mysql | grep php and compare what you get from php -v

answered Jan 09 '19 at 06:05

baradhili

514
1
7
27

score 0 · Answer 18 · edited Feb 24 '20 at 07:51

0

Go to .env file and change the following

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=shreemad
DB_USERNAME=root
DB_PASSWORD=

Change the DB_PASSWORD field to

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=shreemad
DB_USERNAME=root
DB_PASSWORD=" "

In my case it works

NOTE: If your password in mysql is null

edited Feb 24 '20 at 07:51

octobus

1,246
1
14
20

answered Feb 24 '20 at 07:09

rajhem

1
1

score 0 · Answer 19 · answered Dec 18 '20 at 08:21

0

in ubuntu or windows

Remove the ; from ;extension=pdo_mysql or extension=php_pdo_mysql.dll and add extension=pdo_mysql.so

restart xampp or wampp
install sudo apt-get install php-mysql

and

php artisan migrate

answered Dec 18 '20 at 08:21

Netwons

1,170
11
14

score 0 · Answer 20 · answered Jan 17 '22 at 06:42

If you have multiple php versions installed applied all other options like UN commenting driver in php.ini and it does not work you might missed following step

Please check php -v from cmd
Go to your environment variables by right clicking on PC and properties
Check path of your php key, it might be pointing to older version.

score 0 · Answer 21 · answered May 13 '23 at 01:20

0

This solution works for me (Nginx / php8.1 / ubuntu 20.04)

In php.ini uncomment Mysql PDO extension
```
 extension=pdo_mysql
```
Install extension
```
 sudo apt install php8.1-pdo-mysql
```
Restart Nginx
```
 sudo systemctl reload nginx
```

answered May 13 '23 at 01:20

Ali

456
6
10

Artisan migrate could not find driver

21 Answers21

NOTE: If your password in mysql is null

Linked

Related