Apache Friends Support Forum

It's really frustrating. Nothing I do can make MySQL to work. Furthermore, all the check boxes at the left side in control panel are grey and nothing happens when I click them. I believe there are some serious bugs going on...

Hi 3-4-SAD,

It is really difficult (and frustrating too) to provide support in a thread where multiple users try to report unsolved issues.
All issues can be different even the effect seems to be the same.
None of the error reports is detailed enough.

So if you really want to get help please open a new thread and report your issue as detailed as possible.
absolutely neccessary informations are:

• your OS version (win 7 is NOT enough here. Windows 7 Embedded Standard 32Bit is very much different to Windows 7 Enterprise 64Bit)
• your XAMPP version (not only the version number, but also the type (full|lite|portable, exe|zip|7z)
• informations about the actions you did to "install" XAMPP (especially installation path, executed files)
• informations about changes in the config files if any done
• actions done to produce/reproduce the issue
• full contents of your XAMPP control panel log window
• relevant contents of the specific log files (related to MySQL especially the entries since start attempt in the mysql_error.log)

after knowing all of this information maybe more information are needed but that are the very basic ones needed for nearly every issue.
I have not seeing any of that information from you. And saying you have the same issue is worthless because you simply can't estimate that.

best wishes,
Altrea

Altrea, You're absolutely right. I apologize for my unclear comment.
Here it goes everything you have sprecified:

• your OS version (win 7 is NOT enough here. Windows 7 Embedded Standard 32Bit is very much different to Windows 7 Enterprise 64Bit)
My system is win 7 pro 64

• your XAMPP version (not only the version number, but also the type (full|lite|portable, exe|zip|7z)
xampp-win32-1.8.3-0-VC11

• informations about the actions you did to "install" XAMPP (especially installation path, executed files)
I've executed the xampp-win32-1.8.3-0-VC11-installer.exe directly to C:\xampp

• informations about changes in the config files if any done
Haven't touch anything

• actions done to produce/reproduce the issue
After the install everything worked fine. After the machine reboot, I can't start MySQL service.
If I uninstall xampp and reinstall it again MySQL works, but only up to the next system reboot.

• full contents of your XAMPP control panel log window
10:40:10 [main] Initializing Control Panel
10:40:10 [main] Windows Version: Windows 7 Professional SP1 64-bit
10:40:10 [main] XAMPP Version: 1.8.3
10:40:10 [main] Control Panel Version: 3.2.1 [ Compiled: May 7th 2013 ]
10:40:10 [main] You are not running with administrator rights! This will work for
10:40:10 [main] most application stuff but whenever you do something with services
10:40:10 [main] there will be a security dialogue or things will break! So think
10:40:10 [main] about running this application with administrator rights!
10:40:10 [main] XAMPP Installation Directory: "c:\xampp\"
10:40:10 [main] Checking for prerequisites
10:40:11 [main] All prerequisites found
10:40:11 [main] Initializing Modules
10:40:11 [Apache] Initializing module...
10:40:11 [Apache] Checking for module existence...
10:40:11 [Apache] Checking for required tools...
10:40:11 [Apache] Checking for service (name="Apache2.4"): Service not installed
10:40:11 [Apache] Service Path: Service Not Installed
10:40:11 [Apache] Checking default ports...
10:40:11 [mysql] Initializing module...
10:40:11 [mysql] Checking for module existence...
10:40:11 [mysql] Checking for required tools...
10:40:11 [mysql] Checking for service (name="mysql"): Service not installed
10:40:11 [mysql] Service Path: Service Not Installed
10:40:11 [mysql] Checking default ports...
10:40:11 [filezilla] Initializing module...
10:40:11 [filezilla] Checking for module existence...
10:40:11 [filezilla] Checking for required tools...
10:40:11 [filezilla] Checking for service (name="FileZillaServer"): Service not installed
10:40:11 [filezilla] Service Path: Service Not Installed
10:40:11 [filezilla] Checking default ports...
10:40:11 [mercury] Initializing module...
10:40:11 [mercury] Checking for module existence...
10:40:11 [mercury] Checking for required tools...
10:40:11 [mercury] Checking default ports...
10:40:11 [Tomcat] Initializing module...
10:40:11 [Tomcat] Checking for module existence...
10:40:11 [Tomcat] Checking for required tools...
10:40:11 [Tomcat] Checking for service (name="Tomcat7"): Service not installed
10:40:11 [Tomcat] Service Path: Service Not Installed
10:40:11 [Tomcat] Checking default ports...
10:40:11 [main] Starting Check-Timer
10:40:11 [main] Control Panel Ready
10:40:23 [Apache] Checking default ports...
10:40:23 [Apache] Attempting to start Apache app...
10:40:23 [Apache] Executing "c:\xampp\apache\bin\httpd.exe"
10:40:23 [Apache] Return code: 0
10:40:23 [Apache] Status change detected: running
10:49:43 [mysql] Checking default ports...
10:49:43 [mysql] Attempting to start MySQL app...
10:49:43 [mysql] Executing ""c:\xampp\mysql\bin\mysqld.exe" --defaults-file="c:\xampp\mysql\bin\my.ini" --standalone"
10:49:43 [mysql] Return code: 0
10:49:43 [mysql] Status change detected: running
10:49:45 [mysql] Status change detected: stopped
10:49:45 [mysql] Error: MySQL shutdown unexpectedly.
10:49:45 [mysql] This may be due to a blocked port, missing dependencies,
10:49:45 [mysql] improper privileges, a crash, or a shutdown by another method.
10:49:45 [mysql] Press the Logs button to view error logs and check
10:49:45 [mysql] the Windows Event Viewer for more clues
10:49:45 [mysql] If you need more help, copy and post this
10:49:45 [mysql] entire log window on the forums

Thanks for the help.

Okay, so we can say that the grayed out service icons (green tick / red cross) are no bug on your system. You didn't started the control panel with elevated administrator rights, but that is a requirement for all things doing with windows services.

Next thing we need is the contents of your mysql_error.log file.
And maybe you can check with help of the netstat tool in the control panel if some process is already using port 3306.

Hello,

In addition, you are running MySQL in standalone mode (not as a Service). Did you try my original suggestion to the person in the other post with this issue to try running MySQL as a Service (green check in the Service column of the Control Panel - requires running XAMPP Control Panel with Admin privileges)?

Altrea; I have started cpanel as admin so now I can click the check boxes

hackattack142; I have tried that but no luck

Still can't start MySQL.
Here is the log: https://dl.dropboxusercontent.com/u/28273596/mysql_error.log
Netstat is showing that 3306 isn't occupied by any process

Thanks for the help guys...

I think you are struggling with this problem:

http://bugs.mysql.com/bug.php?id=67595

Nobbie, thanks a zillion.
That was it!

Who knew those files had to be deleted?!
I owe you a beer.

3-4-SAD wrote:I owe you a beer.

Lovely - where and when?