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
stuengelmanAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.