Php – PDOException “could not find driver”

lampMySQLpdoPHP

I have just installed Debian Lenny with Apache, MySQL, and PHP and I am receiving a PDOException could not find driver.

This is the specific line of code it is referring to:

$dbh = new PDO('mysql:host=' . DB_HOST . ';dbname=' . DB_NAME, DB_USER, DB_PASS)

DB_HOST, DB_NAME, DB_USER, and DB_PASS are constants that I have defined. It works fine on the production server (and on my previous Ubuntu Server setup).

Is this something to do with my PHP installation?

Searching the internet has not helped, all I get is experts-exchange and examples, but no solutions.

Best Answer

You need to have a module called pdo_mysql. Looking for following in phpinfo(),

pdo_mysql

PDO Driver for MySQL, client library version => 5.1.44

Related Solutions

Php – Fatal error: Uncaught exception ‘PDOException’ with message ‘could not find driver’

If you are trying to connect to MySQL, use the MySQL connection string:

$database = new PDO('mysql:host=localhost;dbname=test', "admin", "root");

The dblib driver you are using is for Microsoft SQL and Sybase. If you are using XAMPP, chances are you are using MySQL not Microsoft SQL. If you are using Microsoft SQL, you will need to download and install it: http://www.php.net/manual/en/ref.pdo-dblib.php

Php – Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)

As an alternative solution be sure you have installed php7-mysql

try to run command below

sudo apt install php7.0-mysql

or, if you want to automatically install the current version

sudo apt install php-mysql

Best Answer

Related Solutions

Php – Fatal error: Uncaught exception ‘PDOException’ with message ‘could not find driver’

Php – Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)

Related Topic