Can't open named pipe to host: . pipe: MySQL (2)

Unable to connect to database server : Error



Solution:

Named-pipe Connection Error

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

Check the Named_pipe Status

mysql> show variables like "%named%";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| named_pipe    | ON    |
+---------------+-------+

Re-started Mysql Service...
-------------------------------------------------------
Another Method Try to connect TCP/IP connection.

Allowing TCP/IP connections

c:\mysql\bin>type c:\my.ini open the my.ini file 
added the line

bind-address = 0.0.0.0

Re-started Mysql Service...

Change the Connection Method Standard(tcp/ip)

Test connection

Connection establish