Hello folks,

I have two Linux red hat 9 servers. On one php 5.1 is configured with Apache and Oracle is the database. I have the other server configured with mysql database. I need to access the mysql database from server 1. My dilemma is, "Do I need to install mysql and reconfigure php in Server 1 to enable mysql support??" OR "Is there somethng that will enable mysql support without installing mysql"

Can somebody help me with the requirements to achieve the same. Any help is appreiated??? Thx a ton.

If you have installed PHP from RPMs, then you just need the correct php-mysql RPM and that should take care of it.

If you have installed from source, you'll need to recompile it to add MySQL support by including --with-mysql in the configure command. PHP 5 and greater no longer includes MySQL support by default, nor is it bundled with the headers and libraries. You won't need the full installation of MySQL, but you will need to install the headers and libraries for the appropriate MySQL version. You will want MySQL-devel-standard installed on Server 1 for whatever version of MySQL you have on Server 2. You can download it here: http://dev.mysql.com/downloads/

Thx zaichik for your response. I really appreciate that. I have installed Php5.1 from source. My installed Mysql version is 5.0.15. Could you please let me know the exact number and names of header files and libraries that needs to be installed. I clicked on the downloads link but really didnt find anything specific. I am still looking though.

I am really sorry if the question is elementary but since this is a clients server I really dont want to install and uninstall unwanted things. I hope you understand my situation. Thx very much for the help. Waiting for your response.

Here, run with this one:

http://dev.mysql.com/get/Downloads/M.../mysql.he.net/

It's 5.0.21 instead of 5.0.15 but it should be fine for compiling PHP against it.

Thx zaichik once again. I have downloaded it. Will try to configure it with php and try the remote connectivity with Mysql. Hopefully it should go smoothly. Just one more thing: Is there any special configuration required on the Mysql server like creating users and granting rights and privileges etc or simply use the server 2 ip, mysql root and password in my php configuration file on server 1. Thx in advance.

Absolutely there is access configuration needed. You will need to set up a user@host combination, provide a password (highly recommended) and grant them the necessary privileges to execute the queries they need on the database(s) and table(s).

You'll want to thoroughly understand the MySQL privilege system before you starting allowing access from remote hosts. Their online docs on this (http://dev.mysql.com/doc/refman/5.0/...ge-system.html) should help out considerably.

Thx a toooooooooooooooonnnnnnnnn for all the help zaichik. Had lot of doubts before posting these questions but feeling much better. Will do the necessary steps and update this thread soon. You have a nice day buddy. Cheeers.

You're welcome. If you have any more questions, especially about the MySQl privilege system, I'll be glad to help out.