How to Resolve Missing mysqli Extension in PHPMyAdmin on Ubuntu 12.04?

Dealing with Missing mysqli Extension in PHPMyAdmin on Ubuntu 12.04

The absence of the mysqli extension can cause issues when attempting to utilize PHPMyAdmin. Here's how to resolve this problem effectively:

Understanding the Issue

Recent iterations of PHPMyAdmin no longer support the mysql extension and require mysqli instead. This is denoted by the presence of an extra "i" at the end of the extension name.

Installing the Required Extension

For PHP 7.3:

<code class="bash">sudo apt-get install php7.3-mysqli</code>

For PHP 8:

<code class="bash">sudo apt-get install php8.0-mysqli</code>

The installation will include both the old mysql extension and the new mysqli one.

Adding the Extension to php.ini

Locate your php.ini file and add the following line to the Dynamic Extensions section:

extension=mysqli.so

Restarting Apache

<code class="bash">sudo systemctl restart apache2</code>

Cache Invalidation

Clear your browser's cache to ensure that it doesn't retrieve old cached information.

Authentication

If prompted, enter your password to authenticate and press Enter. The issue should now be resolved.

The above is the detailed content of How to Resolve Missing mysqli Extension in PHPMyAdmin on Ubuntu 12.04?. For more information, please follow other related articles on the PHP Chinese website!