ERROR: MySQL Service not started [-1]

Problems with the Windows version of XAMPP, questions, comments, and anything related.

ERROR: MySQL Service not started [-1]

Postby aoxk61 » 21. July 2006 11:25

Hi,

I installed XAMPP so that I can test my OSCommerce shop offline, but when I go to the XAMPP control panel and click to start the MySQL service, it gives an error saying 'Error: MySQL Service not started [-1]'. I even tried reinstalling XAMPP, but the same problem still happens. I did have XAMPP installed before and I had the MySQL service working, but after I reinstalled it the first time after having uninstalled it, the problem has started.

Thanks for your help.
aoxk61
 
Posts: 1
Joined: 21. July 2006 11:17

Postby Izzy » 21. July 2006 12:28

Check and make sure that mySQL is not actually running already.
You can do this by checking in Windows Task Manager and looking for either mysqld-nt.exe or mysqld.exe in the running processes list.
You can also check the Status in the Control Panel but the Task Manager is more reliable.
If you have tried to stop the service, some times I have found that the process is still running. I have had to stop it by killing the process in the Task Manager then I can restart it in the Control Panel just fine.
Another method is to run, from a command prompt, the mysql_start.bat and see what error message it provides. Often using the .bat files can provide clues as to why these services are not starting as they should. In the xampp/mysql directory there are a couple of .bat files for installing and uninstalling the mySQL service. Try these from a command prompt and see what error messages (if any) come up.
Without knowing what these error message are anyone here can only guess what the problem might be and offer help based on that guess.
In xampp/mysql/data directory there is a *.err file. Open this in your text editor and check the last line after you have tried to start the service. It might also give you a clue.
HTH :)
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 53 guests