Pdo php ошибка could not find driver

asked May 17, 2010 at 20:57

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

answered May 17, 2010 at 21:33

The dsn in your code reveals you are trying to connect with the mysql driver. Your error message indicates that this driver is unavailable.

Check that you have the mysql extension installed on your server.

In Ubuntu/Debian you check for the package with:

dpkg --get-selections | grep php | grep mysql

Install the php5-mysql package if you do not have it.

In Ubuntu/Debian you can use:

• PHP5: sudo apt-get install php5-mysql
• PHP7: sudo apt-get install php7.0-mysql

Lastly, to get it working, you will need to restart your web-server:

• Apache: sudo /etc/init.d/apache2 restart
• Nginx: sudo /etc/init.d/nginx restart

answered Nov 10, 2011 at 5:21

Update: newer versions should use php-sqlite3 package instead of php5-sqlite. So use this, if you are using a recent ubuntu version:

sudo apt-get install sqlite php-sqlite3

Original answer to question is here:

sudo apt-get install sqlite php5-sqlite
sudo /etc/init.d/apache2 restart

If your phpinfo() is not showing the pdo_sqlite line (in my case, on my Ubuntu Server), you just need to run the lines above and then you’ll be good to go.

answered Aug 27, 2010 at 18:39

For newer versions of Ubuntu that have PHP 7.0 you can get the php-mysql package:

sudo apt-get install php-mysql

Then restart your server:

sudo service apache2 restart

answered Aug 19, 2016 at 6:28

I had the same issue. The solution depends on OS. In my case, i have debian, so to solve it:

• Updated my php version from (php5 to php7)

• Install php-mysql and php7.0-mysql

  apt-get install php-mysql
  apt-get install php7.0-mysql
  

• I edited my php.ini locate at /etc/php/7.0/apache2/php.ini

  uncomment the line : extension=php_pdo_mysql.dll
  

• Then restart apache:

  service apache2 restart
  

This solves my problem

On my Windows machine, I had to give the absolute path to the extension dir in my php.ini:

extension_dir = "c:php5ext"

PratikPratik

9591 gold badge14 silver badges20 bronze badges

On Ubuntu just execute

sudo apt-get install php5-mysql

answered Apr 16, 2013 at 13:22

sudo apt-get install php-mysql 

worked well on ubuntu and php 7

answered May 12, 2016 at 9:11

When adding these into your php.ini ensure the php_pdo.dll reference is first before the db drivers dlls otherwise this will also cause this error message too. Add them like this:

[PHP_PDO]
extension=php_pdo.dll
[PHP_PDO_MYSQL]
extension=php_pdo_mysql.dll

answered May 17, 2010 at 21:08

SimonWSimonW

6,1254 gold badges32 silver badges39 bronze badges

I had the same problem during running tests with separate php.ini. I had to add these lines to my own php.ini file:

[PHP]
extension = mysqlnd.so
extension = pdo.so
extension = pdo_mysql.so

Notice: Exactly in this order

answered Jul 23, 2016 at 15:04

hsergehserge

9051 gold badge9 silver badges12 bronze badges

answered Jun 21, 2012 at 16:38

RealSollyMRealSollyM

1,5201 gold badge22 silver badges35 bronze badges

MSSMSS

3,49224 silver badges29 bronze badges

BalmipourBalmipour

2,9851 gold badge24 silver badges27 bronze badges

SamTzuSamTzu

1671 silver badge7 bronze badges

I Fixed this issue on my Debian 6.
Normally I just had installed php5-common package. After installation, you have to restart your web server (apache or nginx depending on which one you installed).
Then I just do an lsof on the apache process id (lsof -p process_id) as followed :

sudo lsof -p 1399   #replace 1399 by your apache process id
apache2 1399 root  mem    REG  254,2    80352 227236 /usr/lib/php5/20090626/xmlrpc.so
apache2 1399 root  mem    REG  254,2   166496 227235 /usr/lib/php5/20090626/suhosin.so
apache2 1399 root  mem    REG  254,2    31120 227233 /usr/lib/php5/20090626/pdo_mysql.so
apache2 1399 root  mem    REG  254,2   100776 227216 /usr/lib/php5/20090626/pdo.so
apache2 1399 root  mem    REG  254,2   135864 227232 /usr/lib/php5/20090626/mysqli.so

As you can see above, the modules are installed on a file path not known or guided by common library path: /usr/lib/php5/20090626/. For your installation, it may be different, but only the path of pdo_mysql.so, pdo.so, mysqli.so. So, this is why Drupal or any other php engine couldn’t find the library and shows that error: PDOException: could not find driver

I just don’t know why it is installed on such a weird path, for me it’s just a bug in the library package installation script in debian 6.
I solved the issue by creating a symbolic for all the files under /usr/lib/php5/20090626/ to
/usr/lib/php5/ with this command :

ln -s /usr/lib/php5/20090626/* /usr/lib/php5/

$DB_TYPE = 'mysql'; //Type of database<br>
$DB_HOST = 'localhost'; //Host name<br>
$DB_USER = 'root'; //Host Username<br>
$DB_PASS = ''; //Host Password<br>
$DB_NAME = 'database_name'; //Database name<br><br>

$dbh = new PDO("$DB_TYPE:host=$DB_HOST; dbname=$DB_NAME;", $DB_USER, $DB_PASS); // PDO Connection

This worked for me.

RoshimonRoshimon

1,98119 silver badges16 bronze badges

answered Jun 29, 2016 at 3:49

aneth101aneth101

5095 silver badges9 bronze badges

papillonpapillon

1,7572 gold badges18 silver badges36 bronze badges

AdamAdam

25.4k22 gold badges152 silver badges239 bronze badges

In Ubuntu, write in the console

sudo apt-get install php5-gd php5-mysql

and it will work

answered Feb 19, 2015 at 10:00

Hope you are running your project in localhost. In your project folder app/config a file named parameters.ini , Make sure that your Mysql database connection cofiguration is correct. If you are using mysql See database_driver=pdo_mysql is its driver.

Below is an example.

database_driver   = pdo_mysql
    database_host     = localhost
    database_port     =
    database_name     = databasename
    database_user     = msqlusername
    database_password = mysqlpassword//if not make blank

    mailer_transport  = smtp
    mailer_host       = localhost
    mailer_user       =
    mailer_password   =

    locale            = en

    secret            = ThisTokenIsNotSoSecretChangeIt

Hope it helps you.

You need to have a module called pdo_mysql.

Look for the following in phpinfo() output,

pdo_mysql => PDO Driver for MySQL, client library version => 5.1.44

to install pdo_mysql you need to do this:

 pecl install pdo
 pecl install pdo_mysql

and then add the following to your php.ini file:

extension=pdo.so
extension=pdo_mysql.so

answered Feb 26, 2016 at 19:52

if you are using XAMPP then in php.ini file line no 897(depends on version),

;extension=php_pdo_pgsql.dll 

uncomment it , then it appears like below

extension=php_pdo_pgsql.dll 

in php.ini file line no 897, then restart XAMPP.

answered Jun 24, 2016 at 6:46

There are two PHP versions installed in my server PHP 5.6 and PHP 7

When I run the command php app/console doctrine:schema:update I have the error : [PDOException] could not find driver

I resolve this error by specifying the PHP version:

php5.6 app/console doctrine:schema:update

answered Nov 16, 2017 at 23:29

Looks like your install is missing the .so files it needs to implement the mysql connection. If you’re using a package management system to install PHP then make sure you’ve installed all the necessary submodules (in this case I think you’ll need mysql-dev, and the various PHP PDO modules), though such dependencies should have been resolved for you by the package manager.

If you didn’t go through a package manager, then you’ll have to compile the required .so files from source.

answered Feb 16, 2012 at 9:01

AliRNazariAliRNazari

98417 silver badges28 bronze badges

Adding to Jaspreet Chahal’s answer.
When installing PDO as a shared module, the php.ini file needs to be updated so that the PDO extension will be loaded automatically when PHP runs. You will also need to enable any database specific drivers there too; make sure that they are listed after the pdo.so line, as PDO must be initialized before the database-specific extensions can be loaded. If you built PDO and the database-specific extensions statically, you can skip this step(Source).

What I mean is, it should look something like this —