Why Is PHPMyAdmin Showing a \'Missing mysqli Extension\' Error Despite Installation?

PHPMyAdmin Error: Missing mysqli Extension

Despite installing Apache2, PHP5, MySQL, and PHPMyAdmin, users may encounter an error stating that the mysqli extension is missing and PHPMyAdmin is not working.

Reason:

Recent PHPMyAdmin versions require the mysqli extension, which replaces the older mysql extension.

Solution:

For PHP 7.3 and PHP 8:

1. Install the mysqli extension package:

   • PHP 7.3: sudo apt-get install php7.3-mysqli
   • PHP 8: sudo apt-get install php8.0-mysqli
2. Add extension=mysqli.so to the Dynamic Extensions section of your php.ini file.
3. Restart Apache: sudo systemctl restart apache2
4. Authenticate in the browser and press Enter.

Note that the installed package includes both the old mysql and the new mysqli extensions. The addition of the mysqli.so extension in php.ini activates the new extension. If the issue persists, clear the browser cache.

The above is the detailed content of Why Is PHPMyAdmin Showing a \'Missing mysqli Extension\' Error Despite Installation?. For more information, please follow other related articles on the PHP Chinese website!