MySQLi Error while Accessing phpMyadmin

Introduction

Some of the options from phpMyadmin show an error of MySQLi support built in and cannot use features like routines.

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

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

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

mysqli

If it does not return 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.