This may be due to permissions on the database also.

Randy 

Wed, 22 Jan 2003, Advancewarning wrote:

> It shows up I have the MySQL Database in there.  I created a new
> database called 'pratt' and created a table called 'Info' but it doesn't
> seem to work.
> 
> Michael Pratt
> Pratt's Computers
> http://pratt.is-a-geek.com
> MCSE, CNA
>  
> 
> -----Original Message-----
> From: Eric R. [mailto:rossiter@discoverynet.com] 
> Sent: Wednesday, January 22, 2003 10:14 AM
> To: Advancewarning
> Cc: KCLUG
> Subject: Re: PHP and MYSQL
> 
> Advancewarning wrote:
> > What is the trick to getting PHP to connect to MYSQL?
> > 
> >  
> > 
> > It blows up at this line:
> > 
> > $connection = mysql_connect("$server","$username","$password");
> > 
> >  
> > 
> > Giving me this:
> > 
> > *Fatal error*: Call to undefined function: mysql_connect() in 
> > */web/test.php* on line *15*
> > 
> 
> Well, as it was so elequently explained to me... :)
> 
> mysql_connect can't find the database that it's looking for.
> 
> Create a test page called info.php:
> 
> <?php phpinfo() ?>
> 
> Open it in your browser... you should see a block of information about 
> MySQL... (my guess is, right now, it won't be there)
> 
> (If it IS there, have you loaded the default MySQL DB after MySQL 
> install??  I belive that was a fix for an earlier glitch of this sort.)
> 
> If you compiled from source, run ./configure again with the --with-mysql
> 
> option.
> 
> Depending on your location of MySQL, it would look something like:
> 
> ./configure --prefix=/usr/local/php 
> --with-config-file-path=/usr/local/php --with-mysql=/usr/local/mysql 
> --with-apxs=/usr/sbin/apxs --enable-track-vars --enable-magic-quotes 
> --enable-debugger
> 
> If you're using rpm's, good luck, never got'em to work.
> 
> Have a quality day,
> E
> 
> 
> 
> 
> 

-- 
Randy Weidman
Linux Systems Administrator
University of Missouri
Dept. Of Chemical Engineering
 
QOTD:
	On a scale of 1 to 10 I'd say...  oh, somewhere in there.