Posted on Sunday October 30, 2005 in Work
I thought I would share a solution to an error I kept getting when reconfiguring MySql.
Each time I would run the configuration manager, I would get an error:
could not start the service MySQL. Error: 0
This was super annoying, and as a result I stopped doing my Rails tutorial.
Then I found the answer: one has to delete three files, all located in the mysql/data directory:
*ib_logfile0
*ib_logfile1
*ibdata1
Deleting these files means that the Windows config wizard recreates them and the server starts without a hitch.
I also then restarted Windows after I reconfigured MySql just to make sure.