distal-attribute
distal-attribute
distal-attribute
distal-attribute

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

User, date Message
Written by Dariuszz
4 years ago
Category: Creating a connection
24 posts since Sat, 09 Jan 10
I want to make my own private server for World of Warcraft but I've got an issue on connecting with HeidiSQL. I keep getting this error:
SQL Error: can't connect to MySQL server on 'localhost' (10061)

For as long as I know I'm not making any problems.
IP: localhost
User: root
Password: ascent

and I also start MySQL.bat before using HeidiSQL.

I'd really appreciate if someone could help me.
Written by Dariuszz
4 years ago
24 posts since Sat, 09 Jan 10
by the way I installed the HeidiSQL 4.0 from:
http://www.heidisql.com/download.php

I've only installed one thing, the "installer" part on the site. I hope that isn't the problem.
Written by ansgar
4 years ago
4800 posts since Fri, 07 Apr 06
Right, that is definitely not the problemsmileThe problem is, your local MySQL server is not responding, I guess it is not runnin at all. See taskmanager and watch for mysqld.exe .
Written by Dariuszz
4 years ago
24 posts since Sat, 09 Jan 10
yes that one is on with around 200kb memory. Just don't get it. I was looking for the solution for hours and didn't understand what was wrong :(
Written by Dariuszz
4 years ago
24 posts since Sat, 09 Jan 10
I hope you or anyone else knows a solution
Written by ansgar
4 years ago
4800 posts since Fri, 07 Apr 06
Did you check this?
Written by Dariuszz
4 years ago
24 posts since Sat, 09 Jan 10
ok i see a problem now. It says I don't have a service called MySQL. Where can i download or install the service?
Written by Dariuszz
4 years ago
24 posts since Sat, 09 Jan 10
ah still doesn't work. Found a service but still the same error.
Written by Dariuszz
4 years ago
24 posts since Sat, 09 Jan 10
ok this is the thing:
i'm following this tutorial:
http://www.youtube.com/watch?v=1y5KtoQqMrc

At 3:30 he starts to login on HeidiSQL.
When he connects he enters the server. At that point I don't enter the server, but I get the error instead. Maybe this will get you an idea?
Written by Dariuszz
4 years ago
24 posts since Sat, 09 Jan 10
Aha now I found the solution :p
man what a stupid program.
I needed to FIRST run the service and THEN run the MySQL.bat.
Well thank you for your help anywayssmileat least someone answers my questions after all :D
Written by ansgar
4 years ago
4800 posts since Fri, 07 Apr 06
Don't know what your mysql.bat should do, but it's not some standard method to get MySQL running. Normally you start the server and then you can connect via any client like HeidiSQL.
Written by Dariuszz
4 years ago
24 posts since Sat, 09 Jan 10
darn smiled too fast. now it doesn't work anymore. what server are you talking about?
Written by Dariuszz
4 years ago
24 posts since Sat, 09 Jan 10
when i open mysql.bat it says that mysql is running. i'm not used to such a things like mysql. I only play games smile
Written by ansgar
4 years ago
4800 posts since Fri, 07 Apr 06
Well no problem to play games. That should not stop you from getting into MySQL or?

I meant the MySQL server. Try to do this:
- Start -> run -> cmd.exe
- Type this into the black DOS box:
mysql -hlocalhost -uroot -hascent<Enter>
- Post here what error you get
Written by Dariuszz
4 years ago
24 posts since Sat, 09 Jan 10
uh my computer can't recognize mysql.
Written by Dariuszz
4 years ago
24 posts since Sat, 09 Jan 10
i get the same error as if i would write "asdfasfadsf" (some random letters)
Written by Dariuszz
4 years ago
24 posts since Sat, 09 Jan 10
well i wrote "mysql -hlocalhost -uroot -hascent" hope that was correct.
Written by Dariuszz
4 years ago
24 posts since Sat, 09 Jan 10
i guess mysql.bat is the server because it's in the folder called Server, but he does not load completely. It says:

Please close this command only for Shutdown.
MySQL is running, don't close this window.

Somehow before when i "found the solution" it showed more than the 2 lines.
Written by mltsy
4 years ago
1 posts since Mon, 19 Jul 10
Although this post is years old, just in case someone else is getting this error, as I recently did:

I unchecked the "compressed client/server protocol" checkbox and was able to connect. Not sure if that was the problem or not, because now I can check it and still log in fine, but that's all I recall changing. Although I also logged into SSH using putty and tried "mysql -uUSER_NAME -p" to test the connection between when it wasn't working and when it was, so that may have changed something as well.
Written by Dariuszz
4 years ago
24 posts since Sat, 09 Jan 10
It is alright now. I have a Norton antivirus from 2005 and it blocked most of the things I wanted to start. When I figured that out I turned off Norton and all worked fine. I have heard of other people also having issues with old Norton versions on recent computers. So if anyone still has got an old Norton antivirus, just delete it, download an other free antivirus and your worries are gone :)
Written by dogra_vj
4 years ago
2 posts since Fri, 30 Jul 10
hi..I am getting the same error altough i tried the following
- Start -> run -> cmd.exe
mysql -hlocalhost -uroot -hascent

after this I am getting "It is not recognised as internal or exteral command, operable program or batch file"

Please help

Thanks
Written by ansgar
4 years ago
4800 posts since Fri, 07 Apr 06
Man, this is of course because your mysql.exe is not located in your path environment. Just add the path and it should run. Additionally, you have two "-h" parameters which cannot be correct as h means "Host". I guess "ascent" is your password - if so that must be prefixed by "-p", not "-h":
c:\Program Files\MySQL Server XYZ\bin\mysql.exe -hlocalhost -uroot -pascent

Apart from that, you should NEVER post any password in a public forum - that's totally dumb.
Written by dogra_vj
4 years ago
2 posts since Fri, 30 Jul 10
Thanks for the prompt response...what I posted above was the information as per your earlier post posted on 09 Jan 10..so I am not sharing my detailssmileI fixed the problem by reinstalling the whole thing again saving my data files..I guess some thing was missing...now its working..Thanks for you help
Written by DevinHeaven
3 years ago
1 posts since Wed, 27 Oct 10
I figured of the problem for those who are trying to make a WoW Private Server...

This NEEDS to be open while you are using it...

Go to Corruption Productions BlizzPack/Server/MySQL.exe (Or Windows Batch File)

As long as you have that open... Your SQL should work...

If it doesn't Message me on Youtube because I'm leaving this forum and I'm not coming back...
Youtube Username: Yournothawt
Written by mjnoon88
3 years ago
1 posts since Sat, 23 Jul 11
i get the same error i restart the server

bet it steel not working unhappyunhappyunhappy
 

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