How to Install PHP PDO MySQL Extension in Ubuntu 22.04

Websolutionstuff | Feb-28-2024 | Categories : PHP

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.

Update Package Lists:

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

sudo apt update


Install PDO MySQL Extension:

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


Restart Apache Server:

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

sudo service apache2 restart


Verify Installation:

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:

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.


Run the PHP Script:

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:

Recommended Post
Featured Post
How to Filter Datatable using Dropdown in Laravel 10
How to Filter Datatable using...

Hello developers! 👋 Ever found yourself dealing with a DataTable in Laravel and wished for a nifty way to filter th...

Read More


Autocomplete Search from Database in Laravel 11
Autocomplete Search from Datab...

Hello, laravel web developers! In this article, we'll see how to autocomplete a search from a database in larav...

Read More


Vue Js Get Array Of Length Or Object Length
Vue Js Get Array Of Length Or...

In this tutorial, we will see you example of vue js get an array of length or object length. we will learn about vu...

Read More


How to Image Upload with Preview in Angular 17
How to Image Upload with Previ...

In this article, we'll see how to image upload with a preview in angular 17. Here, we'll learn about the an...

Read More