MySQLi Error while Accessing phpMyadmin

Certain phpMyadmin options (such as the routines function) display an error related to the built-in MySQLi support, making it impossible to use features like Routines as intended.The deprecated’mysql’ extension for PHP that you are using is unable to handle multiple queries.Certain saved routines may not run correctly!To prevent issues, please use the updated “mysqli” extension.

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.