Additional languages
MySQL 3.23, 4.0, 4.1 Reference Manual :: 17 APIs and Libraries :: 17.3 MySQL PHP API :: 17.3.1 Common Problems with MySQL and PHP
« 17.3 MySQL PHP API
17.3.2 Enabling Both mysql and mysqli in PHP »
Section Navigation      [Toggle]

17.3.1. Common Problems with MySQL and PHP

  • Error: Maximum Execution Time Exceeded: This is a PHP limit; go into the php.ini file and set the maximum execution time up from 30 seconds to something higher, as needed. It is also not a bad idea to double the RAM allowed per script to 16MB instead of 8MB.

  • Fatal error: Call to unsupported or undefined function mysql_connect() in ...: This means that your PHP version isn't compiled with MySQL support. You can either compile a dynamic MySQL module and load it into PHP or recompile PHP with built-in MySQL support. This process is described in detail in the PHP manual.

  • Error: Undefined reference to 'uncompress': This means that the client library is compiled with support for a compressed client/server protocol. The fix is to add -lz last when linking with -lmysqlclient.

  • Error: Client does not support authentication protocol: This is most often encountered when trying to use the older mysql extension with MySQL 4.1.1 and later. Possible solutions are: downgrade to MySQL 4.0; switch to PHP 5 and the newer mysqli extension; or configure the MySQL server with --old-passwords. (See Section A.1.2.3, “Client does not support authentication protocol”, for more information.)

Those with PHP4 legacy code can make use of a compatibility layer for the old and new MySQL libraries, such as this one: http://www.coggeshall.org/oss/mysql2i.


User Comments

Posted by Doug Robb on July 14 2003 3:45pm[Delete] [Edit]

The MySQL-shared-compat RPM package provides the libmysqlclient.so.10
library for use with other packages that rely on it (such as PHPmysql) which is good but this rpm requires libss1l.so.9.6 and libcrypto.so.0.9.6 (from openssl-0.9.6) package) and Redhat 9 and others are now shipping with openssl-0.9.7a at present so it can't be installed on RedHat 9 running MySQL 4.1

Posted by Zak Greant on June 7 2004 5:43pm[Delete] [Edit]

Unlike PHP 4, PHP 5 does not include the MySQL client libraries. To enable MySQL support in PHP 5, you will need to have the client libraries already installed on your system.

Add your own comment.