Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New Coder
    Join Date
    Aug 2006
    Location
    Kansas, USA
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Angry Can't start MySQL server

    Having trouble with install. Installed twice (on XP), first time when I hit execute in configuration wizard, it said it couldn't conect to the port (3303 i think) to check firewalls, etc.

    Looked around, turned off firewall and checked virus SW no luck.

    Uninstalled, reinstalled. Hit execute button and no longer get the nice message, just fails. In Windows event veiwer there's a mysql application error " Default storage engine (InnoDB) is not available"

    Me thinks a port problem but not sure how to fix.

    HELP!
    Firefox is the future Get Firefox

  • #2
    Regular Coder
    Join Date
    Jan 2007
    Posts
    213
    Thanks
    0
    Thanked 0 Times in 0 Posts
    This is a weird one, what firewall was you using?

    how are you starting mysql?
    Matthew Bagley
    Paramiliar Design Studios
    Website Design | Website Development | Search Engine Optimisation (SEO)

  • #3
    Senior Coder angst's Avatar
    Join Date
    Apr 2004
    Location
    Toronto, Ontario
    Posts
    2,114
    Thanks
    15
    Thanked 122 Times in 122 Posts
    firewall shouldn't make any difference since it's all local.

    are you sure that you've installed the correct mysql-server package for windows? because this sounds more like a mysql client problem.

  • #4
    nst
    nst is offline
    New Coder
    Join Date
    Jul 2005
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by hurloon View Post
    In Windows event veiwer there's a mysql application error " Default storage engine (InnoDB) is not available"
    Well, I would take seriously what the machine thinks that the problem is and change the line
    default-storage-engine=INNODB
    into
    default-storage-engine=MYISAM
    at C:\Program Files\MySQL\MySQL Server 5.0\my.ini (usually it's there)
    and then try again
    (you can altern. comment the line out by using #. It isn't really necessary)

    Maybe it will start. If it does then you must find out what the problem with INNODB tables is. Maybe something didn't go right during installation. Is it Windows XP SP2? Which exact version of MySql are you using?


  •  

    Posting Permissions

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