Laravel PDOException could not find driver

Question

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  amp  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

User · Answer

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

User · Answer

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

User · Answer

For me  these steps worked in Ubuntu with PHP 7 3  1  vi  etc php 7 3 apache2 php ini  gt  uncomment     extension pdo sqlite    extension pdo mysql 2  sudo apt-get install php7 3-sqlite3 3  sudo service apache2 restart

User · Answer

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

User · Answer

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

User · Answer

In Linux Download Mysql and Php sudo apt install php-mysql  Then the problem will be solved

User · Answer

In CentOS7 I try this  yum install php-mysql  then edit php ini

User · Answer

In case that you run test in sqlite run sudo apt install sqlite3  amp  amp  sudo apt install php-sqlite3  If you run test in window  you dont need install nothing  Only config your phpunit xml

User · Answer

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

User · Answer

I had the same issue  and I uncomment extension pdo sqlite and ran the migration and everything worked fine

User · Answer

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

User · Answer

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

User · Answer

if you have installed new version of php 7 2  then you have to uncomment this line in php ini   extension pdo mysql

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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  Laravel 5 PDOException Could Not Find Driver    I think I had to do something exactly like this when setting up laravel on digital ocean

User · Answer

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

User · Answer

For me  php ini was OK  but I needed to restart php artisan serve

User · Answer

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

User · Answer

Even simpler in Ubuntu  18 04   apt install php-mysql  Done  No need to edit any  ini files   Happy coding

User · Answer

in ubuntu or windows  path php ini  php -i   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

User · Answer

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

[php] Laravel: PDOException: could not find driver

Examples related to php

Examples related to mysql

Examples related to apache

Examples related to laravel

Examples related to sqlite