Bug #18711 | I receive this error: 2017 <hy000>: can't open named pipe to host: .pipe: | ||
---|---|---|---|
Submitted: | 1 Apr 2006 18:43 | Modified: | 1 Apr 2006 22:33 |
Reporter: | David Young | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | 4.1.1.8 | OS: | Windows (win home xp) |
Assigned to: | CPU Architecture: | Any |
[1 Apr 2006 18:43]
David Young
[1 Apr 2006 22:33]
MySQL Verification Team
Thank you for the bug report. You need to use the key enable-named-pipe under [mysqld] section: c:\mysql\bin>type c:\my.ini [client] host = localhost [mysqld] basedir=c:/mysql datadir=c:/mysql/data enable-named-pipe c:\mysql\bin>mysql -h localhost -u root -W -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.1.18-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show variables like "%named%"; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | named_pipe | ON | +---------------+-------+ 1 row in set (0.06 sec) mysql>
[1 Apr 2006 23:11]
[ name withheld ]
Below is the section you informed me to change and I still get the same error. Ideas? Thanks, David [client] host=localhost protocol = pipe port=3306 [mysql] default-character-set=latin1 # SERVER SECTION # ---------------------------------------------------------------------- # # The following options will be read by the MySQL Server. Make sure that # you have installed the server correctly (see above) so it reads this # file. # [mysqld] basedir=c:/mysql datadir=c:/mysql/data enable-named-pipe # The TCP/IP Port the MySQL Server will listen on port=3306
[1 Apr 2006 23:28]
MySQL Verification Team
Hi, Did you re-started the server after the my.ini modification? If yes try to start the server as standalone like this command: mysqld-nt --standalone --console --enable-named-pipe and verify if it works