cPanel & WHM Version 98 has been released, and brings a slew of great updates. Take a look at what is included, and then upgrade today!
This object is in archive! 

MySQLi Support for phpMyAdmin

Chris Bachman shared this idea 8 years ago
Completed

Some parts of PHPMyAdmin complain about not having 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.

Best Answer
photo

In cPanel & WHM version 11.40 we enabled the mysqli extension for phpMyAdmin.

Replies (3)

photo
2

MySQLi support is already compiled-into the cPanel-RPM-provided PHP binaries of both cPanel&WHM 11.36 and 11.38.

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

photo
2

Try modifying the following phpMyAdmin configuration entry to use mysqli:

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

photo
1

In cPanel & WHM version 11.40 we enabled the mysqli extension for phpMyAdmin.

Replies have been locked on this page!