How to install MySQLi

问题:

I cannot find instructions about installing MySQLi on a Mac. Just to be clear, MySQL is up to date and I am running PHP 5. How do I install it? Where do I even get it from? Thanks for your help. I'll be giving an up vote and a check mark to whoever answers this!

回答1:

MySQLi is part of PHP. There should be a php-mysqli type package available, or you can take the PHP source and recompile that mysqli enabled. You may already have it installed, but it's done as a module and is disabled. Check your php.ini for extension=mysqli.so or similar. it may be commented out, or the .so file is present in your extensions directory but not linked to PHP via that extension= directive.

回答2:

Use php-mysqlnd instead of php-mysql

apt-get install php-mysqlnd

回答3:

This article is clearly explained, how to install MySqli with EachApache. This works for me too.

To install mysqli using EachApache:

1. Login to WHM as 'root' user.

2. Either search for "EasyApache" or go to Software > EasyApache

3. Scroll down and select a build option (Previously Saved Config)

4. Click Start "Start customizing based on profile"

5. Select the version of Apache and click "Next Step".

6. Select the version of PHP and click "Next Step".

7. Chose additional options within the "Short Options List"

8. Select "Exhaustive Options List" and look for "MySQL Improved extension"

9. Click "Save and Build"

回答4:

This is how I installed it on my Debian based machine (ubuntu):

php 7:

sudo apt-get install php7.0-mysqli

php 5:

sudo apt-get install php5-mysqli

回答5:

You are supposed to edit two lines in your php.ini file (i'm using windows for this example):

-The first one is regarding the extensions directory location. See below:

; Directory in which the loadable extensions (modules) reside.
; http://php.net/extension-dir
; extension_dir = "./"
; On windows:
extension_dir = "C:/php/ext"

-The second one is regarding the extension itself:

extension=php_mysqli.dll

Only modifying (uncommenting) the extension line was not enough for me. Hope it helps

回答6:

Here is the link for installation details: http://php.net/manual/en/mysqli.installation.php

If you are using Windows or Linux:
- The MySQLi extension is automatically installed in most cases, when PHP & MySQL package is installed.

回答7:

Since you are using a Mac, open a terminal, and

• cd /etc

Find the php.ini, and sudo open it, for example, using the nano editor

• nano php.ini

Find use control+w to search for "mysqli.default_socket", and change the line to

• mysqli.default_socket = /tmp/mysql.sock

Use control+x and then hit "y" and "return" to save the file. Restart Aapche if necessary.

Now you should be able to run mysqli.

回答8:

I recently ditched Xampp in favor of the native Apache on Mac Sierra because a new php requirement of a project. Sierra comes with php 5.6.25, but it doesn't run mysql_* out of the box, after a lot of googling, I found this site really help - https://php-osx.liip.ch. As it turns out php 5.6.25 does support mysql_* but wasn't enabled. Choose your version of php and download it, it generates a proper php.ini for your php, then you are good to go

回答9:

sudo apt-get -y -f install php7.0-mysql

回答10:

For windows: 3 steps

step1: Just need to give the ext folder path in php.ini

here

; Directory in which the loadable extensions (modules) reside.
; http://php.net/extension-dir
; extension_dir = "./"
; On windows:
 extension_dir = "C:\php7\ext"

step 2: Remove the comment from

extension=php_mysqli.dll

step 3: restart the Apache server.

Happy coding!!!

回答11:

if you use ubuntu 16.04 (maybe and above) just do this

 sudo phpenmod mysqli
 sudo service php7.0-fpm restart