Knowledge Base
MilesWeb / cPanel, Dedicated Server FAQ, VPS FAQ, Web Hosting FAQ

MySQLi Error while Accessing phpMyadmin

Approx. read time : 2 min

Some options from phpMyadmin (like routines function) show an error of MySQLi support built in and cannot use features such as Routines as expected.

You are using PHP’s deprecated ‘mysql’ extension, which is not capable of handling multi queries. The execution of some stored routines may fail! Please use the improved ‘mysqli’ extension to avoid any problems.

MySQLi should be compiled on the server & use command below if it is.

# /usr/local/cpanel/3rdparty/bin/php -m | grep -i MySQLi
mysqli

If it does not returns the output above you will have to re compile php on the server with MySQLi.

Even if MySQLi is compiled, you receive the error. A small modification will allow phpMyadmin to use MySQLi.

# grep sql /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php
/* Select mysql if your server does not have mysqli */
$cfg[‘Servers’][$i][‘extension’] = ‘mysql’;

Replace mysql with mysqli in phpMyAdmin configuration.

Admin
With over 10+ years of experience in the web hosting industry, I have achieved extensive exposure to result-oriented methodologies. And expertise in different domains like Datacentre Services, Cloud computing technology, Web hosting industry and many more.