SitePoint Sponsor

User Tag List

Results 1 to 13 of 13
  1. #1
    SitePoint Zealot
    Join Date
    Apr 2001
    Posts
    124
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    W2K SVR - Can't start the MySql service, receiving an error

    Hey all.. I installed an Apache/MySQL/PHP/Perl package.. and mysql was started and everything was fine, until i rebooted my server.. and now i can't even start the service myself.. I tried to start it from the Services applet on the server, but received this error:

    Could not start the MySql service on Local Computer.
    Error 1067: The process terminated unexpectedly.


    Any ideas?

  2. #2
    Making a better wheel silver trophy DR_LaRRY_PEpPeR's Avatar
    Join Date
    Jul 2001
    Location
    Missouri
    Posts
    3,428
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    dang, i was getting this too back when i installed mine and i can't remember how i fixed it... did you change anything in the configuration file before the restart? how long was it running OK? weeks or just since you installed it?

    maybe you can try uninstalling the service and reinstalling it. open up the command prompt, and go to the folder where you installed MySQL and type this

    mysqld-nt -remove
    mysqld-nt -install

    maybe that could fix something, but i dunno.
    - Matt ** Ignore old signature for now... **
    Dr.BB - Highly optimized to be 2-3x faster than the "Big 3."
    "Do not enclose numeric values in quotes -- that is very non-standard and will only work on MySQL." - MattR

  3. #3
    SitePoint Zealot
    Join Date
    Apr 2001
    Posts
    124
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Larry, I didn't change anything in the configuration at all and then I restarted like it wanted me to.. After I got back in, everything was working fine until the next time that I restarted.. so it only worked for about an hour..

    I just went into my d:\foxserv\mysql\bin\ and ran those 2 commands, it looks like it might have done something because when I did the -install part, my machine hung for 2 secs.. but still the service wasn't started, nor could I start it myself..

    I'm sure it will work if I completely uninstall Foxserv and then reinstall it, but will I have to keep doing this everytime i reboot this machine? hehe

  4. #4
    SitePoint Enthusiast
    Join Date
    Dec 2001
    Location
    Romania
    Posts
    71
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Try this:
    Control Panel > Administrative Tools > Services, then double click MySQL service and push Start button in MySQL properties window.

  5. #5
    Mlle. Ledoyen silver trophy seanf's Avatar
    Join Date
    Jan 2001
    Location
    UK
    Posts
    7,168
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    What does the MySQL error file give you?

    Sean
    Harry Potter

    -- You lived inside my world so softly
    -- Protected only by the kindness of your nature

  6. #6
    SitePoint Zealot
    Join Date
    Apr 2001
    Posts
    124
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    sleepless, I've tried that over and over.. even restarting my server several times and tried it again.. but I'm still getting the error message:

    Could not start the MySql service on Local Computer.
    Error 1067: The process terminated unexpectedly.


    .. which also answers your question, Sean.
    If that's what you mean.

  7. #7
    eigo hanasemasu ka? Yes. =) ZuulJin's Avatar
    Join Date
    Dec 2001
    Location
    Japan
    Posts
    655
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    When you installed MySQL you did a custom install didn't you? I always get that problem when installing MySQL with using a custom install.

    Try re-installing MySQL with a typical install... You can still select a different directory to install to (other than c:\mysql).

    Good luck,

    [Z]
    U.S. DoD Member in Japan?
    Choose your base. Buy|Sell. Easy
    @ APO Ads.



  8. #8
    SitePoint Zealot
    Join Date
    Apr 2001
    Posts
    124
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    no actually I did a typical install..

  9. #9
    Mlle. Ledoyen silver trophy seanf's Avatar
    Join Date
    Jan 2001
    Location
    UK
    Posts
    7,168
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Have you set up the my.(extension I can't remember ) properly?

    Sean
    Harry Potter

    -- You lived inside my world so softly
    -- Protected only by the kindness of your nature

  10. #10
    SitePoint Zealot
    Join Date
    Apr 2001
    Posts
    124
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    my.ini file .. yes Sean hehe

    I'm trying NOT to restart my server.. it's been up ever since I had to reinstall my webserver package again.. hehe

  11. #11
    SitePoint Member
    Join Date
    Jan 2002
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Lightbulb I've had this before as well...

    The problem for me each time has been that I didn't install to the default C:\MySQL.

    If your heart is set on leaving it where it is, just regedit all MySQL entries to make sure the correct drive and path are there. This has worked for me on 3 separate Win2k AdvSrv machines so far.

  12. #12
    Node mutilating coot timnz's Avatar
    Join Date
    Feb 2001
    Location
    New Zealand
    Posts
    516
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Instead of using the my.ini file, make a my.cnf file, put it in the root of your c drive, containing the stuff in your my.ini file.

    I dunno but I always thought for NT you had to use the my.cnf file rather than the my.ini file, but that could just be my brain lying again. But I usually get that error if I don't have the my.cnf file in the root of c drive.

    So you could try that... and knowing my luck it probably won't help
    Oh no! the coots are eating my nodes!

  13. #13
    SitePoint Addict whofarted's Avatar
    Join Date
    Aug 2001
    Location
    lost, If you find me please return me to St.Louis
    Posts
    396
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by dim

    I'm sure it will work if I completely uninstall Foxserv and then reinstall it, but will I have to keep doing this everytime i reboot this machine? hehe
    Dang I thought it was phpdev4. I'm getting the same thing everytime I rebooted I had to recopy everything. Thats weird because there is no install in phpdev4 you just unpack it all in your C:\ and everything is fine but reboot & you've got to recopy.

    I even went through the pain of DLing & installing php/mysql/apache seperatly hoping it would fix the problem but no such luck.

    P.S. I'm on a WinXP pro box
    Last edited by whofarted; Jan 6, 2002 at 23:24.
    You smell something?


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •