php artisan migrate throwing PDO Exception Could not find driver - Using Laravel

Question

I have a bad experience while installing laravel  However  I was able to do so and move to the next level  I used generators and created my migrations   But when I type the last command   php artisan migrate   It s throwing a PDOException - could not find driver           mysql    gt  array               driver       gt   mysql                host         gt   localhost                unix socket      gt    Applications MAMP tmp mysql mysql sock                database     gt   database                username     gt   root                password     gt                   charset      gt   utf8                collation    gt   utf8 unicode ci                prefix       gt                   That s my configuration in config database php   I tried searching on stackoverflow and laravel forums and people suggest that it s PDO problem and not artisan s or php s - I followed those suggestions like adding   extension pgsql so extension pdo pgsql so   in php ini   No positive result  It always says  PDOException could not find driver   Can someone please help resolving this   Environment that I am using  Mac  laravel 4  MAMP PRO with php 5 4 4

User · Answer

This worked for me   sudo apt-get install php5-sqlite   This installed sqlite for php5  then I ran the php artisan migrate command again and worked perfectly

User · Answer

I found the proper solution for this error  Either you don t have any database installed or your default database in this file config database php is set to some other database like this   default    gt   sqlite    default    gt  env  DB CONNECTION    sqlite      laravel 5 2   change the default to which one you have installed or install that database which is made to be default  I had installed mysql and php artisan migrate worked after i changed that line to this    default    gt   mysql    default    gt  env  DB CONNECTION    mysql      laravel5 2

User · Answer

You need to specifically enable the pdo mysql plugin  Assuming you re using a standard PHP installation  then generally you would simply need to add this to your PHP ini file   extension pdo mysql so   You need to ensure that this file exists in the extension directory though   Adding pdo pgsql so doesn t help because that is for PostgreSQL   Additionally  you should ensure that you restart the web-server after you make the changes to the PHP ini file  as the changes may not be reflected otherwise

User · Answer

I m unsing ubuntu 14 04 Below command solved this problem for me   sudo apt-get install php-mysql  In my case  after updating my php version from 5 5 9 to 7 0 8 i received this error including two other errors  errors   laravel framework v5 2 14 requires ext-mbstring   - gt  the requested PHP extension mbstring is missing from your system   phpunit phpunit 4 8 22 requires ext-dom   - gt  the requested PHP extension dom is missing from your system    PDOException  could not find driver   Solutions  I installed this packages and my problems are gone   sudo apt-get install php-mbstring sudo apt-get install php-xml sudo apt-get install php-mysql

User · Answer

I was also getting the same error --    PDOException    could not find driver    After that I used many commands but not didn t get any help  Finally I used the following command  which solved my problem   sudo apt-get install php5-sqlite

User · Answer

for those users of windows 10 and WAMP that found this post  i have a solution Please go visit this link  It worked for me and it was difficult to come to the solution but i hope it might be of help for others in the future

User · Answer

Please check your Laravel  env file also  Make sure DB CONNECTION mysql  otherwise it won t work with MySQL  It tried to load something else

User · Answer

If you are using Laravel 5 x  and the error is from trying to modify the attributes of a column  it is possible the error comes from a missing pre-requisite   Try this    composer require doctrine dbal   Then try running your migrations   From here  https   laravel com docs master migrations modifying-columns

User · Answer

Ran into the same issue here  and turns out this is because PHP at the command line uses a different php ini file from the browser version  which is why it looks like it s loading the extension correctly when you look at phpinfo   in a browser   As per this answer  you just need to run   php --ini   At the command line  which will tell you the path to the currently loaded php ini  probably actually a php-cli ini file located in the same place as your regular php ini file    Once you ve found that  modify it with the pdo extensions you want  in this case for MySQL    extension pdo mysql so   Or  for any other users that are on Windows using some kind of WAMP server  it probably looks like this instead   extension php pdo mysql dll

User · Answer

I had this problem on debian  The issue was  I was using the dotdeb repository for more recent PHP packages  For some reason  it updated the php cli to 7 0  while the web php binary remained php 5 6  I used this answer to link the php command line binary to the 5 6 version  like so     sudo ln -sfn  usr bin php5  etc alternatives php

User · Answer

first check your php version  like this     php -v   after you get  version number for example i get 7 1 then install like that  sudo apt-get install  php7 1-sqlite       for laravel testing with sqlite sudo apt-get install  php-mysql           for default mysql sudo apt-get install  php7 1-mysql        for version based mysql  sudo apt-get install  php7 1-common       for other necessary package for php   and need to restart apache2  sudo service apache2 restart

User · Answer

This worked with me  for pgsql  use  pgsql  instead of  mysql    Step 1   sudo apt-get install php-mysql   Step 2   php artisan config clear   Step 3   php artisan config cache   Step 4  Then restart your server  and generate key again and migrate it  Its Done

User · Answer

I was also getting the same error --    PDOException  could not find driver    I realized that the php was pointing to  usr bin php instead of the lampp  opt lampp bin php so i simply created and alias  alias php   opt lampp bin php    also had to make update to the  env file to ensure the database access credentials were updated   And guess what  it Worked

User · Answer

For future searchers  On FreeBSD try the next   pkg info   grep php5-pdo mysql   if you see the empty line in return do the following   cd  usr ports databases php5-pdo mysql   and the do the install  make install clean   then simply restart your apache and you are done  e g   sudo  usr local etc rc d apache22 restart

User · Answer

Laravel Testing with sqlite needs php pdo sqlite drivers  For Ubuntu 14 04  sudo apt-get install php5-sqlite sudo service apache2 restart   In ubuntu 16 04 there is no php5-sqlite  sudo apt-get install php7 0-sqlite sudo service apache2 restart

User · Answer

If you are using arch based system like in manjaro   just use   sudo pacman -S php-sqlite   Restart your httpd  systemctl restart httpd

User · Answer

In my case I wasn t aware that the PHP run by Apache was different from the one run by CLI  That might be the case if during configuration in httpd conf you specified a PHP module  not being the default one your CLI uses

User · Answer

You must be installing the latest version of php mysql in my case I am install php7 1-mysql  Try this  sudo apt-get install php7 1-mysql   I am using the latest version of laravel

User · Answer

You can use  sudo apt-get install php7-mysql   or  sudo apt-get install php5-mysql   or  sudo apt-get install php-mysql   This worked for me

User · Answer

I think you missed the mysql driver for php5  Execute below command   sudo apt-get install php5-mysql  etc init d php5-fpm restart

User · Answer

You are missing a PDO driver   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

Install it via this command   sudo apt-get install php5-gd  this worked for me

User · Answer

I got this error for the PostgreSQL and the solution is   sudo apt-get install php7 1-pgsql   You only need to use your installed PHP version  mine is 7 1  This has fixed the issue for PostgreSQL

User · Answer

just replaced   extension pdo mysql to extension pdo mysql in php ini file

User · Answer

Assuming you did the normal installation with virtual box  vagrant etc   This can happen to new people  PHP can be installed on your PC but all the modules PHP for your laravel project is on your VM So to access your VM  go to your homestead folder and type  vagrant ssh  then to go your project path and execute the php artisan migrate

User · Answer

Had the same issue and just figured  website is running under MAMP s php  but when you call in command  it runs mac s if no bash path modified   you will have issue when mac doesn t have those extensions   run php -i to find out loaded extensions  and install those one you missed  or run   Applications MAMP bin php php5 3 6 bin php artisan  your command   to use MAMP s

[php] php artisan migrate throwing [PDO Exception] Could not find driver - Using Laravel

Examples related to php

Examples related to mysql

Examples related to pdo

Examples related to laravel

Examples related to driver