mysql - 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?

Answer 1

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 Linux you install the extension with the package manager:

sudo apt install php7.1-mysql