How to install mysqli extension for php on cpanel

  • 0

Now you can Install MySQLi using cPanel or WHM easily. Read and learn step by step tutorial and do it yourself.

MySQLi = MySQL "Improved"

To Install MySQLi using WHM Panel in Cpanel,Follow the steps below :-

* Login to WHM as Root and follow the path :

Main >> Software >> EasyApache (Apache Update)

* Select radio button "Previously Saved Config" and click on start customizing based on profile

* Select Apache

* Select PHP 5 (latest version )

* Click on Exhaustive Option list

* Under php 5 section you can find selection box for {"MySQL "Improved" extension. }

Select it and click on save and build


Was this answer helpful?

Verified and Tested 1/11/16

Introduction

In this tutorial we will walk you through enabling MySQLi in cPanel/WHM by using EasyApache. MySQLi is an extension used for PHP coding so PHP can interface directly to MySQL.

Prerequisites

A server with cPanel/WHM installed and using EasyApache 3.  If you do not have a server and need one, Atlantic.Net offers reliable VPS hosting options.

Note: EasyApache 4 is still listed as a Technology Preview. Because of this, not all features or security updates are available should you replace the EasyApache 3. It is not recommended that you enable EasyApache 4 at this time.

Enabling MySQLi in cPanel/WHM with EasyApache 3

Installing the MySQLi extension is a simple process in cPanel/WHM. The first thing you will want to do is log into WHM and in WHM’s search bar, enter “EasyApache.” From here you will need to select EasyApache 3. If you do not have the latest cPanel/WHM update, your option may just say “EasyApache.”

How to install mysqli extension for php on cpanel

WHM EasyApache options

EasyApache 3

With EasyApache 3, once you click on it, it will load the current settings. You will want to edit your current build by clicking the gear icon located in the below picture.

How to install mysqli extension for php on cpanel

EasyApache settings

From here, you can continue to where MySQLi is located by clicking the options in the red box in the pictures below.

How to install mysqli extension for php on cpanel

First step

And then here.

How to install mysqli extension for php on cpanel

Second step

And finally here.

How to install mysqli extension for php on cpanel

Third step

Once in the Exhaustive Options List, you want to look for the MySQLi option below, check the box next to it, and then go to the bottom of the page and click “Save and Build.”

How to install mysqli extension for php on cpanel

MySQLi option

And that’s it. You now have the MySQLi extension enabled and ready to use.

Atlantic.Net

Since 1995, Atlantic.Net has been providing internet services to customers, including managed hosting and VPS hosting. In 20+ years of service, our solutions have been focused on providing the very best in web solutions to our valued customers!

How can I tell if mysqli is enabled in PHP?

Check if MySQLi is Installed You can do that by visiting a phpinfo() page that you made, or by running this command: php -m | grep mysqli.

How configure mysqli in PHP?

Open your php. ini file ( php configuration file ) inside your PHP directory ( or windows directory ) . Search for mysqli and enable the dll by removing ; before it. You may have to re-boot your system.

What is mysqli PHP extension?

The MySQLi Extension (MySQL Improved) is a relational database driver used in the PHP scripting language to provide an interface with MySQL databases. There are three main API options when considering connecting to a MySQL database server: PHP's MySQL Extension. PHP's MySQLi Extension.

Does PHP come with mysqli?

The mysqli extension is included with PHP versions 5 and later. The mysqli extension has a number of benefits, the key enhancements over the mysql extension being: Object-oriented interface. Support for Prepared Statements.