Home / ubuntu / Questions / 1031395
In Process
govind
Asked: 2018-05-03 22:29:05 +0800 CST

phpmyadmin showing error regarding mysqli, but its already installed

  • 772

first screen shot of error showing phpmyadmin error

enter image description here

second screen shot after using sudo with mysqli

enter image description here

mysql phpmyadmin 14.04

2 Answers

  1. Check if the PHP MySQL module is actually there:

    php -m | grep mysqli

    If the above command returns nothing probably something goes wrong during the installation of the MySQL module. So you can try to reinstall it:

    sudo apt-get install --reinstall php-mysql

    Then restart the web server, flush your browser's cache and reload the page.

    The PHP modules are enabled through .ini files located in /etc/php/<php.version>/mods-available and their binaries are located in /usr/lib/php, here is example output from my system:

    $ cat /etc/php/7.0/mods-available/mysqli.ini 
; configuration for php mysql module
; priority=20
extension=mysqli.so

$ sudo find /usr/lib/php -type f -name 'mysqli.so'
/usr/lib/php/20151012/mysqli.so
    • 0

  2. Make sure you have mysqli extension. You may open a terminal and run this command:

    $ sudo apt-get install php7.2-mysqli

    After that, make sure the extension is enabled. You will have to check your php.ini location. Probably is located here:

    /etc/php/7.2/cli/php.ini

    Edit the ini file and look for mysqli. Uncomment the line by removing ; 

    extension=mysqli.so

    After all that you will have to restart apache service by executing:

    $ sudo service apache2 restart

    And reload PhpMyAdmin Page. You may also need to install some other extensions like mbstring.

    I hope this might help you.

    • 0