mysqli install and configure

How to install and configure mysqli in php and how to enable it.

Thanks

Tahir Atique

Status: 
Active

Comments

Sorry, it doesn't appear that CentOS 5.x includes a PHP module with mysqli enabled in it.

One option is that you could compile PHP yourself, but I don't really recommend that ... are you certain you need mysqli support, and that the standard "mysql" module wouldn't work?

Morning "Batman" [Eric]

OK, almost 5 years later-back at the ranch- and using this thread as it contains the exact subject matter at hand sir.

re: Sorry, it doesn't appear that CentOS 5.x includes a PHP module with mysqli enabled in it.

Tada? It has for awhile so, here is what I see: [root@lassd ~]# locate mysqli /etc/php.d/mysqli.ini

[**** SOME OUTPUT OF ACCOUNT NAME REMOVED as well as references to what Joomla. and quite a few others utilize MySQLi for in this century ***] LoL

/usr/bin/mysqlimport /usr/lib64/php/modules/mysqli.so /usr/share/man/man1/mysqlimport.1.gz [root@lassd ~]#

re: One option is that you could compile PHP yourself, but I don't really recommend that

Have things changed on this reply?

re: ... are you certain you need mysqli support, and that the standard "mysql" module wouldn't work?

YES!!

So, in Webmin, tried to see if any type of Auto-Install/attach it to this, to no avail.

My little brain, then thinks -

Upgrade All Packages

Upgrading all packages with command yum clean all ; yum -y update ..

OK? Did this just KILL OFF the tweaks for the ProFTPd Problem?

Loaded plugins: fastestmirror Cleaning repos: base extras rpmforge updates virtualmin virtualmin-universal : vz-base vz-updates Cleaning up Everything Cleaning up list of fastest mirrors Loaded plugins: fastestmirror Setting up Update Process Determining fastest mirrors * base: repos.lax.quadranet.com * extras: repos.lax.quadranet.com * rpmforge: mirror.webnx.com * updates: repos.lax.quadranet.com Resolving Dependencies --> Running transaction check ---> Package proftpd.x86_64 0:1.3.3g-2.el6 will be updated ---> Package proftpd.x86_64 0:1.3.4a-1.el6.rf will be an update --> Finished Dependency Resolution

Dependencies Resolved

================================================================================

Package Arch Version Repository Size

Updating: proftpd x86_64 1.3.4a-1.el6.rf rpmforge 2.0 M

Transaction Summary

Upgrade 1 Package(s)

Total download size: 2.0 M Downloading Packages: Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction

Updating : proftpd-1.3.4a-1.el6.rf.x86_64 1/2

Cleanup : proftpd-1.3.3g-2.el6.x86_64 2/2

Verifying : proftpd-1.3.4a-1.el6.rf.x86_64 1/2

Verifying : proftpd-1.3.3g-2.el6.x86_64 2/2

Updated: proftpd.x86_64 0:1.3.4a-1.el6.rf

Complete!

.. upgrade complete.

The "mysqli" PHP module does come with CentOS 6, and likely 7. It's part of the php-mysql package.

In your case, it looks like you're using a third party repository though... you'd want to be careful with that, it can cause a number of issues, including ProFTPd not working properly. If you're having problems with ProFTPd now, take a peek at the article titled "Why does PHP / ProFTPd no longer work after performing updates? (I'm using CentOS, and enabled third party repositories)" here:

https://virtualmin.com/documentation/system/faq

The mysqli module actually comes with the standard PHP versions included with CentOS now, so you wouldn't actually need a third party repo.