SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Evangelist Alexandra's Avatar
    Join Date
    Aug 2002
    Location
    Perth, Australia
    Posts
    414
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question MySQL Installation Trouble

    Hi!

    I am trying to install MySQL on an Apache server running off Windows XP Home. I have installed MySQL as a service and the command prompt states this was done successfully.

    However, when I try to start the service, I get the following error:
    The MySQL service is starting.
    The MySQL service could not be started.
    A system error has occurred.
    System error 1067 has occurred.
    The process terminated unexpectedly.
    Can anybody tell me why this happening and how to correct it?

    I have setup the my.cnf file as it tells me to, and have followed the book to the letter, I don't see why it doesn't work. Any help would be greatly appreciated.

    Regards,

    A.
    Alex Graham
    Cadmium Design & Development
    www.cadmium.com.au
    alexandra@cadmium.com.au

  2. #2
    SitePoint Evangelist Alexandra's Avatar
    Join Date
    Aug 2002
    Location
    Perth, Australia
    Posts
    414
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    All fixed...it turned out even though I had told XP not to hide known file extensions, it had hidden the .cnf, so the file was called my.cnf.cnf.
    Alex Graham
    Cadmium Design & Development
    www.cadmium.com.au
    alexandra@cadmium.com.au

  3. #3
    Apache Expert i_like_php's Avatar
    Join Date
    Nov 2001
    Location
    Dallas, Texas
    Posts
    1,342
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Alexandra
    All fixed...it turned out even though I had told XP not to hide known file extensions, it had hidden the .cnf, so the file was called my.cnf.cnf.
    what was the problem exactly, because my friend is having this same problem on his xp home machine?
    i love php

  4. #4
    Prolific Blogger silver trophy Technosailor's Avatar
    Join Date
    Jun 2001
    Location
    Before These Crowded Streets
    Posts
    9,446
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The problem was it had no config file. MySQL needs my.cnf to run. There was no my.cnf, but there was a my.cnf.cnf. By default, Windows hides the .cnf extension so when she renamed her sample file my.cnf, it was actually renaming it my.cnf.cnf thus taking the config file away from MySQL preventing it from starting.

    Aaron
    Aaron Brazell
    Technosailor




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
  •