I know that there are about 10 answered questions in the EE knowledge base with this or similar title, but so far none of them have a solution that I have been able to make work for whatever reason (most of those asking the questions left out some of their important details of implementation of the answers). It appears that there are 2 methods for establishing a connection from a client, like mysql, to connect to a process running as a service like mysqld-nt: through local host (IP 127.0.0.1) or through named pipes.
Here is my situation and what I have. I'm trying to run mysqld-nt server version 5.0.19-nt (community something) as a Windows service and my preferred way of connecting to it would be localhost IP 127.0.0.1; but at this point I would take whatever I can get working. I'm trying to install my "proof of concept" VB.NET application that uses MySQL via ADO.NET unbound controls as an RDBMS running as a service on the client machine. I have done 4 or 5 practice installs onto Windows XP Pro machines and Windows 2000 Pro machines without any problem -- everything works and I'll give more details later. The database installs without incident and everything works. I'm now trying use the same install software components on a CD that I have burned and used successfully to install the application on a laptop that has Windows XP Home Edition for an Operation System and the RDBMS doesn't work. I get either the message in the question title or "Can't Open named pip to host pipe:mysql(2)t ". I get that one when I have selected not to use TCP/IP in the MySQLInstanceConfig.exe program.
When I try to run the client "mysql" in a DOS window, it just blows right off because it can't connect to the server running in the backgound as a service. I have uninstalled and reinstalled the MySQL software probably at least 5 times now trying various combinations as I go. I have also tried to run the server in the foreground in a DOS window using the command line "mysqld-nt --enable-named-pipe". At this point the hostname,err file in the Drive:\Program Files\MySQL\MySQL Server 5.0\data folder says: . . . I can't say what it says because I have uninstalled and deleted all the folders and files. I'll do it again if I need to in response to a request for information.
I can see from the responses to other same questions in the EE knowledge base that MySQL has been made to work with Windows XP Home Edition. Any suggestions..?? I hope I can get something that works soon or I'm going to have to loan my client my laptop that has XP Pro on it to take to a convention to show some of his associates what we have so far as proof of concept for my program that about 20 people have expressed an interest in purchasing.