How to enable MySQLi extension on web-server

Before going directly to the enabling steps I will give you some ideas about MySQLi. Then, I’ll explain How we can enable MySQLi on a cpanel server and How we can check if MySQLi is enabled or not in 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?

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 

MySQLi

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

Arunlal Ashok

Linux Server Administrator. I'm dealing with Linux servers since 2012. I started this blog to share and discuss my ideas with the world. Check My Profile!! in uPwork (oDesk) and let me know if you need any assistance. Thanks!!

You may also like...

8 Responses

  1. Kamal says:

    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. Shaun Thomson says:

    Hi

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

    Cheers

  3. Ayman Bitar says:

    Perfect. Accurate and straight to the point!

  4. Steve says:

    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+

Leave a Reply

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