Laravel 5 PDOException Could Not Find Driver

Question

I have a problem using Laravel 5. When I run "php aritsan migrate", I got this error

**************************************
*     Application In Production!     *
**************************************

Do you really wish to run this command? [y/N] y

[PDOException]
could not find driver

I could run the application, but when database connection needed, I got this error

PDOException in Connector.php line 55:
could not find driver
in Connector.php line 55
at PDO->__construct('mysql:host=localhost;dbname=mydb', 'root', '', array('0', '2', '0', false, false)) in Connector.php line 55
at Connector->createConnection('mysql:host=localhost;dbname=mydb', array('driver' => 'mysql', 'host' => 'localhost', 'database' => 'mydb', 'username' => 'root', 'password' => '', 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', 'strict' => false, 'name' => 'mysql'), array('0', '2', '0', false, false)) in MySqlConnector.php line 22

How to fix it?

For PHP 7.4 on Windows 10 (x64) have a look https://stackoverflow.com/questions/49333044/laravel-migration-cannot-find-driver-when-using-sqlsrv-database-in-windows/65762068#65762068 — endo64, Jan 17 '21 at 14:51

score 127 · Answer 1 · edited Jul 11 '16 at 00:30

127

Same thing happend to me after upgrading distro.

Running sudo apt-get install php7.0-mysql fixed it for me.

edited Jul 11 '16 at 00:30

Charlie Fish

18,491
19
86
179

answered Jul 10 '16 at 22:47

knalj

1,454
1
10
14

4

Not sure why this has been marked down. This worked fine for me whereas the accepted answer did not. – Brad Bird Jul 24 '16 at 15:42
This is the first step, then activate PDO if needed. Take care of installing the mysql plugin for the right php version you're using, not especially the 7.0 (php -v) – tomsihap Oct 15 '16 at 10:24
I faced this error after replacing apache by nginx. I reinstalled php7.0-mysql after all and it worked like a charm. – therealbigpepe May 14 '17 at 07:17
1

In my case, I had already installed that and it was working for the command line (using the `artisan migrate` commands) but for some reason was still failing in the application. **I needed to restart apache!** – The Unknown Dev Aug 20 '17 at 00:47
3

I would suggest running `php -v` first to see what version of PHP you are running, and then install the appropriate version – Zachary Weixelbaum Sep 27 '17 at 02:27
Thank you. It worked in ubuntu 18.04.4 LTS, php7.4, laravel 3.2.0 – pharask Sep 02 '20 at 20:11
In some cases (latest Debian I think) it's `php-mysql` – Ed Halferty Feb 11 '21 at 07:29

score 89 · Accepted Answer · answered Feb 06 '16 at 11:32

89

You should install PDO on your server. Edit your php.ini (look at your phpinfo(), "Loaded Configuration File" line, to find the php.ini file path). Find and uncomment the following line (remove the ; character):

;extension=pdo_mysql.so

Then, restart your Apache server. For more information, please read the documentation.

answered Feb 06 '16 at 11:32

tomsihap

1,712
18
29

First, follow the @user657309 answer to install mysql (given your php version, not especially php7.0) – tomsihap Oct 15 '16 at 10:23
If you're using php-fpm you need to restart it, apart from restarting web server (nginx/apache) – Mugoma J. Okomba Jun 20 '17 at 21:35

score 31 · Answer 3 · edited Oct 25 '16 at 20:22

31

I'm using Ubuntu 16.04 and PHP 5.6.20

After too many problems, the below steps solved this for me:

find php.ini path via phpinfo()
uncomment
```
extension=php_pdo_mysql.dll
```
add this line
```
extension=pdo_mysql.so
```
then run
```
sudo apt-get install php-mysql
```

edited Oct 25 '16 at 20:22

Paul Roub

36,322
27
84
93

answered Oct 25 '16 at 20:17

Anil Gupta

1,593
1
19
21

`.dll` files are used by Windows operating system and shouldn't have an effect. That's why you need the `.so` equivalent for Linux. – Ari Jan 05 '18 at 03:59
Thank you so much. After striving for hours, your solution worked for me. – Apr 22 '18 at 17:49
Yes. That worked for the latest version: PHP 7.2.19-0ubuntu0.18.04.1 – Ibrahim Mohamed Jun 11 '19 at 02:46

score 18 · Answer 4 · answered Nov 19 '18 at 11:25

18

It will depend of your php version. Check it running:

php -version

Now, according to your current version, run:

sudo apt-get install php7.2-mysql

answered Nov 19 '18 at 11:25

edwinchp

181
1
3

Muhammad Sulman · Answer 5 · 2021-03-16T15:15:08.130

15

sudo apt-get update

For Mysql Database

sudo apt-get install php-mysql

For PostgreSQL Database

sudo apt-get install php-pgsql

Then

php artisan migrate

edited Mar 16 '21 at 15:15

answered Apr 07 '20 at 14:27

Muhammad Sulman

1,611
1
19
25

score 7 · Answer 6 · edited Jul 11 '17 at 09:34

7

I have tried the following command on Ubuntu and its working for me sudo apt-get install php7.0-mysql

Thanks

edited Jul 11 '17 at 09:34

AnNaMaLaI

4,064
11
53
93

answered Jul 11 '17 at 08:32

Abdul Rehman

111
1
3

score 6 · Answer 7 · edited Dec 30 '19 at 14:46

6

If your database is PostgreSQL and you have php7.2 you should run the following commands:

sudo apt-get install php7.2-pgsql

and

php artisan migrate

edited Dec 30 '19 at 14:46

Community

1
1

answered Apr 08 '19 at 16:41

Stivenson Mb

55
1
3

Welcome to SO! Please explain your amswer with some detail, ask questions in `comments` section. – Devang Padhiyar Apr 08 '19 at 17:03
sudo is for linux. what is for windows? – saadk Oct 16 '20 at 07:44

score 5 · Answer 8 · answered Feb 01 '22 at 14:24

5

Uncomment database line from php.ini file according to your database type

For MYSQL

;extension=pdo_mysql

For Postgres

;extension=pgsql

answered Feb 01 '22 at 14:24

Hadayat Niazi

1,991
3
16
28

score 2 · Answer 9 · answered Nov 30 '21 at 10:40

2

If you have php8 installed on ubuntu 20.04, you can run this command

sudo apt-get install php8.0-mysql

answered Nov 30 '21 at 10:40

Macdonald

880
7
21

score 1 · Answer 10 · answered May 07 '20 at 08:55

1

For me the problem was that I was running the migrate command not from inside the container where php was running. The extension was properly set there but not at my host machine.

answered May 07 '20 at 08:55

daniel

1,152
2
15
33

Same here, i should have run the command from my docker shell. – Ken Sep 22 '20 at 08:04

score 1 · Answer 11 · answered Jan 05 '22 at 08:23

1

This did trick for me.

sudo apt install php-mysql

it will install php-mysql depending on the version of php you are using

answered Jan 05 '22 at 08:23

Bercove

987
10
18

Laravel 5 PDOException Could Not Find Driver

11 Answers11

Linked

Related