Mysqli extension missing, phpmyadmin not working

Question

I have a problem with phpmyadmin on ubuntu 12.04. I already installed apache2, php5, mysql and phpmyadmin.

phpinfo(); script, show nothing about the mysqli or mysql extension.

When I try to run phpmyadmin, the following error will appear:

 ----
 ** phpMyAdmin - Error **
 -------
 ** The mysqli extension is missing.  Please check your PHP configuration. **
 ----

In the php.ini file, I uncommented the extension=mysql.so , but it doesn’t work ...

Does anyone have another possible solution?

Answer 1

In recent versions of phpMyAdmin, the mysqli extension is required and will no longer work with mysql one (note the extra "i" at the end of its name).

 sudo apt-get install php5-mysql 

A package will be installed containing both the old and the new, so after that all you have to do is add

 extension=mysqli.so 

in php.ini, restart apache and it should work.

Answer 2

 sudo apt-get install php5-mysql sudo apt-get install php5-mysqlnd 

try both options, it works for me

Answer 3

If you run PHPMyAdmin on localhost uncomment in the /etc/php5/apache2/php.ini file, this line:

 mysqli.allow_local_infile = On 

Restart Apache:

 sudo /etc/init.d/apache2 restart 

Answer 4

Just restart apache2 and mysql:

• apache2: sudo /etc/init.d/apache2 restart

• mysql: sudo /etc/init.d/mysql restart

then refresh your browser, enjoy phpmyadmin :)

Answer 5

I tried a lot of answers and none of them worked because php7.0 is not standard.

 sudo apt-get upgrade 

seemed to do the job for me, but I had to reinstall php7.0 and phpmyadmin after that:

 sudo apt-get install php7.0 php7.0-mysql sudo apt-get install apache2 apache2-mod-php7.0 sudo apt-get install phpmyadmin 

Hope this helps!

Answer 6

I solved this problem by editing /usr/local/zend/etc/php.ini.

(found it by running netstat -nlp | grep apache, then strace -p somepid | grep php.ini).

At the end of the file, I added:

 extension=/usr/lib/php5/20090626+lfs/mysql.so extension=/usr/lib/php5/20090626+lfs/mysqli.so extension=/usr/lib/php5/20090626+lfs/mcrypt.so 

Adding it without a path does not work.

Then, after a reboot, it worked.

Answer 7

This worked for me, create a database with php and mysql script and open the mysql console and enter the username 'yourName'@'127.0.0.1' and then enter all the privileges. to 'yourName'@'127.0.0.1', then open a browser, go to localhost and create a database, and then go to the phpmyadmin page and you will see that it appears there.

Answer 8

on ubuntu 12.04 I had to change mssql.compatability_mode = On . put and work

Answer 9

For a Ubuntu user, open your terminal and enter the following command

 sudo apt-get install mysql 

After that, just restart apache2 by typing

 sudo service apache2 restart 

refresh your browser and enjoy phhmyadmin

Answer 10

Since I had this problem after the upgrade, I just disabled Apache2-php5

 a2dismod php5 

and activated php7

 a2enmod php7 

Hope this can help someone!

Answer 11

Just add this line to your php.ini if ​​you are using XAMPP, etc. Also check if it is already there, just delete; from the front

 extension= php_mysqli.dll 

and stop and start apache and MySQL, this will work.

Answer 12

Testing extension_dir is one of those things you would like to test from phpinfo (). In my case, it was extension_dir = "./" by default, which was wrong. Change it to extension_dir = './ext/' or where all your DLL extensions are currently located.

Answer 13

THIS WORKS 100%

open php configuration file using notepad, find line: -

 ;extension=mysqli.dll 

change it to

 extension=mysqli.dll 

deleting ';'

save

then restart the Apache server, it worked for me on win xp