problem connecting to mySQL with named pipe

[joshhighley]

I'm new to PHP, but not to web development. I'm trying to set up a development machine using PHP with a mySQL database. I have mySQL configured to only accept connections using a named pipe (mysql) -- not TCP/IP.

In my.ini:

socket=mysql

I can connect fine using the Java code:

String url = "jdbc:mysql:///mysql?socketFactory=com.mysql.jdbc.NamedPipeSocketFactory";
Connection con = DriverManager.getConnection(url);

I have not been able to connect using PHP mysql_connect, though. All the documentation I've found says to set the server parameter to :/path/to/socket but I don't know how to determine the path to the socket. Based on the Java code above, is it possible to construct the mysql_connect call?

I'm using the latest stable versions of PHP, Apache, and mySQL

Thanks,

Josh

[tha_mink]

a> What error are you getting?

b> What platform are you using?

[joshhighley]

Yeah, I guess I left out some important details....

I'm running Windows XP with Apache 2.0.53, PHP 5, and mySQL 4.1

The error I get:

Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10061) in C:\Program Files\Apache Group\Apache2\htdocs\test.php on line 5

I copied libmySQL.dll to c:\php and php_mysql.dll is in c:\php\ext. I have a reference to both dlls in my PATH. "LoadModule php5_module "c:/php/php5apache2.dll"" is in httpd.conf and the dll exists at that location.

This is the PHP I've been using:

if (!mysql_connect(":/mysql", "", ""))
echo "MySQL error<br />";
else
echo "Connected to MySQL<br />";

In place of ':/mysql' I've also tried 'localhost', among many other things. I'm not sure how to determine what this should be for a named pipe.

[joshhighley]

Has anyone used mySQL named pipes with PHP on Windows?