Possible Fix
Ok so if like me you have tried every fix under the sun then read up, this may just work for you.
First i would like to pay respects to everyone who has tried to fix this and spent the time posting about it.
Okay, so my fix follows as so:
First remove ALL server instances, (Start, All programs, mySql, MySQL server instance config wizard) make sure to remove everything.
Next make sure no sql services are running (start, run, services.msc /r) (There shouldn't be if you have removed every instance)
Next uninstall MySQL (uninstall everything related in add and remove programs)
Next delete both the install dir (where you installed it, i.e. C:\Program Files\MySql)
Now the important bit, Remove all application data from every user, To do this go to your local drive (c:\ (or if you've changed it) next goto all users, application data (this may be hidden, (tools, show hidden files and folders) then delete MySql data) do this for ALL users!
Now restart, (this may not be required but it will stop ALL services and restart them).
------------------
Now when you are back in, reinstall the MySQL MSI package (for this i used 5.1)
Install as usual, next comes the hated config manager.
My settings for my 2003 windows server are as followed (if i dont list them, they are default)
Detailed Configuration
Server Machine
Multifunctional Database
Defualt dir
Decision support
Enable TCp (add expectation)
Enable Strict mode
Standard Char set
Default service name (some found changing it helps, i didn't keeping it default should work)
Also include bin directory
now this is where its make or break ( if you see current password, your database is still open and you must have missed a step, or you should look towards the REGEDIT steps listed in this thread)
-- If however you see just password and repeat then we are on track, now enter a password and repeat it.
before clicking next open up services again (services.msc /r) now click next and wait for that error (if you don't get it, then congrats) if you do however, now goto the services window and right click refresh, look for MySQL and check the status, if it is running, we are on track :) if not, again this hasn't worked and stop here.
with the service running, you will want to close the configuration windows and reopen it (to do this, Start, All programs, mySql, MySQL server instance config wizard) now goto reconfigure instance, follow it through all the way (next, next, next) till you get to the password page (last window) here it will say current password, leave this blank (this is because the configuration never made it to setting security) now enter a password of your choice, and hit next and execute.
Hopefully we should be looking at a successful windows displaying the service started!
Hope this helps guys :)
Ryan Banks
Subject
Written By
Posted
February 07, 2005 08:47AM
September 12, 2005 01:59PM
November 08, 2004 12:01PM
November 02, 2004 04:23AM
November 08, 2004 02:14PM
November 08, 2004 03:23PM
November 09, 2004 01:14PM
November 14, 2004 07:28PM
February 19, 2009 12:28PM
December 05, 2008 10:07PM
February 24, 2010 04:18AM
February 17, 2010 11:22AM
September 01, 2005 01:25PM
November 10, 2006 01:12PM
November 06, 2006 05:36PM
November 02, 2007 12:55PM
December 27, 2007 08:55PM
February 07, 2008 04:57PM
September 11, 2008 12:19AM
September 12, 2005 02:12PM
November 05, 2004 01:48PM
November 07, 2004 08:09PM
November 08, 2004 11:52AM
November 10, 2004 09:44AM
November 26, 2004 03:37PM
December 01, 2004 05:18PM
November 26, 2004 03:39PM
December 22, 2004 12:28PM
December 22, 2004 12:31PM
November 13, 2004 10:14PM
November 18, 2004 05:24PM
November 26, 2004 03:27PM
November 29, 2004 03:55PM
November 30, 2004 10:27AM
December 22, 2004 10:30AM
February 27, 2005 01:55PM
February 27, 2005 02:09PM
February 13, 2005 12:16PM
September 11, 2005 08:56PM
November 19, 2006 11:13PM
September 11, 2008 12:23AM
February 08, 2009 04:36AM
February 27, 2009 10:06AM
February 28, 2009 01:28PM
Possible Fix
July 01, 2009 05:46AM
September 04, 2009 09:09AM
November 23, 2009 11:33AM
September 02, 2009 10:55PM
November 25, 2009 05:47AM