Re: [TCLUG:7843] Anyone with mod_php3 - apache - mysql working

[Luke Francl <fran0382@tc.umn.edu>]

On Tue, 24 Aug 1999, Bill Koob wrote:

> Anyone with mod_php3 - apache - mysql working with linux RedHat 6 on a 
> Pentium box?

I have it working on a Slackware pentium box, all from source installs.

> If so - can I receive a copy of your phpinfo() information?
> Mine runs apache well, php with apache well and mysql well as
> individual unit.  But cannot connect to mysql from *.php3
> script.  

You can check out mine at http://yoda.lib.umn.edu/phpinfo/

> If yours work - does phpinfo() mention mysql anyplace?
> What install did you use?

Yes. I compiled from source using the configure script that PHP provides.
Did you specify the path to MySQL correctly? MySQL by default install
itself _all over_ your /usr/local, which I found annoying, so I
re-installed it all on /usr/local/mysql. PHP can usually find MySQL if you
don't tell it where it is, but if you tell PHP the wrong location, or if
MySQL is installed someplace weird, you may need to recompile PHP with the
correct info.

Or, like Bob said, it might be a grant table issue. Make sure you're
trying to connect to the MySQL database with a user that exists, and has
the permissions to do so. By default, mysql_connect() sends
	- localhost as the server
	- httpd as the user
	- and "" as the password.
I made a user httpd so this would work correctly, but I limited the httpd
user to only be able to connect from localhost so that no one could
connect to my database from elsewhere and mess it up...

Hope this helps, good luck.
(PHP + MySQL rocks, by the way)

Luke