Extension Mysqli Is Missing, Phpmyadmin Doesn't Work

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.

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

phpmyadmin dosen't work in Windows Server, extension mysqli is missing

Check for the following config for extensions in php.ini file

extension=bz2
extension=curl
extension=fileinfo
extension=gd2
extension=gettext
;extension=gmp
;extension=intl
;extension=imap
;extension=interbase
;extension=ldap
extension=mbstring
extension=exif      ; Must be after mbstring as it depends on it
extension=mysqli
;extension=oci8_12c  ; Use with Oracle Database 12c Instant Client
;extension=odbc
;extension=openssl
;extension=pdo_firebird
extension=pdo_mysql
;extension=pdo_oci
;extension=pdo_odbc
;extension=pdo_pgsql
extension=pdo_sqlite
;extension=pgsql
;extension=shmop
;extension=php_gd2.dll

---

Related Topics