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:

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

 

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 Redirect Another Page Using Javascript
How To Redirect Another Page U...

In this article, we will see how to redirect another page using javascript. we will redirect the page to another pa...

Read More

Nov-04-2022

How To Get Children Element In jQuery
How To Get Children Element In...

In this article, we will see how to get the children of this selector in jquery. You can use the find() method...

Read More

Jul-13-2022

Laravel 9 Generate PDF From HTML Using TCPDF
Laravel 9 Generate PDF From HT...

In this article, we will see laravel 9 generate PDF from HTML using TCPDF. Here, we will learn how to integrate tcpdf in...

Read More

Jan-31-2023

Laravel 9 Resize Image Before Upload
Laravel 9 Resize Image Before...

In this article, we will see how to resize image before uploading in laravel 9. we will install the intervention/im...

Read More

Jun-15-2022