Avatar of rsaudia
rsaudiaFlag for United States of America asked on

MySQL install on Windows Server 2003 not able to connect to mysql

When trying to connect to MySQL 5.0 on a Windows 2003 server locally via command line I get the following error: "ERROR 2017 (HY000): Can't open named pipe to host: .  pipe: mysqld (2)"  I have enabled named pipes in my startup .ini file see below:

protocol = pipe


# The TCP/IP Port the MySQL Server will listen on
#enable named Pipes

The MySQL service is running and starts without any errors.  However, when trying to connect to MySQL via command line I get the error.  What am I missing to be able to connect to mysql locally?
MySQL Server

Avatar of undefined
Last Comment

8/22/2022 - Mon
Cedric Obinna A.

Disable named pipes and then try again to see if the error reoccurs.

I have tried switching between TCPIP and named pipes several times and it always generates the same error.  I just commented out named pipes in the .ini file and restarted the service, tried it again and I get the same error message.  

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Your help has saved me hundreds of hours of internet surfing.