Our features site is undergoing a refresh! Be sure to explore the revamped site and discover our latest product roadmap launching here on Monday, March 18th.
This object is in archive! 

MySQLi Support for phpMyAdmin

Chris Bachman shared this idea 11 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!