Re: Possible Fix FOR SERVER 2008
Ryan Banks Wrote:
-------------------------------------------------------
> 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 using the .msi file you used to install it.
>
Next delete both the install dir (where you
installed it, i.e. C:\Program Files\MySql\)
Now the important bit, For Windows Server 2008 the new software works
a little different. Instead of going to user data, delete the MySQL Folder in
ProgramDATA.
> 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 2008 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
>
i changed the server name from "MySQL" to "MySQL5", this may help!
>
> 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
I have now upgraded to Windows 2008 and endured this error again. The above is what i did different from 2003 and 2008 ( i have edited the quote, noticed what i have added doesn't have a leading ">" )
I wish you all good luck!
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
Re: Possible Fix FOR SERVER 2008
July 25, 2009 05:47PM
September 04, 2009 09:09AM
November 23, 2009 11:33AM
September 02, 2009 10:55PM
November 25, 2009 05:47AM