Cannot connect to an MySQL database using Named Pipes
| From: | John Comerford | Date: | Wed, 16 May 2007 03:09:48 +0000 |
| Subject: | Cannot connect to an MySQL database using Named Pipes | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-255002@lists.php.net to get a copy of this message | ||
Hi Folks,
I have a database running on Window XP, that I want to disable network connections to and enable 'named pipes'. I am running MySQL 5.0.27 and my.ini looks like...
[client]
#password = your_password port = 3306 socket = /tmp/mysql.sock[mysqld]
#port = 3306 socket = /tmp/mysql.sock #Allow connections via named pipes (Windows NT+ only). Note: you can specify a pipe name on the advanced network page, if required.enable-named-pipe #Don't allow connections via TCP/IP. skip-networking I can connect to the DB using the MySQL GUI tools if I set my pipe name to '/tmp/mysql.sock' using the login dialog box. However when I try and connect using PHP I get an error. I have tried several variants of the connect command and I get various errors but all are along the lines of: Unknown MySQL server host '/tmp/mysql.sock' (11004) or Can't connect to MySQL server on 'localhost' (10061) I have tried $mysqli = new mysqli(null, $username,$password, $database); $mysqli = new mysqli("localhost:/tmp/mysql.sock", $username,$password, $database); $mysqli = new mysqli("localhost", $username,$password, $database,3306,"/tmp/mysql.sock"); $mysqli = new mysqli("localhost", $username,$password, $database,"/tmp/mysql.sock"); $mysqli = new mysqli("/tmp/mysql.sock", $username,$password, $database); I have also tried the above commands using mysqli_connect ? I have done a few searches of the web but seem to always come up with something like the above? Anybody have any ideas why it won't connect in PHP ? TIA, JC