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