Thank you ruler. That did it. I was wondering which socket was supposed to be
doing this.
I was using a book with an old version of MySQL and I guess the names are
missmatched.
Thanks again
Ruler wrote:
> What I did is made a symlink from /var/run/mysql.sock to /tmp/mysql.sock
> example: ln -s /var/run/mysql.sock /tmp/mysql.sock
>
> Or if /var/run/mysql.sock doesn't exist, find / -name "mysql.sock"
> Then symlink that to /tmp
>
> Hope that helps.
> ----- Original Message -----
> From: "Ellis M. Mendez-Hidaka" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, March 08, 2002 8:43 PM
> Subject: [PHP] mysql_connect() help
>
> > Greetings,
> > I'm a newbie with apache and PHP.
> > I was able to setup apache, php and mysql in RH Linux and have my
> > website running.
> > I was trying to test the BD connectivity capabilities of PHP but I keep
> > receiving this error message:
> > {
> > Warning: Can't connect to local MySQL server through socket
> > '/tmp/mysql.sock' (2) in /var/www/html/testdb.php on line 20
> >
> > Warning: MySQL Connection Failed: Can't connect to local MySQL server
> > through socket '/tmp/mysql.sock' (2) in /var/www/html/testdb.php on line
> > 20
> > Could not connect to DB
> > }
> >
> > I tried looking at the documentation in php.net, but I don't see what
> > could be the problem.
> > Here is the code (line 20 is the mysql_connect() command):
> >
> > <?php
> >
> >
> >
> > //build SELECT query
> > $query = "SELECT * FROM divers";
> >
> > //Connect to MySQL
> > // *************This line is the problem! :^( ******************
> > if( !($database1 = mysql_connect( "localhost","test1","psswd" ) ) )
> > die( "Could not connect to DB" );
> >
> > //Open database
> > if( !mysql_select_db( "divers", $database1 ) )
> > die( "Could not open divers DB" );
> >
> > //Query DB
> > if( !($result = mysql_query( $query, $databse1 ) ) )
> > {
> > print("Could not execute query! <br />" );
> > die( mysql_error() );
> > }
> >
> > ?>
> >
> > My DB is running fine, and I even tested it with that ID and it shows
> > fine as well.....
> >
> > I'm using PHP 4.0.6 and mysql is enabled.
> > Am I missing any settings I might not know?
> > Any help will be really appreciated.
> > Thank you
> >
> > Ellis
> >
> >
> > --
> > 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
