MySQL Forums
Forum List  »  Install & Repo

Error Nr. 2003 : Can't connect to MySQL server on 'localhost' (10061). I'M DESPERATE!!! HEEEEEELP!!!
Posted by: Hallo You
Date: March 13, 2011 04:40AM

After waisting 10 hours I finally found and resolved the problem. I could start the service and could even access the database via Pentaho Kettle but not with MySQL workbench or Navicat.

1) open Win command shell and type: netstat -ano
- search for a process on port 3306 in the column local address
- it should be: 127.0.0.1:3306 ,however in my case it was [::]:3306

2) add the following line in the my.ini in the "[mysqld]" section:
bind-address = 127.0.0.1

3) restart your service & save your day

Options: ReplyQuote


Subject
Written By
Posted
March 16, 2010 11:16PM
June 12, 2009 01:06PM
Error Nr. 2003 : Can't connect to MySQL server on 'localhost' (10061). I'M DESPERATE!!! HEEEEEELP!!!
March 13, 2011 04:40AM
July 25, 2005 08:47AM
January 20, 2006 11:38AM
April 09, 2010 05:07PM
December 09, 2007 06:57AM
January 13, 2010 03:53AM
June 25, 2009 05:58AM
July 15, 2009 02:19PM
July 15, 2009 06:01PM
October 07, 2009 09:41AM
March 14, 2011 06:28AM
December 03, 2009 03:00AM
December 14, 2009 01:14PM
January 04, 2010 03:49AM
March 20, 2010 07:52AM
March 16, 2010 11:08PM
May 10, 2010 06:56PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.