PHP Fatal error: Uncaught PDOException: could not find driver

Question

I have been trying to connect to MySQL from PHP using PDO. However, I get this error message:

PHP Fatal error: Uncaught PDOException: could not find driver in /home/abdullah/Documents/projects/cs50_radio/public/test.php:5 Stack trace: #0 /home/abdullah/Documents/projects/cs50_radio/public/test.php(5): PDO->__construct('mysql:host=127....')

PDO is enabled and installed. I checked phpinfo(), but I can't figure out the error.

Here is my code used to connect:

<?php
    $user = "root";
    $pass = "root";

    $dbh = new PDO("mysql:host=127.0.0.1;dbname=radio;port=3306", $user, $pass);
    //$dbh->query('INSERT INTO users (name) VALUES ("abdullah")');
    $dbh = null;
?>

Should my project folder contain any additional drivers or files? Or am I missing something in my code?

new PDO("mysql:host=127.0.0.1;dbname=radio", $user, $pass); — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Nov 27, 2016 at 9:21
Hi, are you sure the mysql driver is loaded ? Can you check in your php.ini ? The driver line must be uncommented — Max
– Max, Commented Nov 27, 2016 at 9:24
You should have extension=php_pdo_mysql.dll and not ;extension=php_pdo_mysql.dll (no semi colon) — Max
– Max, Commented Nov 27, 2016 at 9:38

V. Bozz · Accepted Answer · 2022-06-30 09:58:04Z

18

To use different drivers you need to install them.

On Windows you simply uncomment a line in php.ini:

extension=php_pdo_mysql.dll

On Debian or similar Linux distribution you can just install the extension with the package manager:

sudo apt update
sudo apt install php7.1-mysql

Remember to install the correct version.

edited Jun 30, 2022 at 9:58

V. Bozz

1,6321 gold badge23 silver badges42 bronze badges

answered Nov 27, 2016 at 9:54

VeeeneX

1,57618 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

A.Emad Over a year ago

Reading package lists... Done Building dependency tree Reading state information... Done php5-mysql is already the newest version. php5-mysql set to manually installed. 0 upgraded, 0 newly installed, 0 to remove and 95 not upgraded.

flapjack · Accepted Answer · 2018-05-27 01:29:20Z

6

I had the same problem, resulting from some incompatibility (not immediately evident) between the Apache and PHP versions I had downloaded. Try writing a toy PHP script that simply creates a new PDO object, - something like:

<?php

$dbname   = 'mydb';
$username = 'myuser';
$password = 'mypassword';
try {
    $pdo = new \PDO("mysql:host=localhost;dbname=$dbname", $username,  $password);
} catch (Exception $e) {
    print $e->getMessage() . "\n";
}
print "OK\n";

Then run that script from the command line. If you don't get the 'could not find driver' error message, then that points to an incompatibility between your PHP and Apache versions.

answered May 27, 2018 at 1:29

flapjack

871 silver badge5 bronze badges

Comments

Abdulwehab · Accepted Answer · 2022-01-10 09:20:51Z

6

In my PHP 7.4 I didn't get php.ini. Instead, I have php.ini-development and php.ini-production. So, I have created a new php.ini file only and copied the configurations into it.

Then I have uncommented and changed the extension directory to the full installation path.

 extension_dir = "C:/php/ext"

And uncommented:

 extension=pdo_mysql

Finally, restart the server.

edited Jan 10, 2022 at 9:20

answered Dec 13, 2019 at 7:58

Abdulwehab

1,4382 gold badges13 silver badges16 bronze badges

1 Comment

Marcel Over a year ago

I just wanted to point out here that it is important to restart your PHP server after uncommenting extension=pdp_mysql so as to allow the changes to take effect.

Peter Mortensen · Accepted Answer · 2020-04-21 03:12:24Z

0

Ok, somehow I had a problem with the extension itself. It helped to reinstall the MySQL extension. Here an example for PHP 7.3:

sudo apt purge php7.3-mysql
sudo apt install php7.3-mysql
sudo service apache2 restart

edited Apr 21, 2020 at 3:12

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Feb 23, 2020 at 21:14

Sebastian Rahmel

11

1 Comment

TizonDife Villiard Over a year ago

The third line help me after doing sudo apt install php7.1-mysql

Collectives™ on Stack Overflow

PHP Fatal error: Uncaught PDOException: could not find driver

4 Answers 4

1 Comment

Comments

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related