MySQL will not start.

[TFlan]

I don't know how many times I have purged and reinstalled this damned program but it just will not start.

I have tried

• Installing MySQL alone
• Installing MySQL through XAMPP
• Installing MySQL through Wampserver

Every time I go to start it, I get an error. Then when it does somehow start, without an error, I go to load my database in SQLyog and it tells me:

#2003 - The server is not responding

I have tried everything. I even tried starting it through cmd.exe with "net start MySQL" and "net stop MySQL"; nothing.

I just reformatted my computer with XP Home, updated to SP3, installed all drivers, updated the .NET Framework to 3.5 SP1.

I'm outta ideas, been at it for 4 hours now. Any help will be appreciated.

 

[UndeadDragon]

Are you running it through Apache server?

 

[TFlan]

I'm running MySQL in conjunction with Apache, not through it.

EDIT::
I got it to work 100% once, then I had to restart my computer due to a new program being installed. I think that was fluke though.

 

[UndeadDragon]

Is it definately MySQL and not Apache?

 

[TFlan]

It's 100% MySQL errors.

I've reinstalled with 3 different versions, going down to 5.0 versions. The service gets stuck at "Starting" and/or "Pending Starting".

I've reinstalled with no web server on my computer and nothing else running.

 

[UndeadDragon]

Is your firewall blocking it? (I don't know if this would stop it from starting)

 

[TFlan]

Both Anti-virus and firewall are turned off.

EDIT::

Starting Error:

C:\>net start wampmysqld
The wampmysqld service is starting....................
The wampmysqld service could not be started.

More help is available by typing NET HELPMSG 3523.

C:\>net helpmsg 3523

The *** service could not be started.

Stopping Error (Ran immediately after starting):

C:\>net stop wampmysqld
The requested pause or stop is not valid for this service.

More help is available by typing NET HELPMSG 2191.

C:\>net helpmsg 2191

The requested pause or stop is not valid for this service.

No error messages are saved in the MySQL error log. Both of these errors are continuous throughout all the installations I've attempted.

HOWEVER! When I go to start the service, the process is created, but is not destroyed upon failure to start the service. The only way to end the process is to go into Task Manager and end the process "mysqld.exe". Otherwise you'll get an error stating the service is already started.

 

[Blackveiled]

Check out this thread: http://www.thehelper.net/forums/showthread.php?t=54311

 

[TFlan]

I've tried installing stand-alone (first post I made). It still produces the same errors.

I've been searching Google/MySQL.com for the past few hours and still can't find a solution that works for me. All the 'solutions' were apparently patched into the current release, but the version I'm installing still carries this bug...

 

[UndeadDragon]

How about trying a version (5.xx) that has a fix for the bug, or just to see if the bug still occurs.

 

[TFlan]

All the versions I have tried to install are the newest release, meaning it has the patch, except when I purposely went down to 5.0 to see if that would work.

 

[UndeadDragon]

Did you get the same error with 5.0?

 

[TFlan]

I fixed it. Thanks anyhow.

(And yes I got same error with 5.0. Also said in a previous post)

 

[UndeadDragon]

What was the fix?