Knowledge Base Hub

Browse through our helpful how-to guides to get the fastest solutions to your technical issues.

Home  >  cPanel  >  MySQLi Error while Accessing phpMyadmin
Top Scroll

MySQLi Error while Accessing phpMyadmin

 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

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/
/* Select mysql if your server does not have mysqli */
$cfg[‘Servers’][$i][‘extension’] = ‘mysql’;

Replace mysql with mysqli in phpMyAdmin configuration.

For our Knowledge Base visitors only
Get 10% OFF on Hosting
Special Offer!
Claim the discount before it’s too late. Use the coupon code:
Note: Copy the coupon code and apply it on checkout.