You are here

MySQL connection with pipes (XP)

3 posts / 0 new
Last post
cis-inst
Offline
Last seen: 12 years 4 months ago
Joined: 2012-05-25 11:28
MySQL connection with pipes (XP)

I need to be able to access MySQL through pipes on Windows/XP. According to the documentation I start the server with:

mysql\bin\mysqld --defaults-file=mysql\bin\my.ini --enable-named-pipe --standalone --console

when I try to connect I use:
mysql\bin\mysql --pipe -u root -p

I get the error message:
ERROR 2017 (HY000): Can't open named pipe to host: . pipe: MySQL(2)

I have been through the forums and the MySQL documentation. The 5.1 documentation I have says that I must use mysqld-nt.exe to use pipes but the documentation with xamp does not. I have tried using msqld-debug.exe also with no success.

When I start the server with --enable-named-pipe SHOW VARIABLES 'named-pipe' is 'ON'.

I have also tried modifying the mysql.ini file to uncomment skip-networking and comment out skip-federated.

The server seems to know that I have enabled pipes but doesn't actually get them setup.

Any help would be appreciated.
Thanks
-Tom

Gord Caswell
Gord Caswell's picture
Offline
Last seen: 6 days 13 hours ago
DeveloperModerator
Joined: 2008-07-24 18:46
Wrong place to ask

Unfortunately, this has nothing to do with PortableApps or our launcher for XAMPP. Try asking at the support forums: http://www.apachefriends.org/f/viewforum.php?f=16

cis-inst
Offline
Last seen: 12 years 4 months ago
Joined: 2012-05-25 11:28
Sorry - thanks for answer

I posted it here because I thought it might have something to do with how it had been configured for portableapps. I found the answer at the apache web site pretty quickly.

Thanks,
-Tom

Log in or register to post comments