MySQL Service not starting

By | April 5, 2019
  1. Create a backup of all current MySQL data and databases at C:\ProgramData\MySQL\MySQL Server n.n\data
  2. Open the C:\ProgramData\MySQL\MySQL Server n.n\my.ini file.
  3. Add the following line into the [MySQLD] section:
    innodb_force_recovery = 1
    skip-grant-tables
  4. Try to start MySQL.
  5. Stop MySQL service.
  6. Remove the line innodb_force_recovery from my.ini file and start MySQL.

Alternative

  1. Open: C:\ProgramData\MySQL\MySQL Server n.n\data
  2. Delete ib_logfile0 & ib_logfile1
  3. Start MySQL Service