Re: Newbie Question connecting with windows named pipes (resolved)

2007-05-16 Thread John Comerford
Hi Sebastian, That was it alright. I commented out the socket lines from mysql.ini (restarted it) and changed my php command to: $mysqli = new mysqli(".", $username,$password, $database); and all seems to be working fine now. Thanks again for your help, much appreciated. Regards, John

Re: Newbie Question connecting with windows named pipes (resolved)

2007-05-16 Thread Sebastian Mendel
John Comerford schrieb: > Hi Sebastian, > > I did read somewhere that sockets was not valid for windows, and > '/tmp/mysql.sock' doesn't resolve to anything on my machine. But I have > tried the following commands: > > $mysqli = new mysqli(".", $username,$password, $database); > or > $mysqli =

Re: Newbie Question connecting with windows named pipes (resolved)

2007-05-16 Thread John Comerford
Hi Sebastian, I did read somewhere that sockets was not valid for windows, and '/tmp/mysql.sock' doesn't resolve to anything on my machine. But I have tried the following commands: $mysqli = new mysqli(".", $username,$password, $database); or $mysqli = new mysqli(".", $username,$password, $

Re: Newbie Question connecting with windows named pipes (resolved)

2007-05-15 Thread Sebastian Mendel
John Comerford schrieb: > Thanks Sebastian, that did the trick. > The full command I use is: > $mysqli = new mysqli(".", $username,$password, > $database,null,"/tmp/mysql.sock"); there is no need for the socket, their are no sockets on windows $mysqli = new mysqli('.', $username, $password, $dat

Re: Newbie Question connecting with windows named pipes (resolved)

2007-05-15 Thread John Comerford
Thanks Sebastian, that did the trick. The full command I use is: $mysqli = new mysqli(".", $username,$password, $database,null,"/tmp/mysql.sock"); Regards, JC Sebastian Mendel wrote: John Comerford schrieb: Hi Folks, I have a database running on Window XP, that I want to disable netwo

Re: Newbie Question connecting with windows named pipes

2007-05-15 Thread Sebastian Mendel
John Comerford schrieb: > 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... > > [...] > > I can connect to the DB using the GUI tools if I set my pipe name to > '

Newbie Question connecting with windows named pipes

2007-05-15 Thread John Comerford
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= 33