Fixing a Broken MySQL Windows Service

MySQL is an open source database system used by many of today’s popular products including WordPress, Facebook, and Google.  This post outlines how to fix a broken (refuses to start, stuck starting) MySQL Windows Service:

  1. Kill the MySQL process
    1. Launch Task Manager
    2. Under Processes, right click on the MySql process and select End Process
  2. Delete the InnoDB engine files located in the MySql/Data installation folder:
    1. ib_logfile0
    2. ib_logfile1
    3. ibdata1
  3. Start the MySQL Windows service

If the above did not work, try steps 1 and 2, run the MySQL Server Instance Config Wizard to “Reconfigure Instance” with your desired settings, and then perform step 3.

Technology
Technology