• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6836
  • Last Modified:

Cannot Start MySQL From XAMPP Installation

Hello,

I just installed XAMPP on Win 7.  I am having trouble starting the instance of MySQL that came with the XAMPP installer from apachefriends.org.  I can start MySQL from Windows Services or the XAMPP Control Panel, but I can't get it to be recognized as running in both.  When I start MySQL in XAMPP Control Panel, it fails to start when I try to start it in Windows Services (I get the error message "Windows could not start the MySQL56 service on local computer.  Error1067: the process terminated unexpectedly.").  When I start it in Windows Services, the XAMPP Control Panel throws an error message:

Attempting to start MySQL app...
Status change detected: running
Status change detected: stopped
Error: MySQL shutdown unexpectedly.
This may be due to a blocked port, missing dependencies,
improper privileges, a crash, or a shutdown by another method.
Press the Logs button to view error logs and check
the Windows Event Viewer for more clues
If you need more help, copy and post this
entire log window on the forums

I checked that port 3306 is open in Windows Firewall.  I also adjusted my start path for MySQL in XAMPP Control Panel ("C:\xampp\mysql/bin\mysqld" --defaults-file="C:\xampp\mysql\bin\my.ini" MySQL56), and changed my Windows registry (key="HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\MySQL56", value="C:\xampp\mysql/bin\mysqld" --defaults-file="C:\xampp\mysql\bin\my.ini" MySQL56) to use the same value (at installation, the start path referenced a non-existent folder for mysqld and my.ini).

When I start MySQL from Windows Services, MySQL56 shows in Windows Task Manager as a running service, but not as a process.   When I start MySQL from XAMPP Control panel, MySQL56 shows in Windows Task Manager as a non-running service, and again does not show as a process; trying to start MySQL56 from Windows Task Manager in this case throws the error "The operation could not be completed.  Access is denied."

At this point, my question is: how do I get MySQL56 (my instance of MySQL that was installed as part of XAMPP) to show as both a running service and process in Windows Task Manager?  I doubt I'll be able to connect to it unless I can do this.

Thanks, Stu Engelman
0
stuengelman
Asked:
stuengelman
  • 3
2 Solutions
 
stuengelmanAuthor Commented:
A correction.

Original statement: "When I start MySQL in XAMPP Control Panel, it fails to start when I try to start it in Windows Services (I get the error message "Windows could not start the MySQL56 service on local computer.  Error1067: the process terminated unexpectedly.").  When I start it in Windows Services, the XAMPP Control Panel throws an error message..."

This should read (new comment in square brackets):

"When I start MySQL in XAMPP Control Panel, it fails to start when I try to start it in Windows Services (I get the error message "Windows could not start the MySQL56 service on local computer.  Error1067: the process terminated unexpectedly.").  When I start it in Windows Services, the XAMPP Control Panel throws an error message [at push of Start button for MySQL saying...]"

Another issue may be that my.ini may have some lines commented out that need to be uncommented and filled with values, such as the MySQL user password.
0
 
stuengelmanAuthor Commented:
Here is a copy of my.ini.  This may help to determine if any lines need to be uncommented and have values assigned.
my.ini
0
 
Dave BaldwinFixer of ProblemsCommented:
It sounds to me like you have two installs of MySQL.  This key "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\MySQL56" does not exist in my version though maybe mine is just older.  The only thing I have in the registry are the key for the ODBC and Python MySQL drivers.
0
 
arnoldCommented:
You seem to be all over the place, when the mysql is step rated from services, are you looking at all user processes?
Within the location where mysql data files are there I a .err file look into it to see if it reports any errors.  Get use sysinternals procmon to see what is going on.  

The statement was made whether you have two instances.
Look at the services entry to see to wha it referes.

Try using the command line and starting the mysqld_safe directly.
0
 
stuengelmanAuthor Commented:
Hello,

Thanks to both of you for your help.  I was really desperate to get something installed, so I uninstalled XAMPP and installed UwAmp instead, which thankfully works.  It was a real mess; it took four tries to find a WAMP suite that actually installed and worked.

I'm going to close this ticket, but will award points to both of you.

Thanks for your help, Stu
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now