Does PHP 4.4 work with mySQL 5.0?

installed from sources and upgrading from mySQL 4.4

[guarriman]

Hi.

I've got mySQL 4.1.22 installed from sources
---
./configure --prefix=/usr/local/mysql
----

and PHP 4.4.2 installed from sources
-------
./configure --prefix=/usr/local/php --with-mysql=/usr/local/mysql
--------

I want to upgrade mySQL from 4.1.22 to 5.0.5 by doing:
1) export DB
2) stop mySQL daemon
3) mv /usr/local/mysql /usr/local/mysq.4
4) install mySQL 5.0.5 (./configure --prefix=/usr/local/mysql)
5) start mySQL daemon
5) import DB

Does PHP 4.4 work with mySQL 5.0 or must I upgrade mySQL libraries?

Thank you very much.

[coopster]

I'm thinking you will be fine but it may depend on how you compiled PHP 4. Did you read the manual pages on MySQL [php.net]?

PHP 4

The option --with-mysql is enabled by default. This default behavior may be disabled with the --without-mysql configure option. If MySQL is enabled without specifying the path to the MySQL install DIR, PHP will use the bundled MySQL client libraries.

Users who run other applications that use MySQL (for example, auth-mysql) should not use the bundled library, but rather specify the path to MySQL's install directory, like so: --with-mysql=/path/to/mysql. This will force PHP to use the client libraries installed by MySQL, thus avoiding any conflicts.