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
