Linux - ServerThis forum is for the discussion of Linux Software used in a server related context.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
Is there any special configuration to allow a remote Windows host to connect to MySQL on my Linux server? In my.cnf I have set the bind-address to the server's IP address.
However, when I run this from the Windows machine (works fine from another Linux machine):
mysql -h serveraddress -u user -p
I get the following error:
ERROR 2017 (HY000): Can't open named pipe to host: serveraddress pipe: mysql (1326)
your problem is known:
- here
- here
read the posts at the bottom of the screen from starting thread:
Quote:
Subject Written By Posted
error 2017: can't open named pipe to host david 04/04/2006 08:40PM
Re: error 2017: can't open named pipe to host Umesh Shastry 04/05/2006 05:42AM
Re: error 2017: can't open named pipe to host Brian Geasa 06/01/2006 12:32PM
Re: error 2017: can't open named pipe to host tikkytikky 01/22/2007 02:38PM
Re: error 2017: can't open named pipe to host edward 01/25/2007 11:23AM
Re: error 2017: can't open named pipe to host chariya punyanitya 01/13/2008 02:23PM
Reinstalling with standard config worked for me David Ashman 01/24/2008 03:44PM
Re: error 2017: can't open named pipe to host Kapil Bulsara 01/07/2008 06:09PM
Re: error 2017: can't open named pipe to host
Have a look at this easy description and yes, named pipes also work in Linux although there are substantial differences. http://en.wikipedia.org/wiki/Named_pipe. I find it strange that you get it working when you indicate to use TCP as protocol.
Normally it shouldn't be an issue referring to the MySQL server. You should be able to connect to MySQL server on Linux from Windows without problems. Can you stop the mysqld service and start it manually with:
Code:
/usr/sbin/mysqld --verbose
then try to connect from Windows to see what turns up. You could also enable logging if you haven't done that already and see if anything turns up in there.
From my extensive research, it seems that it is not possible for a Windows client to connect to a Linux MySQL server via named pipes. Named pipes seem to be two very different protocols for Windows and Linux. It seems that TCP is the only way to do it.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.