SQL Error (2003): Can't connect to MySQL server on 'localhost' (10061)

User, date Message
Written by gladiator6
2 years ago
Category: Creating a connection
3 posts since Tue, 04 Oct 11 		I try to use Heidi Portable , try and with 6.0 stable but nothing same problem I try to use Windows XP and Windows 7 I check twice the ssh tunel and plink.exe file and same error I try and on virtual pc but nothing :(
Please help me this work on my friends PC-s they also try to help me I install mysql I know it's not in requarements but nothing. I use new localhost file but nothing try to install xaamp but he don't fix the problem please help me.
Written by ansgar
2 years ago
3951 posts since Fri, 07 Apr 06 		Adding some commas and dots for readers would be really cool man :)

So, you have a locally installed server and on the same pc you want to use HeidiSQL? Just stick to "MySQL (TCP/IP)" connection, use "localhost" and "3306" as the right port. And, ensure the server is really running.
Written by gladiator6
2 years ago
3 posts since Tue, 04 Oct 11 		Thank You.
Sorry abut commas and dots.smileI will try to fix that i future.
I need to use localhost because my server need to be logged from SSH tunel.
I also alredy install XAMPP and mysql service running try to connect using php and apache return Connected successfully.
But I still can't log in to Heidi SQL using 127.0.0.1 or localhost.
Please give me some advice how to fix this :(
Thank You in advance I think I need to have mysql before connect to my server using ssh tunel ? or ?
Written by gladiator6
2 years ago
3 posts since Tue, 04 Oct 11 		When I use 127.0.0.1 don't work but when I try with localhost work fine to conect using php ...
Written by spwestwood
2 years ago
2 posts since Fri, 01 Apr 11 		I get this message when trying to connect over SSH tunnel. The same settings/user/pass work via command line and using MySQL bench.
This is only happening on certain servers, via SSH works fine on others.
Written by xxXxxrbj
1 year ago
4 posts since Wed, 25 Jan 12 		can any one help me then i connect it Say same i try all thing but i dont know what is the user name and the password !!!!! surprisedsurprisedsurprisedsurprisedunhappyunhappyunhappyunhappyunhappy
Written by jfalch
1 year ago
222 posts since Sat, 17 Oct 09 		xxX.. "then i connect it Say same" - what is that supposed to mean ? english it isn´t.
what user name / password do you not know ?
if you don´t know your database´s u/p, ask your provider.
If you don´t know SSH access u/p, ask your provider.
If you dont´know which u/p to type into one of HeidiSQL´s dialogs, specify dialog (session manager?) and page title (headers on top right of session manager).
Written by jfalch
1 year ago
222 posts since Sat, 17 Oct 09 		PS: calm down. this is not a kid´s playground. Using more than one exclamation point per sentence, or more than one emoticon per entry, will nearly guarantee that your post is either a) completely disregarded, or b) meets with an unfavorable response.
Written by yogeshwari
1 year ago
2 posts since Wed, 01 Feb 12 		Hey Plz help me out with this error->
SQL ERROR(2003): Can't connect to MySQL server on localhost(10061)
Written by ansgar
1 year ago
3951 posts since Fri, 07 Apr 06 		No server installed on your local machine?
Written by yogeshwari
1 year ago
2 posts since Wed, 01 Feb 12 		I have installed apache , but still its showing an error
Written by ansgar
1 year ago
3951 posts since Fri, 07 Apr 06 		Eh, so you have installed Apache, a webserver. Where did you read HeidiSQL can connect to Apache? You need MySQL, not Apache.
Written by kthanid
1 year ago
15 posts since Mon, 30 Jan 12 		I laughed entirely too hard at this. :)
Written by xxXxxrbj
1 year ago
4 posts since Wed, 25 Jan 12 		guys help me~!!!!!!unhappyunhappyunhappyunhappyunhappyunhappyunhappyunhappystill error
Written by jfalch
1 year ago
222 posts since Sat, 17 Oct 09 		xxXxxrbj, if you do give more information on what exactly your problem is, nobody will be able to help you. "dont know what is the user name and the password" is not sufficient.
Written by xxXxxrbj
1 year ago
4 posts since Wed, 25 Jan 12 		its say SQL Error (2003): Can't connect to MySQL server on 'localhost' (10061)
Written by kthanid
1 year ago
15 posts since Mon, 30 Jan 12 		Also, not hijacking other threads is probably a good start.

If the server is running and you have forgotten your username and password you can reset the root password.
Written by kthanid
1 year ago
15 posts since Mon, 30 Jan 12 		@xxXxxrbj: Again, you are providing almost no information of value.
Written by xxXxxrbj
1 year ago
4 posts since Wed, 25 Jan 12 		i dont know what it say i dont understand unhappyunhappyunhappy
Written by kthanid
1 year ago
15 posts since Mon, 30 Jan 12 		Let me try and make it clear:

* We know nothing about the server you are connecting to.

* We have no idea what username you are connecting with.

* We have no idea what your password might be, even if we knew the user (how could we know?).

* I have already given you a link to locally reset your root MySQL password.

* Your question has NOTHING to do with HeidiSQL specifically.

What else do you propose we do to help you?
Written by jfalch
1 year ago
222 posts since Sat, 17 Oct 09 		to start:
what type of database server are you using ? do you run it yourself on one of youtr machines, or are you using a server of your internet provider ?
what method is set in heidisql to access this server ? tcp/ip, ssh tunnel, or what ?
 

Please login to leave a reply, or register at first.