server mysql.bat blocks
| User, date | Message |
|---|---|
|
Written by Dariuszz
3 years ago Category: Creating a connection 24 posts since Sat, 09 Jan 10 |
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? |
|
Written by ansgar
3 years ago 3958 posts since Fri, 07 Apr 06 |
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. |
|
Written by Dariuszz
3 years ago 24 posts since Sat, 09 Jan 10 |
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. |
|
Written by ansgar
3 years ago 3958 posts since Fri, 07 Apr 06 |
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. |
|
Written by Dariuszz
3 years ago 24 posts since Sat, 09 Jan 10 |
Ofcourse I leave the console window open  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 help
|
|
Written by ansgar
3 years ago 3958 posts since Fri, 07 Apr 06 |
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... |
|
Written by Dariuszz
3 years ago 24 posts since Sat, 09 Jan 10 |
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 with.
|
|
Written by Dariuszz
3 years ago 24 posts since Sat, 09 Jan 10 |
could it be the server's version's fault? |
|
Written by ansgar
3 years ago 3958 posts since Fri, 07 Apr 06 |
Well as long as you don't post any error message here I can just keep guessing. |
|
Written by Dariuszz
3 years ago 24 posts since Sat, 09 Jan 10 |
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. |