stuengelman
asked on
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\mysql d" --defaults-file="C:\xampp\ mysql\bin\ my.ini" MySQL56), and changed my Windows registry (key="HKEY_LOCAL_MACHINE\S YSTEM\Curr entControl Set\servic es\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
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\mysql
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
ASKER
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
my.ini
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
ASKER
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.