MySQL will not start.

T

TFlan

I could change this in my User CP.
Reaction score
64
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
Click to expand...

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

UndeadDragon

Super Moderator
Reaction score
447
Are you running it through Apache server?
 
T

TFlan

I could change this in my User CP.
Reaction score
64
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

UndeadDragon

Super Moderator
Reaction score
447
Is it definately MySQL and not Apache?
 
T

TFlan

I could change this in my User CP.
Reaction score
64
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

UndeadDragon

Super Moderator
Reaction score
447
Is your firewall blocking it? (I don't know if this would stop it from starting)
 
T

TFlan

I could change this in my User CP.
Reaction score
64
Both Anti-virus and firewall are turned off.

EDIT::

Starting Error:
Code: 
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):
Code: 
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.
 
T

TFlan

I could change this in my User CP.
Reaction score
64
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

UndeadDragon

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

TFlan

I could change this in my User CP.
Reaction score
64
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

UndeadDragon

Super Moderator
Reaction score
447
Did you get the same error with 5.0?
 
T

TFlan

I could change this in my User CP.
Reaction score
64
I fixed it. Thanks anyhow.

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

UndeadDragon

Super Moderator
Reaction score
447
What was the fix?
 
You must log in or register to reply here.
General chit-chat
Help Users
  • No one is chatting at the moment.
  • Varine Varine:
    How can you tell the difference between real traffic and indexing or AI generation bots?
  • The Helper The Helper:
    The bots will show up as users online in the forum software but they do not show up in my stats tracking. I am sure there are bots in the stats but the way alot of the bots treat the site do not show up on the stats
  • The Helper The Helper:
    New recipe is Shipwreck Dinner - https://www.thehelper.net/threads/recipe-shipwreck-dinner.193511/
  • Varine Varine:
    I want to build a filtration system for my 3d printer, and that shit is so much more complicated than I thought it would be
  • Varine Varine:
    Apparently ABS emits styrene particulates which can be like .2 micrometers, which idk if the VOC detectors I have can even catch that
  • Varine Varine:
    Anyway I need to get some of those sensors and two air pressure sensors installed before an after the filters, which I need to figure out how to calculate the necessary pressure for and I have yet to find anything that tells me how to actually do that, just the cfm ratings
  • Varine Varine:
    And then I have to set up an arduino board to read those sensors, which I also don't know very much about but I have a whole bunch of crash course things for that
  • Varine Varine:
    These sensors are also a lot more than I thought they would be. Like 5 to 10 each, idk why but I assumed they would be like 2 dollars
  • Varine Varine:
    Another issue I'm learning is that a lot of the air quality sensors don't work at very high ambient temperatures. I'm planning on heating this enclosure to like 60C or so, and that's the upper limit of their functionality
  • Varine Varine:
    Although I don't know if I need to actually actively heat it or just let the plate and hotend bring the ambient temp to whatever it will, but even then I need to figure out an exfiltration for hot air. I think I kind of know what to do but it's still fucking confusing
  • The Helper The Helper:
    Maybe you could find some of that information from AC tech - like how they detect freon and such
  • Varine Varine:
    That's mostly what I've been looking at
  • Varine Varine:
    I don't think I'm dealing with quite the same pressures though, at the very least its a significantly smaller system. For the time being I'm just going to put together a quick scrubby box though and hope it works good enough to not make my house toxic
  • Varine Varine:
    I mean I don't use this enough to pose any significant danger I don't think, but I would still rather not be throwing styrene all over the air
  • The Helper The Helper:
    New dessert added to recipes Southern Pecan Praline Cake https://www.thehelper.net/threads/recipe-southern-pecan-praline-cake.193555/
  • The Helper The Helper:
    Another bot invasion 493 members online most of them bots that do not show up on stats
  • Varine Varine:
    I'm looking at a solid 378 guests, but 3 members. Of which two are me and VSNES. The third is unlisted, which makes me think its a ghost.
     +1
  • The Helper The Helper:
    Some members choose invisibility mode
     +1
  • The Helper The Helper:
    Latest Recipe is Garlic Parmesan Chicken https://www.thehelper.net/threads/recipe-garlic-parmesan-chicken.193575/
  • The Helper The Helper:
    I bitch about Xenforo sometimes but it really is full featured you just have to really know what you are doing to get the most out of it.
  • The Helper The Helper:
    It is just not easy to fix styles and customize but it definitely can be done
  • The Helper The Helper:
    I do know this - xenforo dropped the ball by not keeping the vbulletin reputation comments as a feature. The loss of the Reputation comments data when we switched to Xenforo really was the death knell for the site when it came to all the users that left. I know I missed it so much and I got way less interested in the site when that feature was gone and I run the site.
  • Blackveiled Blackveiled:
    People love rep, lol
     +1
  • The Helper The Helper:
    The recipe today is Sloppy Joe Casserole - one of my faves LOL https://www.thehelper.net/threads/sloppy-joe-casserole-with-manwich.193585/
  • The Helper The Helper:
    Decided to put up a healthier type recipe to mix it up - Honey Garlic Shrimp Stir-Fry https://www.thehelper.net/threads/recipe-honey-garlic-shrimp-stir-fry.193595/

      The Helper Discord

      Members online

      Online now:
      322 (members: 1, guests: 321)

      Share this page

      Affiliates

      Hive Workshop NUON Dome World Editor Tutorials

      Network Sponsors

      Apex Steel Pipe - Buys and sells Steel Pipe.
      Top