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

server mysql.bat blocks

Dariuszz posted 5 years ago in Creating a connection
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 posted 5 years ago
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 posted 5 years ago
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.
ansgar posted 5 years ago
Did you leave the console window open?

Dariuszz wrote: 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 posted 5 years ago
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 posted 5 years ago
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 posted 5 years ago
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 posted 5 years ago
could it be the server's version's fault?
ansgar posted 5 years ago
Well as long as you don't post any error message here I can just keep guessing.
Dariuszz posted 5 years ago
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.