phpMyAdmin - Error The mysqli extension is missing. Please check your PHP configuration. See our documentation for more information.

Steps to Enable MySQLi Extension

Update Package Lists:

Before proceeding, ensure your package lists are up to date:

sudo apt-get update

Install MySQLi Extension:

Install the MySQLi PHP extension if it's not already installed:

sudo apt-get install php-mysqli

Restart Apache:

After installing the extension, restart Apache to apply the changes:

sudo systemctl restart apache2

Verify MySQLi Extension:

You can verify if the MySQLi extension is enabled by creating a PHP file in your web server's root directory (/var/www/html by default) with the following content:

php

<?php

phpinfo();

?>

Save the file (e.g., info.php) and access it through your web browser (e.g., http://your-ec2-instance-public-dns/info.php). Look for a section named "mysqli" in the PHP info page to confirm that the extension is enabled.

Configure phpMyAdmin:

If you still encounter issues after enabling the MySQLi extension, you may need to reconfigure phpMyAdmin to recognize the extension. Use the following command to reconfigure phpMyAdmin:

sudo dpkg-reconfigure phpmyadmin

Follow the prompts and ensure that during the configuration, the MySQLi extension is selected and enabled.