MySQL remote connections from Windows

Spetnik · 09-23-2011, 05:29 AM

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)

Any help would be greatly appreciated.

Thanks!

EricTRA · 09-24-2011, 01:33 AM

Hello,

Can you post your my.cnf file (changing IP addresses and other personal things of course)?

Kind regards,

Eric

lithos · 09-24-2011, 04:56 AM

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

Spetnik · 09-24-2011, 01:36 PM

My my.cnf is below. Lithos, I don't think those links are applicable here, as those are regarding Windows servers.

Code:

[client]
port        = 3306
socket      = /var/run/mysqld/mysqld.sock

[mysqld_safe]
socket      = /var/run/mysqld/mysqld.sock
nice        = 0

[mysqld]
user        = mysql
pid-file    = /var/run/mysqld/mysqld.pid
socket      = /var/run/mysqld/mysqld.sock
port        = 3306
basedir     = /usr
datadir     = /var/lib/mysql
tmpdir      = /tmp
language    = /usr/share/mysql/english
skip-external-locking

bind-address       = www.xxx.yyy.zzz

key_buffer      = 16M
max_allowed_packet  = 16M
thread_stack        = 128K
thread_cache_size   = 8

myisam-recover      = BACKUP

query_cache_limit       = 1M
query_cache_size        = 16M

expire_logs_days    = 10
max_binlog_size         = 100M

skip-bdb

[mysqldump]
quick
quote-names
max_allowed_packet  = 16M

[mysql]

[isamchk]
key_buffer      = 16M

!includedir /etc/mysql/conf.d/

EricTRA · 09-24-2011, 03:05 PM

Hello,

Can you add the following to the mysqld section, restart the MySQL service and try again:

Code:

enable-named-pipe

I'm assuming you're running the MySQL client on Windows from the command prompt right?

Kind regards,

Eric

Spetnik · 09-24-2011, 06:46 PM

I tried that - no luck.
Yes, I am running it from a windows command prompt.

Spetnik · 09-24-2011, 06:56 PM

I just tried it with --protocol=tcp and it works. I guess that's okay - do named pipes work with a Linux server?

EricTRA · 09-25-2011, 03:45 AM

Hi,

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.

Kind regards,

Eric

Spetnik · 09-25-2011, 07:35 AM

Based on this, it does not seem like a named pipe connection from a windows client to a Linux server would be possible. Am I correct?

EricTRA · 09-25-2011, 07:52 AM

Hello,

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.

Kind regards,

Eric

Spetnik · 09-25-2011, 09:05 AM

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.

Thanks for the help

EricTRA · 09-25-2011, 09:45 AM

Hi,

It looks like you're right in that aspect. I've been searching too and came across this page from the MySQL reference manual:
http://dev.mysql.com/doc/refman/5.5/...to-server.html.

Kind regards,

Eric