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    gt          sqlite    gt             driver    gt   sqlite            database    gt  env  DB DATABASE   database path  database sqlite              prefix    gt                   mysql    gt             driver    gt   mysql            host    gt  env  DB HOST    127 0 0 1             port    gt  env  DB PORT    3306             database    gt  env  DB DATABASE    forge             username    gt  env  DB USERNAME    forge             password    gt  env  DB PASSWORD                 unix socket    gt  env  DB SOCKET                 charset    gt   utf8mb4            collation    gt   utf8mb4 unicode ci            prefix    gt               strict    gt  true           engine    gt  null               pgsql    gt             driver    gt   pgsql            host    gt  env  DB HOST    127 0 0 1             port    gt  env  DB PORT    5432             database    gt  env  DB DATABASE    forge             username    gt  env  DB USERNAME    forge             password    gt  env  DB PASSWORD                 charset    gt   utf8            prefix    gt               schema    gt   public            sslmode    gt   prefer                sqlsrv    gt             driver    gt   sqlsrv            host    gt  env  DB HOST    localhost             port    gt  env  DB PORT    1433             database    gt  env  DB DATABASE    forge             username    gt  env  DB USERNAME    forge             password    gt  env  DB PASSWORD                 charset    gt   utf8            prefix    gt                   Any ideas

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

For anyone trying to enable the extension inside a Docker image  RUN docker-php-ext-install pdo pdo mysql        amp  amp  docker-php-ext-enable pdo mysql  Based on this answer  Also props to  Krishna for shedding some light on the extension issue

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

In Windows and PHP 7 4 5 go to php ini and uncomment this line  extension pdo mysql

User · Answer

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

User · Answer

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  - gt json        stuff    gt  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

User · Answer

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  quot abc quot  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

User · Answer

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

[php] Artisan migrate could not find driver

Examples related to php

Examples related to laravel