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.
