How to Install PHP PDO MySQL Extension in Ubuntu 22.04

Hey there! If you're diving into PHP development on Ubuntu 22.04 and need to connect your applications to MySQL databases, you're in the right place. In this step-by-step guide, I'll walk you through installing the PHP PDO MySQL extension on your Ubuntu 22.04 system.

PHP PDO (PHP Data Objects) provides a consistent interface for accessing databases, and MySQL is one of the most popular database management systems out there.

By installing the PDO MySQL extension, you'll be able to seamlessly interact with MySQL databases from your PHP applications.

Also, you can install the PHP pdo_mysql extension in Ubuntu 16.04, ubuntu 18.04, and ubuntu 20.04.

So, let's see how to install the PHP PDO MySQL extension in Ubuntu 22.04, install the PHP extension in Ubuntu 20.04, how to install the PDO php extension in Ubuntu, and how to install the PDO MySQL extension.

First, I'll make sure my package lists are up-to-date by running the following command in the terminal:

sudo apt update

This extension allows PHP to communicate with MySQL databases using the PDO (PHP Data Objects) interface:

sudo apt install php-mysql

For PHP 8.3

sudo apt-get install php8.3-mysql

For PHP 8.2

sudo apt-get install php8.2-mysql

For PHP 8.1

sudo apt-get install php8.1-mysql

For PHP 8.0

sudo apt-get install php8.0-mysql

For PHP 7.4

sudo apt-get install php7.4-mysql

After installing, restart the Apache server using the following command.

sudo service apache2 restart

To confirm that the PDO MySQL extension has been successfully installed, I'll create a PHP script to check for its presence. I'll create a new file named check_pdo_mysql.php using a text editor such as Nano or Vim:

nano check_pdo_mysql.php

Inside the file, I'll add the following PHP code:

<?php
if (extension_loaded('pdo_mysql')) {
    echo "PDO MySQL extension is installed.\n";
} else {
    echo "PDO MySQL extension is not installed.\n";
}
?>

I'll save the file and exit the text editor.

Now, I'll run the PHP script to verify the installation of the PDO MySQL extension. I'll navigate to the directory containing the script in the terminal and execute the following command:

php check_pdo_mysql.php

If the PDO MySQL extension is installed correctly, I should see the message "PDO MySQL extension is installed.

That's it! I've successfully installed the PHP PDO MySQL extension on my Ubuntu 22.04 system.

You might also like:

• Read Also: How to Format Number with 2 Decimal in PHP
• Read Also: How to Install PHP JSON Extension in Ubuntu 23.04
• Read Also: How to Downgrade PHP 8.2 to 8.1 in Ubuntu
• Read Also: How To Install php-bcmath In Ubuntu