Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

server mysql.bat blocks

Dariuszz's profile image Dariuszz posted 10 years ago in Creating a connection Permalink
K i'm back with another problem but I begin to get it now. When I want to open the server mysql.bat, it starts to block and gives me the following message (on cmd.exe ofcourse):

Please don't close Window while MySQL is running
MySQL is trying to start
Please wait ...
MySQL is starting with mysql\bin\my.cnf <console>

It seems that my.cnf doesn't want to run now and therefore my command window starts to block and I can't turn it off, unless I restart my computer. Now I'd like to know why my mysql.bat doesn't finish and go correctly. Anyone knows?
ansgar's profile image ansgar posted 10 years ago Permalink
my.cnf is a text file, holding settings for the MySQL server. I can only guess the last line ("MySQL is starting") is very ok and you should just keep the window open. The server itself may not add another line to the console. So, just keep that console window open and try to connect via HeidiSQL.
Dariuszz's profile image Dariuszz posted 10 years ago Permalink
Yeah but that's the main problem. There should be more after "MySQL is starting". It looks like the program starts MySQL but does not finish the function to start. I don't know why but MySQL started before on my computer without problem, with more text after "MySQL is starting". After restarting my computer it didn't finish it's command anymore and I couldn't enter HeidiSQL.
Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
ansgar's profile image ansgar posted 10 years ago Permalink
Did you leave the console window open?

There should be more after...



I don't think so. At least the very normal MySQL server doesn't write anything onto stdout when starting.
Dariuszz's profile image Dariuszz posted 10 years ago Permalink
Ofcourse I leave the console window open happy But it's only the MySQL console what i'm worrying about. I can't turn it off. Not with the x button, nor with alt-ctrl-delete and not even at processes can I turn it off. The console is only taking less memory on my computer after i tried to turn it off. The MySQL console isn't finishing starting up and blocks half way. That's the annoying conclusion :p Please helpsmile
ansgar's profile image ansgar posted 10 years ago Permalink
Any server software needs to stay in memory as long as you want to connect to it, and so does your cmd console. It's so simple, you need this console, don't try to turn it off if you want to connect via HeidiSQL...
Dariuszz's profile image Dariuszz posted 10 years ago Permalink
hah ye I know I don't need to turn off the console. But it just keeps blocking when I start it. And I waited allready for a long time (hours) hoping it would unblock, without result. By the way I can't open HeidiSQL because of the blocked console, which, when pressing connect, gives me an error. The error all the commotion started withsmile.
Dariuszz's profile image Dariuszz posted 10 years ago Permalink
could it be the server's version's fault?
ansgar's profile image ansgar posted 10 years ago Permalink
Well as long as you don't post any error message here I can just keep guessing.
Dariuszz's profile image Dariuszz posted 10 years ago Permalink
The error was:

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

when I wanted to start HeidiSQL.

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