MySQL Forums
Forum List  »  Install & Repo

Re: SOLUTION TO : can't connect to MySql server on 'localhost' <10061>
Posted by: Markus Lehner
Date: December 03, 2005 02:58PM


I had this problem too;
It came up after I upgraded from 4.1 to 5.0;
After installing 5.0 my server was not connectable any more.
Description of things I have done:
On the command line, I typed: mysqld --remove
then I re-installed the service: mysqld --install
a message like "mysql service installed successfully" appeared
then started the service: "net start mysql"
a message like "service started" appears
but if I looked in the windows services-administration, the mysql-service
appeared as registered, but not started. If I tried to start the service here,
it has been aborted ("#1067...unexpectedly").
The attempt to connect with MySQlQueryBrowser ended with the message
"#2003, can't connect to MySql server on 'localhost' <10061>"
I started the "server instance configuration tool"; after pressing the "execute"-Button in the final step -the "starting service"/ "applying security settings" is just running - a bad stop-retry-messagebox with a large text content appeared;
I pressed "Retry" - no success.
Without having success I spent many time to configure my firewall,
and I felt sure that mysql-server was configured properly:-(

At least I could solve this in the following way:
-removed service ("mysqld --remove")
-uninstalled server
-removed remaining folders manually
-restarted computer
-installed mysql server once again (mysql-essential-5.0.16-win32.msi):
--custom option
--chose installation path to be :\MySQL (..not :\Program files\MySQL)
--did not execute "server instance configuration tool" directly after the installation procedure
-instead started "server instance configuration tool" separately (programs menu)
--during the last action, when the stop-retry-messagebox appeared
--I did not react to fast
--my firewall automatically detected the mysql-Server !? why now !?
--allowed connection
--finally pressed the messagebox-retry button
--firewall once again demanded for permissions, allowed
--at least configuration-procedure ended successfully
and now everything works

hope this helps

Options: ReplyQuote

Written By
March 16, 2010 11:16PM
June 12, 2009 01:06PM
Re: SOLUTION TO : can't connect to MySql server on 'localhost' <10061>
December 03, 2005 02:58PM
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.