How to enable MySQLi extension on web-server

How to enable MySQLi? Before going to enable it on the server, I will share some ideas about MySQLi. Then, I should explain how we can enable MySQLi on a cpanel server and How we can check if MySQLi is already enabled or not in the server.

What is MySQLi?

Simply it’s a MySQL extension for PHP programming language. The MySQLi Extension (MySQL Improved) is a relational database driver used in the PHP programming language to provide an interface with MySQL databases.

The developers of the PHP programming language recommend using MySQLi when dealing with MySQL server versions 4.1.3 and newer (takes advantage of new functionality). The MySQLi extension has a lot of benefits, some of them are listed below:

  • An object-oriented interface
  • Support for prepared statements
  • Support for multiple statements
  • Support for transactions
  • Enhanced debugging support
  • Embedded server support
  • Powerful Functionality

How to check the MySQLi extension is enabled or not on server?

You can check the MySQLi extension from command line itself by executing the following command.

# php -m | grep mysql

how to enable MySQLi extension on web-server with cPanel?

EasyApache 3

We can simply enable the MySQLi extension by rebuilding the web-server with Easyapache script. It is very simple, just run the below pasted scripts from the command line as root user, and select the MySQLi from the extension list. See the attached image for more details:

# /scripts/easyapache 
How to enable MySQLi
How to enable MySQLi

EasyApache 4

You can directly enable it from the WHM panel. Please do the following steps to enable it.

Step 1 : Log into WHM panel.

Step 2 : Go to Home » Software » EasyApache 4

Step 3 : Click on “Customize

How to enable MySQLi
How to enable MySQLi

Step 4 : Go to PHP Extensions

How to enable MySQLi
How to enable MySQLi

Accessing PhpMyAdmin without cPanel login?

This article will help you to access databases of cPanel users’ without accessing the cPanel account.

Consider the scenario, you’ve a cPanel account and you want to share the details of a database (DB) with one of your we site developers and actually you do not want to share the cPanel credentials.

In EasyApache 4, the mysqli extension is provided by the mysqlnd package. To illustrate this, here is a list of the files that are provided by the ea-php55-php-mysqlnd package.

# rpm -ql ea-php55-php-mysqlnd
/opt/cpanel/ea-php55/root/etc/php.d/mysqlnd.ini
/opt/cpanel/ea-php55/root/etc/php.d/mysqlnd_mysql.ini
/opt/cpanel/ea-php55/root/etc/php.d/mysqlnd_mysqli.ini
/opt/cpanel/ea-php55/root/etc/php.d/pdo_mysqlnd.ini
/opt/cpanel/ea-php55/root/usr/lib64/php/modules/mysqlnd.so
/opt/cpanel/ea-php55/root/usr/lib64/php/modules/mysqlnd_mysql.so
/opt/cpanel/ea-php55/root/usr/lib64/php/modules/mysqlnd_mysqli.so
/opt/cpanel/ea-php55/root/usr/lib64/php/modules/pdo_mysqlnd.so

how to enable MySQLi extension on web-server without cPanel?

In a server without cPanel, you need to compile the MySQL with the MySQLi extension.

# ./configure --with-mysql=/usr --with-mysqli=/usr/bin/mysql_config

How to check the MySQLi extension is enabled on server?

# php -m|grep mysql
mysql
mysqli

That’s it 🙂

Related links:

Installation of Tomcat and adding JSP support for a domain on a cpanel server
How to enable mod_deflate in apache

Post navigation

Arunlal A

Senior System Developer at Zeta. Linux lover. Traveller. Let's connect! Whether you're a seasoned DevOps pro or just starting your journey, I'm always eager to engage with like-minded individuals. Follow my blog for regular updates, connect on social media, and let's embark on this DevOps adventure together! Happy coding and deploying!

22 thoughts on “How to enable MySQLi extension on web-server

  1. Thanks Man this really helped me as I needed to relocate one of my wordpress websites using the Duplicator plugin and i was jammed up due the the MySQLi Extension not running. Your guide made it very easy for me and I’m not a server guy 🙂 Thanks!

  2. Hi

    Just wondering if rebuilding the web-server with easyapache erases any current mysql database you have up?

    Cheers

  3. i set up pay per download on the back end on wordpress 4.1 when i click on preview i get this :

    need to install PHP 5.2+ and MySQL 5.5+

    1. If you have CloudLinux, you can change the PHP version from cPanel itself. Also check the MySQL version “mysql -V”.

  4. can you help me solve this error…
    “Your PHP installation appears to be missing the MySQL extension which is required by WordPress.”

    https:// bhubaneswarlive.com

  5. please i need to solve this problem
    Fatal error: Call to undefined function mysqli_connect() ininc/_config.php on line 9

  6. i am having this error “Call to undefined function mysqli_connect()”, i found out that mysqli extension isn’t installed on godaddy. i have uploaded the php.ini file and and tried to enable it
    but it doesn’t still work

  7. can you help me solve this error…
    “Your PHP installation appears to be missing the MySQL extension which is required by WordPress.

  8. I am having this problem “Your PHP installation appears to be missing the MySQL extension which is required by WordPress” when I’m upgrade the php from version 5.6 to 7.2. Turns out that mysql extension is no longer supported in php version 7.2. It is now using mysqli extention. I am using old version of wordpress which still using mysql extension so the problem existed. So what I did is upgraded the wordpress to the core. I used the latest version of wordpress and used filezilla to put the new version to the site. I only overwrite the folder wp-includes and wp-admin and replace all the files in the root folder with the new files from version 7.2

Leave a Reply

Your email address will not be published. Required fields are marked *