configuring php to connect to mysql

Anon

I am running on RH6.2 and when I installed it Apache and php were install somehow.

The above 2 application appear to be running correctly until I tried to connect mysql.

I am new at php and mysql and somewhat limited in linux but my web server was working fine.

I download mysql expanded, compiled and installed it.

per the instruction: /usr/local/mysql/bin/

Since apache and php were auto installed they seem to be residing in: /home/httpd/html or at least that is where the apache and php index files are located.

<?php
$linkID = mysql_connect ("xxxxxx","xxxx","xxx") or
$db = mysql_connect("xxxxxx","xxxx","xxx")
?>
Fatal Error Call unsupported OR undefined function mysql_connect() in /home/httpd/html/mysql-php15.htm on line 11. Can anyone provide some info?

Anon

I think I'm having the same problem. I'm also using RH6.2 with apache and php4. MySQL is installed and working.
PHP4 was installed using the --without mysql configuration - I can see that using php_info().
I also am new to Linux. Could someone please tell me step by step how to correct this so that PHP is using the mysql extensions without blowing up my webserver?
Thanks.

Anon

I guess your linux server alreay installed Apache Web server. It's not configured with MySQL and PHP. That's why your php script is not able to call MySQL DB.

Normall, I install Apache, PHP, and MySQL (APM) in this way.

/usr/local/mysql
/usr/local/apache
/usr/local/php

Here is offical PHP manual... and other. It's a good idea to install PHP as a module not a CGI. It's much faster than CGI install.

http://www.php.net/manual/en/install.linux.php

http://www.devshed.com/Server_Side/PHP/SoothinglySeamless/print

good luck

axoboy

Hello All,

Thanks Seung, that was a great article. But I am having the same problems Stuart and James are having. I have Apache and PHP working together, but for some reason, I didn't install PHP right, because I can not get MySql to work with PHP/Apache. I use webmin and RPMs to install most of my programs, so that could be a reason. Is there an article where they show how to configure php/apache to use MySQL after the mis-install? I assume it's just a modification of a config file somewhere, but where.
if anyone can help point me in the right direction, I would sure appreciate it!
I DO NOT want to unistall/reinstall again...please....

thanks, Axo

slesnett

I know that Red Hat does not install in same directories that each application would have you place them, e.g. usr and home, if you downloaded them but cross linking the 2 directories should not be impossible?? I'm just not where to make these changes.

Stu