Extension mysqli is missing, phpmyadmin doesn't work

Question

I am having a problem with phpmyadmin on ubuntu 12.04 operating system. I had already installed apache2, php5, mysql and phpmyadmin.

The phpinfo(); script, doesn't show anything about mysqli or mysql extension.

When I am trying to start the phpmyadmin this below error appears:

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

In the php.ini file, I uncommented extension=mysql.so line, but even then it doesn't work.

Anyone have any other possible solution? 

Answer 1

The latest phpMyAdmin versions require mysqli extension and it will no longer be working with mysql one (note the extra "i" at the end of its name).

For PHP 5

sudo apt-get install php5-mysqli

For PHP 7.3

sudo apt-get install php7.3-mysqli

The install package containing both the 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 and press enter.

Should be done! If the problem still occurs remove the browser cache.

If you want to learn more about SQL, Check out this SQL Certification by Intellipaat.