Home
Join
check
  • I think I've fixed it. Finally!... 8P

    Per this link, I deleted the following files...

    ib_logfile0
    ib_logfile1
    ibdata1
    $YOUR_HOSTNAME$.err

    ...from the following paths...

    C:\Program Files\MySQL\MySQL Server 5.5\data

    C:\ProgramData\MySQL\MySQL Server 5.5\data

    Then the wizard let me choose an InnoDB Database!

    Was this post helpful? thumb_up thumb_down
  • View Best Answer in replies below

    25 Replies

    • Is the service running under the same account that you are using to start it from the command line?  Also is mysql in PATH variable?

       

       

      Spice (1) flagReport
      Was this post helpful? thumb_up thumb_down
    • The MySQL55 service is running as the Local System account. I am logged in as domain admin. Should I configure it to use the domain admin?

      It's not in the path variable. Should I just add C:\Program Files\MySQL\MySQL Server 5.5\bin to the path variable?

      Was this post helpful? thumb_up thumb_down
    • For performance reasons, I strongly recommend moving MySQL to UNIX.  The difference is staggering.  Plus it is dramatically easier to deploy, manage and patch.

      Spice (1) flagReport
      Was this post helpful? thumb_up thumb_down
    • I would add mysql\bin to your PATH and give it a try if that does not work you can change the service account it uses.  If you are still having issues MySQL will throw errors into the Windows Application log and there is also a mysql error log int he mysql data directory.  Usually it is the hostname of the system .err

      Spice (1) flagReport
      Was this post helpful? thumb_up thumb_down
    • Scott, I am a avid Linux fan/admin but this one has to be Windows for reasons I'll not outline here. So I set the service to run as the domain admin just for now. I'll change it to a service account when troubleshooting is finished. I also added the path as shown in a previous post. Still no joy!

      The path to the executable under the service shows this:

      "C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.5\my.ini" MySQL55

      Any more ideas??

      Was this post helpful? thumb_up thumb_down
    • Event Viewer shows this:

      TCP/IP, --shared-memory, or --named-pipe should be configured on NT OS

      Was this post helpful? thumb_up thumb_down
    • ??

      My ini file is not located where the data directory is but where the program file is.

      C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld" --defaults-file="C:\Program Files\MySQL\MySQL Server 5.1\my.ini" MySQL

       

      Is your my.ini really in:  C:\ProgramData\MySQL\MySQL Server 5.5\my.ini"    or is it in:  C:\Program Files\MySQL\MySQL Server 5.1\

      Just guessing now!

      Was this post helpful? thumb_up thumb_down
    • Oh, that's likely the issue then, lol...my.ini is currently located here:

      C:\Program Files\MySQL\MySQL Server 5.5

      Which is the proper place for it to be?

      Was this post helpful? thumb_up thumb_down
    • where it currently is is the default location.

      Spice (1) flagReport
      Was this post helpful? thumb_up thumb_down
    • Wonder how the service got misconfigured. How do I reconfigure the service? (duh)

      Was this post helpful? thumb_up thumb_down
    • maybe another way via command line but if not :

      use regedit


      Then go to
      HKEY_LOCAL_MACHINE
      SYSTEM
      CurrentControlSet
      Services
      Service_Name

      Imagepath

      Spice (1) flagReport
      Was this post helpful? thumb_up thumb_down
    • Cool, I changed it to point to the current location of my.ini but now I get a different error:

       

      Windows could not start the MySQL55 service on Local Computer.

      Error 1053: The service did not respond to the start or control request in a timely fashion.

      Was this post helpful? thumb_up thumb_down
    • we are getting closer :) 

      Just for troubleshooting, is the service using the account that can start it via CLI

      see if MySQL err log has anything more useful  (it is  in data directory)

      post your my.ini

       

      Was this post helpful? thumb_up thumb_down
    • Same domain admin account, yes.

      Nothing in C:\Program Files\MySQL\MySQL Server 5.5\data\[hostname].err

      Sanitized my.ini attached. Thanks very much for your help so far!

      attach_file Attachment my.ini 9.3 KB
      Was this post helpful? thumb_up thumb_down
    • I understand why it wasn't working before (not pointing to my.ini) but now the service is basically executing the same program and my.ini and it will not start.  I am fading here!!!  Anyone feel free to chime in.

      Given that the service install seemed a bit mis-configured, I would remove the service completely (sc delete < SERVICE name>) and re-add it with the instructions given in the my.ini: (maybe give it new service name  MySQL5

      To install the server as a Windows service manually, execute this in a
      # command line shell, e.g.
      # mysqld --install MySQL5 --defaults-file="C:\Program Files\MySQL\MySQL Server 5.5\my.ini"
      #
      # And then execute this in a command line shell to start the server, e.g.
      # net start MySQL5
      #

      Also, I am not completely current with version 5.5, but in the my.ini important things seem to be commented out, like what port MySQL should listen on?

      Spice (1) flagReport
      Was this post helpful? thumb_up thumb_down
    • Before I remove the service manually, I thought I would try the config wizard. I ran MySQLInstanceConfig.exe but it gave me an error which is attached.

      attach_file Attachment wizard.png 15.4 KB
      Was this post helpful? thumb_up thumb_down
    • ??

      do you have my.ini open?  if not  permissions issue?

      Was this post helpful? thumb_up thumb_down
    • my.ini is not open. Double checked permissions which look good. :/

      Was this post helpful? thumb_up thumb_down
    • ??  I would blow away service and try and re-create the service as previously mentioned.  

      Spice (1) flagReport
      Was this post helpful? thumb_up thumb_down
    • I deleted and then recreated the service and the symptoms changed a bit. Now the wizard is able to write the configuration but dies at trying to start the service. I then deleted the service without recreating it and allowed the wizard to configure/create the service but it still got stuck at starting the service.

      Was this post helpful? thumb_up thumb_down
    • This even happens if I delete the service, reboot and then let the wizard recreate the service (with a new name).

      Was this post helpful? thumb_up thumb_down
    • Aha! It only can start the service if I select the "Non-Transactional Database" in the wizard. Otherwise it fails to start the service! Hmmm...

      Was this post helpful? thumb_up thumb_down
    •  

      Just found these in Event Viewer...So for some reason it doesn't like InnoDB, only MyISAM!!??...

       


      1. Unknown/unsupported storage engine: INNODB

      2. Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

      3. Plugin 'InnoDB' init function returned error.

      Was this post helpful? thumb_up thumb_down
    • I think I've fixed it. Finally!... 8P

      Per this link, I deleted the following files...

      ib_logfile0
      ib_logfile1
      ibdata1
      $YOUR_HOSTNAME$.err

      ...from the following paths...

      C:\Program Files\MySQL\MySQL Server 5.5\data

      C:\ProgramData\MySQL\MySQL Server 5.5\data

      Then the wizard let me choose an InnoDB Database!

      Was this post helpful? thumb_up thumb_down
    • The service started even after a reboot and everything seems good so far!

      Was this post helpful? thumb_up thumb_down

    Read these next...

    • Snap! Reporting phishing in Teams, State of IT, Arc A770 graphics card, Optimus

      Snap! Reporting phishing in Teams, State of IT, Arc A770 graphics card, Optimus

      Spiceworks Originals

      Your daily dose of tech news, in brief. How is it already Monday? Actually, how is it already October 2022? It felt like SpiceWorld was just starting, and already it's over (for this year). But don't worry, the fun continues as this month is Cybers...

    • Can you run a print server on windows 10

      Can you run a print server on windows 10

      Windows

      I have many clients with no servers.  Looking for the best way to manage printers.If I share the printer then that machine that shares the printer needs to be online to print correct?   Having to always download the print driver and lookup the printers IP...

    • Lost of VDI rights on Windows 10 Enterprise E3

      Lost of VDI rights on Windows 10 Enterprise E3

      Software

      I am migration from standalone Windows 10 Enterprise E3 online subscription to Microsoft 365 E3 online subscription. However, I am seeing this in the terms.https://www.microsoft.com/licensing/terms/productoffering/Microsoft365/MOSADoes this mean I am losi...

    • Spark! Pro Series - 3rd October 2022

      Spark! Pro Series - 3rd October 2022

      Spiceworks Originals

      Welcome to Monday. I am currently sat at home in isolation, with my wife and I having succumbed to the dreaded Covid-19 after managing to avoid it for the last two and a half years! Still, it gives me the chance to indulge my fancy in yet another Spark! t...

    • What security best practices would you suggest?

      What security best practices would you suggest?

      Spiceworks

      It's Cybersecurity Awareness month, which if people took seriously, would likely be a great boon to all of ITkind. :)  The National Cybersecurity Alliance suggests some specific things that people can do to increase cybersecurity: Enabling multi-facto...