MySQL Forums
Forum List  »  Install & Repo

Re: can't connect to MySql server on 'localhost' <10061>
Posted by: Daniel Foreman
Date: March 24, 2006 12:00PM

ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
(Error sorted on windows xp home (for me anyhow))

Im have been getting the above error from when i started to try and use mysql on a windows based computer for over a year now.

I finaly found out how to sort the probalme well it worked for me anyhow.

I noticed that innodb was trying to write to a file named com1.pif and it could not write to this file or create it

when i tried to create it it allso failed saying it was there but it was not.

My computer is called com1 (Well was) i renamed it to computer1 using system menue on windows xp and now mysql works without an issue.

The same thing happend when i tried to use mysql on coms 2 and 3 (com2, com3) they both had this same error.

It seems that any computer named com* (where * = a number) will cause innodb to fail i dont know if it is the same for other db types but it seems the case with innodb.

If anyone has there computers named to com* and has this error then try this solution, you never know it might work!

Options: ReplyQuote

Written By
March 16, 2010 11:16PM
June 12, 2009 01:06PM
July 25, 2005 08:47AM
January 20, 2006 11:38AM
April 09, 2010 05:07PM
December 09, 2007 06:57AM
Re: can't connect to MySql server on 'localhost' <10061>
March 24, 2006 12:00PM
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.