Laravel: PDOException: could not find driver
PhpMysqlApacheLaravelSqlitePhp Problem Overview
I am developing a website on a server I only have access to MySQL and FTP, so all commands I run are through the b374k php shell . I am experiencing a Laravel problem with SQL driver. I tried switching to file-hosted SQLite (in database/database.sqlite), but the thrown exception is the same as when using MySQL. The input & output of the console is as follows:
php artisan migrate:refresh --seed
[Illuminate\Database\QueryException]
could not find driver (SQL: select * from sqlite_master where type = 'table ' and name = migrations)
[Doctrine\DBAL\Driver\PDOException]
could not find driver
[PDOException]
could not find driver
The Apache extensions installed on the server are:
/etc/php/5.6/apache2/conf.d/10-mysqlnd.ini,
/etc/php/5.6/apache2/conf.d/10-opcache.ini,
/etc/php/5.6/apache2/conf.d/10-pdo.ini,
/etc/php/5.6/apache2/conf.d/15-xml.ini,
/etc/php/5.6/apache2/conf.d/20-calendar.ini,
/etc/php/5.6/apache2/conf.d/20-ctype.ini,
/etc/php/5.6/apache2/conf.d/20-curl.ini,
/etc/php/5.6/apache2/conf.d/20-dom.ini,
/etc/php/5.6/apache2/conf.d/20-exif.ini,
/etc/php/5.6/apache2/conf.d/20-fileinfo.ini,
/etc/php/5.6/apache2/conf.d/20-ftp.ini, /etc/php/5.6/apache2/conf.d/20-gd.ini,
/etc/php/5.6/apache2/conf.d/20-gettext.ini,
/etc/php/5.6/apache2/conf.d/20-iconv.ini,
/etc/php/5.6/apache2/conf.d/20-json.ini,
/etc/php/5.6/apache2/conf.d/20-mbstring.ini,
/etc/php/5.6/apache2/conf.d/20-mcrypt.ini,
/etc/php/5.6/apache2/conf.d/20-mysql.ini,
/etc/php/5.6/apache2/conf.d/20-mysqli.ini,
/etc/php/5.6/apache2/conf.d/20-pdo_mysql.ini,
/etc/php/5.6/apache2/conf.d/20-phar.ini,
/etc/php/5.6/apache2/conf.d/20-posix.ini,
/etc/php/5.6/apache2/conf.d/20-readline.ini,
/etc/php/5.6/apache2/conf.d/20-shmop.ini,
/etc/php/5.6/apache2/conf.d/20-simplexml.ini,
/etc/php/5.6/apache2/conf.d/20-sockets.ini,
/etc/php/5.6/apache2/conf.d/20-sysvmsg.ini,
/etc/php/5.6/apache2/conf.d/20-sysvsem.ini,
/etc/php/5.6/apache2/conf.d/20-sysvshm.ini,
/etc/php/5.6/apache2/conf.d/20-tokenizer.ini,
/etc/php/5.6/apache2/conf.d/20-wddx.ini,
/etc/php/5.6/apache2/conf.d/20-xmlreader.ini,
/etc/php/5.6/apache2/conf.d/20-xmlwriter.ini,
/etc/php/5.6/apache2/conf.d/20-xsl.ini,
/etc/php/5.6/apache2/conf.d/20-zip.ini
What can be the problem and how can I fix it? (I don't have access to root bash)
Php Solutions
Solution 1 - Php
If you can, run :
composer update
composer require doctrine/dbal
It looks like you have a missing dependency
Edit:
You might need to comment out the following in your php.ini file.
;extension=pdo_mysql.so
Taken from this post: https://stackoverflow.com/questions/35240414/laravel-5-pdoexception-could-not-find-driver . I think I had to do something exactly like this when setting up laravel on digital ocean.
Solution 2 - Php
Your database driver is missing. To solve the probelm
First install the driver
For ubuntu: For mysql database.
sudo apt-get install php5.6-mysql/php7.2-mysql
You also can search for other database systems.
You also can search for the driver:
sudo apt-cache search drivername
Then Run the cmd php artisan migrate
Solution 3 - Php
I got the same error when running my test suite. It was working before but it stopped working after I upgraded php. So I did
sudo apt-get install php-sqlite3
and it worked.
Solution 4 - Php
Even simpler in Ubuntu (18.04)
apt install php-mysql
Done. No need to edit any .ini
files.
Happy coding!
Solution 5 - Php
First check php -m
.If you don't see mysql driver install mysql sudo apt-cache search php-mysql
Your results will be similar to:
php-mysql - MySQL module for PHP [default]
install php- mysql Driver
sudo apt-get install php7.1-mysql
Solution 6 - Php
Solution 1:
1. php -v
Output: PHP 7.3.11-1+ubuntu16.04.1+deb.sury.org+1 (cli)
2. sudo apt-get install php7.3-mysql
Solution 2:
Check your DB credentials like DB Name, DB User, DB Password
Solution 7 - Php
ERROR:
could not find driver (SQL: select * from tests
where slug
= a limit 1)
I was getting the above error in my laravel project, i am using nginx server on ubuntu 16.04
This error is because, php-mysql
driver is missing. To install it type following command.
sudo apt-get install php7.2-mysql
Please specify your current php version
in above command.
Open php.ini
file and uncomment the followling line of code(Remove Semicolon).
;extension=pdo_mysql
Then Restart the nginx and php service
sudo systemctl restart php7.2-fpm
sudo systemctl restart nginx
It worked for me.
Solution 8 - Php
You are probably missing sqlite or the specific DB driver you are trying to migrate.
Install the DB driver and you'd be fine. You don't necessarily need to edit your php.ini file (it's one way to fix it too though).
For sqlite do --> sudo apt-get install php-sqlite3
Then php artisan migrate
NB: I assume you have PHP and MySql already installed
Solution 9 - Php
I had a similar issue in Ubuntu 16.04 and what help me was that i installed php-mysql for php 7.2. I would recommend you run the following command if you have php 7.2 or install php mysql depending on your version of PHP. Make sure that you have installed the DBAL packege
apt-get install php7.2-mysql
systemctl restart apache2
Solution 10 - Php
You need to enable these extensions in the php.ini file
Before:
;extension=pdo_mysql
;extension=mysqli
;extension=pdo_sqlite
;extension=sqlite3
After:
extension=pdo_mysql
extension=mysqli
extension=pdo_sqlite
extension=sqlite3
It is advisable that you also activate the fileinfo extension, many packages require this.
Solution 11 - Php
I faced the same problem while using sqlite 3:
- Make sure the changes made on .env.example and the same on the .env file.
- Then run
$
sudo apt-get install php-sqlite3 on terminal. - Finally
$
php artisan migrate.
Solution 12 - Php
I had the same issue, and I uncomment extension=pdo_sqlite
and ran the migration
and everything worked fine.
Solution 13 - Php
Finally I fixed this. There was a typo in the server configuration and all paths to php extecutables were fine except the path to php-cli, which caused the error. When I fixed the path, everything worked fine.
Solution 14 - Php
In CentOS7,I try this: yum install php-mysql
, then edit php.ini
Solution 15 - Php
if you have installed new version of php 7.2+ then you have to uncomment this line in php.ini ;extension=pdo_mysql
Solution 16 - Php
In my case I'm using Ubuntu so I found that my system is not installed php-sqlite3, after installation its got fixed.
sudo apt-get install php7.2-sqlite3
Solution 17 - Php
In case that you run test in sqlite run
sudo apt install sqlite3 && sudo apt install php-sqlite3
If you run test in window, you dont need install nothing. Only config your phpunit.xml
Solution 18 - Php
In Linux Download Mysql and Php
sudo apt install php-mysql
Then the problem will be solved.
Solution 19 - Php
For sqlite on debian/ubuntu
PHP 7.1
sudo apt install php7.1-sqlite3
PHP 7.2
sudo apt install php7.2-sqlite3
PHP 7.3
sudo apt install php7.3-sqlite3
PHP 7.4
sudo apt install php7.4-sqlite3
Solution 20 - Php
for Windows 8.1/10 in :\php.ini file you should uncomment line "extension=pdo_mysql"
Solution 21 - Php
Not really answer to original question but might help to someone:
When using docker you have to execute:
docker-compose exec [NAME_OF_DOCKER_SERVICE] php artisan migrate
Instead of only php artisan migrate
Just wanted to share this as I have made this error few times already
Solution 22 - Php
In window OS. I have uncomment extension=pdo_mysql for php.ini file that locate at same directory of php.exe. after that it work fine.
Solution 23 - Php
Some Additional information for people who upgraded their php version.
This is for laravel framework using MySql or MariaDB.
I had issues after upgrading php version from 7.2 to 7.4.
- Make sure you completely install php extentions and packages for php version 7.4 (Or your installed php version).
- Make sure you enable these extentions. pdo_mysql, xmlrpc, mbstring, mysqli, openssl, fileinfo, gd2, curl at php.ini.
- Then clear cache, config
- Restart all services such as apache, supervisor
Solution 24 - Php
in ubuntu or windows
-
path php.ini
-
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
Solution 25 - Php
For me, these steps worked in Ubuntu with PHP 7.3:
1. vi /etc/php/7.3/apache2/php.ini > uncomment:
;extension=pdo_sqlite
;extension=pdo_mysql
2. sudo apt-get install php7.3-sqlite3
3. sudo service apache2 restart
Solution 26 - Php
On Windows, I followed the same path as the previous answers. The difference is that the path to php.ini is usually different from the traditional ones, usually in Apache.
To find php.ini, I used the following path: C:\tools\php80\php.ini
After that, I uncommented the pdo extension files
and the migration worked.
Solution 27 - Php
In my case I the php path was different from xampp php path that my project hosted on.
So I just change the system path from the pure php path to the php path in xamppp and all working fine.
I run this command in Ubuntu
sudo ln -s /opt/lampp/bin/php /usr/bin/php
may you have installed the php so like me you need to first run this command and then try above again
sudo rm /usr/bin/php
May your composer has some issue so you need to run this as well
curl -sS https://getcomposer.org/installer | sudo php -- --install-dir=/usr/bin --filename=composer
Source: https://askubuntu.com/a/563993
Solution 28 - Php
For php 8 running on laravel 8 (ubuntu), run sudo apt install php8.0.3-mysql
then restart apache
sudo service apache2 restart
Solution 29 - Php
This error happened to me using sail
for development. In this case the solution was to run the command inside the container
docker exec -it <app-container-id> php artisan migrate
The app container id is probably like this:
<app-name>_laravel.test_1
Solution 30 - Php
Create a .env file.
if using laravel and composer, generate a key for project.
php artisan key:generate
Solution 31 - Php
For me, php.ini
was OK, but I needed to restart php artisan serve
.