Php and Mysql error: could not find driver when migrate version

Dung Do Tien Jun 28 2021 295

I'm using Ubuntu 20.04 and from my php.ini I have enabled: extension=php_pdo_mysql.dll and extension=php_pdo_sqlite.dll

my .env file is:

DB_CONNECTION=sqlite DB_HOST=127.0.0.1 DB_PORT=3009 DB_DATABASE=database DB_USERNAME=root DB_PASSWORD=pass123

and when I run: php artisan migrate

I get this error: could not find driver

Illuminate\Database\QueryException  : could not find driver (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations)

  at /home/morilon/php_proj/blog/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664
    660|         // If an exception occurs when attempting to run a query, we'll format the error
    661|         // message to include the bindings with SQL, which will make this exception a
    662|         // lot more helpful to the developer instead of just the database's errors.
    663|         catch (Exception $e) {
  > 664|             throw new QueryException(
    665|                 $query, $this->prepareBindings($bindings), $e
    666|             );
    667|         }
    668| 

  Exception trace:

  1   PDOException::("could not find driver")
      /home/morilon/php_proj/blog/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:68

  2   PDO::__construct("mysql:host=127.0.0.1;port=3306;dbname=blog", "root", "", [])
      /home/morilon/php_proj/blog/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:68

  Please use the argument -v to see more details.

I'm using PHP 7 and MySql.

How can I resolve this problem?

Have 3 answer(s) found.
  • J

    Jose Luis Jun 28 2021

    Maybe you have to install more Php-MySql. You can try with the command below:

    pkg --get-selections | grep mysql
sudo apt-get remove --purge [everything that came up]
sudo apt-get autoremove && sudo apt-get autoclean
sudo apt-get install mysql-server

    I hope it works for you!!

  • V

    Vuong Do Minh Jun 28 2021

    The solution ended up being to install the extension, which would also add its own .ini file and activate itself on installation.

     sudo apt-get install -y php7.4-mysql

    I hope it work for you!

  • M

    Mahery Andriniaina Razafimanantsoa Jun 28 2021

    I FIXED IT, I just need to run this command:

    sudo apt-get install php7.1-sqlite3

    and then other error:

    [Illuminate\Database\QueryException] Database (databaseName) does not exist. (SQL: select * from sqlite_master where type = 'ta ble' and name = migrations)  
[InvalidArgumentException] Database (databaseName) does not exist.

    so in my case, I created the database.sqlite file with touch database/database.sqlite

    Then in config/database.php I changed the 'default' => env('DB_CONNECTION', 'sqlite'), to sqlite

    and in .env file I just deleted those lines of code:

    DB_PORT=3309 DB_DATABASE=database DB_USERNAME=root DB_PASSWORD=secret

    and finally, everything is working fine.

    Migration table created successfully. Migrated: 2021_01_108976_create_cards_table

    hope this will help someone.

Related Q&A May You Like

  1. How check if the variable is a number or not in javascript?
  2. How to center text of <p> tag html using CSS?
  3. How to get client ip address in asp.net core using c#?
  4. [Resolved] String cannot be of zero length. Parameter name: oldValue
  5. Error: Unable to resolve module "react-native-gesture-handler"
  6. Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
  7. Operator '!' cannot be applied to operand of type '<null>' in Asp.Net Core
  8. Uncaught TypeError: Cannot read property 'createElement' of undefined in ReactJs
  9. How to random number generator 1-100 in Python?
  10. ValueError: Input contains NaN, infinity or a value too large for dtype('float64') in Python
  11. TypeError: 'list' object cannot be interpreted as an integer in Python
  12. PHP Fatal error: Allowed memory size of 134217728 bytes exhausted
  13. ImportError: No module named MySQLdb in Python Django
  14. Exception throw referencerrror: fs is not defined in NodeJs
  15. What is best way to convert datetime to date in Sql Server?
Leave An Answer
* NOTE: You need Login before leave an answer

* Type maximum 2000 characters.

* All comments have to wait approved before display.

* Please polite comment and respect questions and answers of others.

Most Quizs Popular

Start Test

Javascript - Functions
Start Test

Asp.Net Core - Exam test 01
Start Test

Asp.Net Core - Exam test 02
Start Test

C# - Level Beginner

Popular Tips

This site uses cookies so that we can remember you and understand how you interact with our website. This allows us to improve and customize your browsing experience. See our Cookies Policy.
X Close