MySQL starting issues after reinstall/upgrade

January 25, 2010 - 1:59am
Submitted by gary

Some of us might have experienced the problem of MySQL not starting after a reinstall or upgrading to a new version of SQL.
Please follow the guide below to fix the problem of starting MySQL.
 
1. run the uninstaller from windows add/remove program manager.
2. delete the database file folder (default is <mysqlInstalledPath>/bin/InnoDB Datafiles)
3. delete the mysql installation folder (default in windows is: Program Files/MySQL/)
4. now, go to documents and settings/username, or all user/Application Data(Hidden) folder, then delete the mysql folder.
5. open regedit from run, then do a search for "mysql" in the registery and if any mysql entries are not deleted, delete them. (Not the database type entry)
    (You can do a CCleaner scan to get rid of any mysql orphans in the registery)
Now run the new MySQL installer, essential or full msi is fine.
 
If after that you still can't get mysql to start, just do all the steps again, and upon installation, make the installation and database file folders more machine friendly. (No spaces)
And you should be good to go.
 
Please comment if you still have issues even after those steps.