Connection error from the local host but no error from another machine

Asked By christine conklin 20 points N/A Posted on - 08/22/2012

Hello everyone,

I am facing a problem when connecting from the lost host. When i try to connect it to the local host, it gives me the error shown in the window below:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

MySQL Workbench

Failed to Connect to MySQL at 127.0.0.1:3306 with user root

Can't connect to MySQL server on '127.0.0.1' (10061)

It simply won't connect to either the MySQL server on 127.0.0.1. Is anybody else facing this kind of a problem? Kindly do help me in this regard. I have tried a lot myself to set up the new connection but all in vain. It simply gives me the message shown above. Does anybody have an idea about my problem?

I am looking forward to your replies.

Regards,

Thompson

• Status: Open
• Question Views: 606
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Networking

Answered By iojecht 0 points N/A #154348

Connection error from the local host but no error from another machine

Have you tried checking 

c:windowssystem32driversetchosts

delete a line with this statement "::1 localhost" as it overrides the IPv4 value of localhost into IPv6.

If you are using vista,

1. try opening blank notepad as administrator then

2. in file menu, click Open.

3. Search in c:windowssystem32driversetc for hosts file

this steps is to enable save for this file because vista blocks any changes to files in system32.

About iojecht

Questions
0

Answers
2

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 08/28/2012
• Question Category: Networking