I'm running mysql in windows server 2003 and was running well all the while. Today, my colleague execute some script and cause mysql hang. So, we have decided to restart the server. After restart the server, window service show that mysql in starting status after 20 minutes. So, i have decided to kill the process in task manager and start the service manually.
Then i hit error message "Error 1053: The service did not respond to the start or control request in a timely fashion" and fail to start mysql. I've tried to restart windows server again but it doesn't work. I'm not sure what is the reason. What i decided to do is take out the database my colleague work with previous and try to restart mysql service again. Where is mysql data file store? The location can be found in my.ini file.In my case, my file is stored in "C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1". I cut the paste the database out of the folder and restart mysql. It's work!!
Hope this experience can share with friend who hit the similar scenario. For friends who face the same error, maybe this link might helps http://support.microsoft.com/kb/886695
