Error in phpmyadmin - `mysqli extension is missing`
If you change some configuration and haven't remove it in reinstall, then didn't help. Follow this command to clear old configs:
sudo apt purge php7.2-* phpmyadmin
After removed, reinstall packages:
sudo apt install apache2 php7.2 php7.2-mysql # Add other dependent if you need ...
Now, mysqli
should exists in /etc/php/7.2/mods-available/20-mysqli.ini
:
$ cat /etc/php/7.2/mods-available/mysqli.ini
; configuration for php mysql module
; priority=20
extension=mysqli.so
If you using FPM
, should have a soft link in /etc/php/7.2/fpm/conf.d/20-mysqli.ini
The mysqli extension is missing. Please check your PHP configuration , even though file is available in defined path
In your php.ini file set the extension_dir
to C:/Program Files (x86)/php/ext
then change the extension values to simply the name of the extension.
extension_dir = "C:/Program Files (x86)/php/ext"
extension=php_curl.dll
extension=php_gd2.dll
extension=php_intl.dll
extension=php_mbstring.dll
extension=php_mysqli.dll
extension=php_openssl.dll
extension=php_soap.dll
extension=php_xmlrpc.dll
The mysqli extension is missing. Please check your PHP configuration, Windows 7
Please make sure the extension=mysqli.dll
isn't commented out into php.ini.
Also make sure that you have the mysqli.dll
files exist inside the extensions folder of your php installation.
Extension mysqli is missing, phpmyadmin doesn't work
Latest phpMyAdmin versions require mysqli extension and will no longer work with mysql one (note the extra "i" at the end of its name).
For PHP 7.3
sudo apt-get install php7.3-mysqli
For PHP 8
sudo apt-get install php8.0-mysqli
Will install package containing both old one and the new one, so afterwards all you need to do is to add
extension=mysqli.so
in your php.ini, under the subject Dynamic Extensions.
Restart apache:
sudo systemctl restart apache2
Authenticate if needed and press enter.
Should be done! If problem still occurs remove the browser cache.
Related Topics
Round Minute Down to Nearest Quarter Hour
Override Method Parameter With Child Interface as a New Parameter
How to List All Months Between Two Dates
Fetching Data from MySQL Database to HTML Dropdown List
How to Re-Index All Subarray Elements of a Multidimensional Array
PHP Buffer Ob_Flush() Vs. Flush()
Reliable User Browser Detection With PHP
PHP List All Files in Directory
Get Response from PHP File Using Ajax
Best Way to Test For a Variable'S Existence in PHP; Isset() Is Clearly Broken
How to Rely on PHP PHP.Ini Precision Workaround For Floating Point Issue