- Category: General Category
- Published on Sunday, 13 December 2009 18:12
- Hits: 4514
If the error comes MySQL refuses to start in Local Computer the simplest solution is to reinstall it.
First completely uninstall MySQL and reinstall. The tricky part is that the uninstall requires three steps:
1. Uninstall via Add/Remove Programs from the Control Panel.
2. Delete the Base directory — likely C:/Program Files/MySQL
3. Delete the Data directory — likely C:/Documents and Settings/All Users/Application Data/MySQL
Finding the Data directory may be a bit tricky, since the Application Data folder is hidden by default. If you change your Folder Options so you can view the Application Data folder and still cannot see it, type the path (from step 3) into Run from the Start Menu to open the folder.
Once you’ve uninstalled MySQL and deleted these two folders, you should be ready to start fresh!
Reinstalling may not have been the most expedient way to solve our own 1067 error, but since the uninstall itself wasn’t self-evident so it is better to reinstall it.
This is the easy way out.