Bug: ERROR: MySql service not started [-1]

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

Bug: ERROR: MySql service not started [-1]

Postby hm2k » 14. January 2009 13:18

Image
Image

ERROR: MySql service not started [-1]


How do I resolve this error?
hm2k
 
Posts: 7
Joined: 30. July 2006 21:15

Re: Bug: ERROR: MySql service not started [-1]

Postby Wiedmann » 14. January 2009 13:23

How do I resolve this error?

Look into the Windows event log what's the problem. (I can't read your event log.)
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Bug: ERROR: MySql service not started [-1]

Postby ckosloff » 15. January 2009 01:16

Wiedmann wrote:Look into the Windows event log what's the problem. (I can't read your event log.)

I am getting the same error on XP SP3 32-bit, Xampp 1.7.0 + patch.
When attempting to start the service from Services Console, Windows reports error, it cannot find file.
The screenshot is not exactly the same as shown, Apache starts but mysql does not, and Admin button is not active.
I have totally uninstalled and reinstalled since to no avail.
Funny thing is a previous version works flawlessly in another computer.
Checked event log, but don't know which application to look for, if I did I could filter View and tell you exactly what it is.
Please I need to develop on this other computer too.
Thanks.
Carlos K.
ckosloff
 
Posts: 37
Joined: 10. May 2007 16:35
Location: South Florida

Re: Bug: ERROR: MySql service not started [-1]

Postby w4vy » 15. January 2009 01:20

Did you start the xampp console with Admin privileges ?
Image
User avatar
w4vy
 
Posts: 153
Joined: 04. June 2008 09:58
Location: England

Re: Bug: ERROR: MySql service not started [-1]

Postby Wiedmann » 15. January 2009 02:27

When attempting to start the service from Services Console, Windows reports error, it cannot find file.

Delete the installed MySQL service and recreate it with the bachtfile.

Checked event log, but don't know which application to look for,

"mysql" (if you try to start this service)
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Bug: ERROR: MySql service not started [-1]

Postby ckosloff » 15. January 2009 23:33

w4vy wrote:Did you start the xampp console with Admin privileges ?

Yes, it's my computer and my account has admin privileges.
Funny thing is that I also installed xampp 1.7 on Vista 64, with UAC disabled, and it worked fine there.
Carlos K.
ckosloff
 
Posts: 37
Joined: 10. May 2007 16:35
Location: South Florida

Re: Bug: ERROR: MySql service not started [-1]

Postby ckosloff » 15. January 2009 23:41

Wiedmann wrote:Delete the installed MySQL service and recreate it with the bachtfile.

Please post full instructions on how to do this. Thanks.

"mysql" (if you try to start this service)

no "mysql" entry in there.
Carlos K.
ckosloff
 
Posts: 37
Joined: 10. May 2007 16:35
Location: South Florida

Re: Bug: ERROR: MySql service not started [-1]

Postby Wiedmann » 16. January 2009 12:01

no "mysql" entry in there.

Not really possible, because the svc-box is checked in your control panel.

Please post full instructions on how to do this. Thanks.

Wiedmann wrote:Delete the installed MySQL service

Code: Select all
sc delete mysql


Wiedmann wrote:and recreate it with the bachtfile.

Code: Select all
\xampp\mysql\mysql_installservice.bat
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Bug: ERROR: MySql service not started [-1]

Postby gherk55512 » 16. January 2009 17:03

I have the same error as well (ERROR: MySql service not started [-1]). When my computer boots up, I continuously receive the following error on the Desktop until I manage to shut down the service (icon with traffic lights).

Win MySqlAdmin 1.4
Access violation at address 1000A1F7 in module LIBMYSQL.DLL. Read of address 00000000.

My computer OS is WinXP Service Pack 3, XAMPP 1.7.0 with xampp-patch2-win32-1.7.0 installed. Despite uninstalling and reinstalling program with and without patch, the error is consistent.

Cheers,
John
gherk55512
 
Posts: 2
Joined: 16. January 2009 16:32

Re: Bug: ERROR: MySql service not started [-1]

Postby ckosloff » 16. January 2009 17:21

gherk55512 wrote:I have the same error as well (ERROR: MySql service not started [-1]).My computer OS is WinXP Service Pack 3, XAMPP 1.7.0 with xampp-patch2-win32-1.7.0 installed. Despite uninstalling and reinstalling program with and without patch, the error is consistent.

Yeah, same thing here, haven't tried yet the fix proposed by Wiedmann, will post results here.
I have an older version of XAMPP working flawlessly on another computer, with same 32-bit OS, so I think that there is a bug in latest release.
Carlos K.
ckosloff
 
Posts: 37
Joined: 10. May 2007 16:35
Location: South Florida

Re: Bug: ERROR: MySql service not started [-1]

Postby gherk55512 » 16. January 2009 17:51

Not entirely sure how, but I managed to get MySql working again. I tried Wiedmann's suggestion, but could not determine exactly how his instructions should be implemented. So, I went to the XAMPP/MYSQL folder and double-clicked on mysql-uninstallservice.bat, then resetroot.bat, and mysql_installservice.bat. It worked fine and computer boots up without the error code I mentioned earlier. Thanks for the help.

Cheers,
John
gherk55512
 
Posts: 2
Joined: 16. January 2009 16:32

Re: Bug: ERROR: MySql service not started [-1]

Postby glitzi85 » 16. January 2009 18:47

To get rid of the Access Violation error message just remove this program from your Startup folder. The tool is not needed, also make sure never to click on the Admin button for MySQL.

glitzi
User avatar
glitzi85
 
Posts: 1920
Joined: 05. March 2004 23:26
Location: Dahoim

Re: Bug: ERROR: MySql service not started [-1]

Postby ckosloff » 16. January 2009 22:22

gherk55512 wrote:I went to the XAMPP/MYSQL folder and double-clicked on mysql-uninstallservice.bat, then resetroot.bat, and mysql_installservice.bat.

I never got errors at startup, just my sql server not starting and Admin button dimmed (not active).
What you did is simply more visual than the Run commands Wiedmann posted.
Let me ask you, does mysql run at startup as a service, just like Apache?
I never had problems with Apache server, just mysql.
Carlos K.
ckosloff
 
Posts: 37
Joined: 10. May 2007 16:35
Location: South Florida

Re: Bug: ERROR: MySql service not started [-1]

Postby ckosloff » 16. January 2009 22:23

glitzi85 wrote:make sure never to click on the Admin button for MySQL. glitzi

Please explain why not.
Thanks.
Carlos K.
ckosloff
 
Posts: 37
Joined: 10. May 2007 16:35
Location: South Florida

Re: Bug: ERROR: MySql service not started [-1]

Postby ckosloff » 17. January 2009 01:41

Wiedmann wrote:
no "mysql" entry in there.

Not really possible, because the svc-box is checked in your control panel.

No, maybe you are looking at the screenshot, that is not mine.
My service box was not checked.
Thanks anyway.
Carlos K.
ckosloff
 
Posts: 37
Joined: 10. May 2007 16:35
Location: South Florida

Next

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 63 guests