MySQL installation

Discussion in 'OT Technology' started by ChatChai, Jul 1, 2006.

  1. ChatChai

    ChatChai OT Supporter

    Joined:
    May 6, 2005
    Messages:
    376
    Likes Received:
    0
    Location:
    Corona, CA
    I'm installing MySQL 4.1 and I am running into problems. I have no previous knowledge of MySQL but I am trying to get it to work for another program to use. I tried testing MySQL and I get this error:

    nnoDB: Errror: log file .\ib_logfile0 is of different stize 0 10485760 bytes
    InnoDB: than specified in the .cnf file 0 5242880 bytes!
    060627 17:55:47 [ERROR] Can't init databases
    060627 17:55:47 [ERROR] Aborting

    060627 17:55:47 [Note] c:\mysql\bin\mysqld: Shutdown complete

    I've been trying the MySQL forums for the last two weeks and responses are slow and have not helped much.

    Windows 2003 (SBS edition)
    IIS 6.0

    Let me know if you need addtional information. Thanks
     
  2. P07r0457

    P07r0457 New Member

    Joined:
    Sep 20, 2004
    Messages:
    28,491
    Likes Received:
    0
    Location:
    Southern Oregon
    wow, it's pretty bad that you screwed up what is only a point-n-click .msi... :rolleyes:

    uninstall and try again.

    Otherwise, look in the .cnf file and see whats there, but that is WAAAAY over your head, so just start over.
     
  3. P07r0457

    P07r0457 New Member

    Joined:
    Sep 20, 2004
    Messages:
    28,491
    Likes Received:
    0
    Location:
    Southern Oregon
    MSDE and MySQL co-exist without conflict. MSDE uses TCP:1433, and MySQL uses TCP:3306, so no conflict.

    His error is due to a db file that does not match it's expected size (as specified in the config). As this is a new installation, deleting the data files, starting over is the best approach.
     
  4. ChatChai

    ChatChai OT Supporter

    Joined:
    May 6, 2005
    Messages:
    376
    Likes Received:
    0
    Location:
    Corona, CA
    Point and click yes. Is it working no. Uninstalled it again and ran the setup. Installed it to C:\MySQL and then log into my MySQL.com account. Success. It is asking me to "Configure the MySQL Server now," Though I have before by using the standard configuration I chose not to configure now this time. I type in this to test:

    c:\mysql\bin\mysqld --console

    I get this below it now:

    [​IMG]
     
  5. Peyomp

    Peyomp New Member

    Joined:
    Jan 11, 2002
    Messages:
    14,017
    Likes Received:
    0
    I can't help, but I had issues installing MySQL on OS X the other day. Permissions problems and some directories I had to manually mkdir. And I'm not stupid. Luckily a friend had the same problem the day before on Solaris 10, and has a super MySQL AB support contract for his office, and he was able to resolve the problem quickly.
     
  6. Peyomp

    Peyomp New Member

    Joined:
    Jan 11, 2002
    Messages:
    14,017
    Likes Received:
    0
    Looks like its okay?
     
  7. ChatChai

    ChatChai OT Supporter

    Joined:
    May 6, 2005
    Messages:
    376
    Likes Received:
    0
    Location:
    Corona, CA
    so all that mumbo jumbo above I don't have to worry about? I guess I am only asking because the walkthrough that I was following displayed this if it was successful:

    040807 13:06:46 InnoDB: Started
    C:\MySQL\bin\mysqld: ready for connections.
    Version: ‘4.0.20a-debug’ socket: ‘’ port: 3306

    It did help that Jolly said to reinstall the only thing I did different was not go through the configure server wizard. Thanks everyone.
     
  8. Peyomp

    Peyomp New Member

    Joined:
    Jan 11, 2002
    Messages:
    14,017
    Likes Received:
    0
    Well, go to the command line and type "mysql"

    The command should be in c:\Mysql\bin

    If it asks for a user try "Mysql -u root"

    If you connect, its working.
     

Share This Page