never mind got it "localhost:/pathto/mysql.sock" duh? :) Thanks a
million, I'm up and running.
----- Original Message -----
From: "Rasmus Lerdorf" <[EMAIL PROTECTED]>
To: "Jim Hankins" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, March 23, 2002 10:50 PM
Subject: Re: [PHP] Trouble with mysql_pconnect unable to connect to
database?
> Figure out where your mysql.sock file is and provide the path right in
> your mysql_connect() call. "mysqladmin version" tells you the path.
>
> -Rasmus
>
> On Sat, 23 Mar 2002, Jim Hankins wrote:
>
> > I'm doing a simple database connection using the follow syntax:
> >
> > <html>
> > <head>
> > <title>Book-O-Rama Search Results</title>
> > </head>
> > <body>
> > <h1>Book-O-Rama Search Results</h1>
> > <?
> > if (!$searchtype || !$searchterm)
> > {
> > echo "You have not entered search details. Please go back and try
> > again.";
> > exit;
> > }
> >
> > $searchtype = addslashes($searchtype);
> > $searchterm = addslashes($searchterm);
> >
> > @ $db = mysql_pconnect("localhost", "bookorama", "bookorama123");
> >
> > if (!$db)
> > {
> > echo "Error: Could not connect to database. Please try again
later.";
> > exit;
> > }
> >
> > When I go to the search page and hit submit (after removing the @ to
see an
> > error on the mysql_pconnect line)
> > I get Warning: Can't connect to local MySQL server through socket
> > '/tmp/mysql.sock' (2) in
/home/jhankins/public_html/mydirectory/results.php
> > on line 17
> >
> > I can telnet to the host and with the same username and password access
the
> > database tables etc. What gives? I'm using
> > 4.0.6 of PHP and apache under Redhat Linux 7.2. Mysql is working fine
from
> > command line and remote via odbc?
> >
> > Also tryed mysql_connect with same problem.
> >
> >
> >
> >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
