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

Asked By 20 points N/A Posted on -
qa-featured

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

SHARE
Answered By 0 points N/A #154348

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

qa-featured

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.

Related Questions