Skip navigation links
MySQL 5.4 Reference Manual :: 20 Connectors and APIs :: 20.10 MySQL PHP API :: 20.10.7 Enabling Both mysql and mysqli in PHP
20.11 MySQL Perl API »
Section Navigation      [Toggle]

20.10.7. Enabling Both mysql and mysqli in PHP

If you're experiencing problems with enabling both the mysql and the mysqli extension when building PHP on Linux yourself, you should try the following procedure.

  1. Configure PHP like this: 

    ./configure --with-mysqli=/usr/bin/mysql_config --with-mysql=/usr

  2. Edit the Makefile and search for a line that starts with EXTRA_LIBS. It might look like this (all on one line): 

    EXTRA_LIBS = -lcrypt -lcrypt -lmysqlclient -lz -lresolv -lm -ldl -lnsl
-lxml2 -lz -lm -lxml2 -lz -lm -lmysqlclient -lz -lcrypt -lnsl -lm
-lxml2 -lz -lm -lcrypt -lxml2 -lz -lm -lcrypt

    Remove all duplicates, so that the line looks like this (all on one line): 

    EXTRA_LIBS = -lcrypt -lcrypt -lmysqlclient -lz -lresolv -lm -ldl -lnsl
-lxml2

  3. Build and install PHP: 

    make
make install

MySQL Enterprise.  MySQL Enterprise subscribers will find more information about the mysqli extension in the Knowledge Base articles found at mysqli. Access to the MySQL Knowledge Base collection of articles is one of the advantages of subscribing to MySQL Enterprise. For more information, see http://www.mysql.com/products/enterprise/advisors.html.