更新日志
| 版本 | 说明 |
|---|---|
| 5.3.0 | The MySQL Native Driver was added, with support for all MySQL extensions (i.e., mysql, mysqli and PDO_MYSQL). Passing in mysqlnd to the appropriate configure switch enables this support. |
| 5.4.0 | The MySQL Native Driver is now the default for all MySQL extensions (i.e., mysql, mysqli and PDO_MYSQL). Passing in mysqlnd to configure is now optional. |
| 5.5.0 | SHA-256 Authentication Plugin support was added |
Installation on Unix
The MySQL database extensions must be configured to use the MySQL Client Library. In order to use the MySQL Native Driver, PHP needs to be built specifying that the MySQL database extensions are compiled with MySQL Native Driver support. This is done through configuration options prior to building the PHP source code.
For example, to build the MySQL extension, mysqli and PDO MYSQL using the MySQL Native Driver, the following command would be given:
./configure --with-mysql=mysqlnd \ --with-mysqli=mysqlnd \ --with-pdo-mysql=mysqlnd \ [other options]
Installation on Windows
In the official PHP Windows distributions from 5.3 onwards, MySQL Native Driver is enabled by default, so no additional configuration is required to use it. All MySQL database extensions will use MySQL Native Driver in this case.
SHA-256 Authentication Plugin support
The MySQL Native Driver requires the OpenSSL functionality of PHP to be loaded and enabled to connect to MySQL through accounts that use the MySQL SHA-256 Authentication Plugin. For example, PHP could be configured using:
./configure --with-mysql=mysqlnd \ --with-mysqli=mysqlnd \ --with-pdo-mysql=mysqlnd \ --with-openssl [other options]
Den (2012-07-08 11:52:12)
On ubuntu mysqlnd can be installed without source php code using synaptic package manager. However, phpmyadmin works I guess only with mysql, so if you use it you must keep an old driver.
After installing mysqlnd package you must restart apache in order new changes to take effect:
sudo service apache2 restart
or (if first doesn't work for you):
sudo /etc/init.d/apache2 restart
jose dot nobile at gmail dot com (2010-10-20 10:15:41)
On CentOS 5.4, installing php 5.3.3, is without mysqlnd
But is available mysql, mysqli, pdo_mysql