Error: 2017 - CR_NAMEDPIPEOPEN_ERROR

March 11th, 2009
Goto solutions Leave a solution
  • Share
  • Share

Description:
Message: Can’t open named pipe to host: %s pipe: %s %lu

MySql-Client , , , , , , , , , ,

  1. srinivas panguluri
    March 18th, 2009 at 15:05 | #1
    Reply | Quote

    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. No trackbacks yet.